DBA Data[Home] [Help]

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 122: FROM po_location_associations_all pla,

118: csu.site_use_id,
119: cas.status,
120: rcr.resource_id,
121: jtrs.user_id
122: FROM po_location_associations_all pla,
123: hz_cust_site_uses_all csu,
124: hz_cust_acct_sites_all cas,
125: csp_rs_cust_relations rcr,
126: hz_party_sites hps,