APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';

11: -- Person Date Comments
12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');

Line 128: FROM po_location_associations_all pla,

124: cas.org_id,
125: decode(rcr.resource_type,'RS_GROUP','G','E') resource_type,
126: cas.status,
127: au.user_id
128: FROM po_location_associations_all pla,
129: hz_cust_site_uses_all csu,
130: hz_cust_acct_sites_all cas,
131: csp_rs_cust_relations rcr,
132: asg_user au

Line 238: FROM po_location_associations_all pla,

234: pla.org_id ,
235: 'G' resource_type,
236: au.user_id ,
237: cas.party_site_id
238: FROM po_location_associations_all pla,
239: hz_cust_site_uses_all csu,
240: hz_cust_acct_sites_all cas,
241: csp_rs_cust_relations rcr,
242: asg_user au

Line 291: FROM po_location_associations_all pla,

287: acc.org_id ,
288: acc.resource_type,
289: acc.user_id,
290: cas.party_site_id
291: FROM po_location_associations_all pla,
292: csm_po_loc_ass_all_acc acc,
293: hz_cust_acct_sites_all cas,
294: asg_user au
295: WHERE acc.user_id = au.user_id AND acc.location_id = pla.location_id AND acc.org_id = pla.org_id AND acc.RESOURCE_TYPE= 'G'