 DECLARE
 	cursor c_data is
 	SELECT PROP_ID,RULE_ID FROM KRMS_PROP_T@KC_STAG_DB_LINK	
-	WHERE RULE_ID IN ( SELECT RULE_ID FROM KRMS_ACTN_T WHERE typ_id IN ( SELECT typ_id FROM krms_typ_t WHERE nm = 'Route to PeopleFlow') );
+	WHERE RULE_ID IN ( SELECT RULE_ID FROM KRMS_ACTN_T@KC_STAG_DB_LINK WHERE typ_id IN ( SELECT typ_id FROM krms_typ_t@KC_STAG_DB_LINK WHERE nm = 'Route to PeopleFlow') );
 	r_data c_data%rowtype;
 	ls_seq KRMS_PROP_T.PROP_ID%type;
 

DECLARE
	cursor c_data is
	SELECT a.ACTN_ID,a.RULE_ID FROM KRMS_ACTN_T@KC_STAG_DB_LINK a
	WHERE a.RULE_ID in ( SELECT RULE_ID FROM KRMS_ACTN_T WHERE typ_id IN ( SELECT typ_id FROM krms_typ_t WHERE nm = 'Route to PeopleFlow') );
	r_data c_data%rowtype;
	ls_seq KRMS_ACTN_T.ACTN_ID%type;


DECLARE
	cursor c_data is
	SELECT RULE_ID,PROP_ID FROM KRMS_RULE_T@KC_STAG_DB_LINK
	WHERE RULE_ID IN ( SELECT RULE_ID FROM KRMS_ACTN_T@KC_STAG_DB_LINK WHERE typ_id IN ( SELECT typ_id FROM krms_typ_t@KC_STAG_DB_LINK WHERE nm = 'Route to PeopleFlow') );
	r_data c_data%rowtype;
	
	ls_seq KRMS_RULE_T.RULE_ID%type;
