APPS.CSF_ACCESS_PKG dependencies on CSP_RS_CUST_RELATIONS

Line 1152: FROM csp_rs_cust_relations crcr

1148: )
1149: IS
1150: SELECT crcr.resource_id
1151: , hps.party_id
1152: FROM csp_rs_cust_relations crcr
1153: , hz_cust_acct_sites_all hcas_all
1154: , hz_party_sites hps
1155: WHERE crcr.customer_id = hcas_all.cust_account_id
1156: AND hcas_all.party_site_id = hps.party_site_id

Line 1162: rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE;

1158: AND crcr.resource_type = 'RS_EMPLOYEE';
1159:
1160: r_cust_relations c_cust_relations%ROWTYPE;
1161:
1162: rs_cust_relation_id csp_rs_cust_relations.rs_cust_relation_id%TYPE;
1163: BEGIN
1164: rs_cust_relation_id := csp_ship_to_address_pvt.g_rs_cust_relation_id;
1165:
1166: OPEN c_cust_relations

Line 1556: This procedure acts as a trigger on CSP_RS_CUST_RELATIONS

1552: Name:
1553: CUST_RELATIONS_TRIGGER_HANDLER
1554:
1555: Purpose:
1556: This procedure acts as a trigger on CSP_RS_CUST_RELATIONS
1557: and is fired in case of insert, update or delete.
1558:
1559: Arguments:
1560: