APPS.OE_BULK_PROCESS_HEADER dependencies on HZ_CUST_SITE_USES_ALL

Line 222: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

218: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
219: l_org_id NUMBER;
220: l_legal_entity_id NUMBER;
221:
222: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
223: SELECT cust_acct.cust_account_id,
224: cust_Acct.party_id,
225: acct_site.party_site_id,
226: site_use.org_id

Line 228: HZ_CUST_SITE_USES_ALL site_use,

224: cust_Acct.party_id,
225: acct_site.party_site_id,
226: site_use.org_id
227: FROM
228: HZ_CUST_SITE_USES_ALL site_use,
229: HZ_CUST_ACCT_SITES_ALL acct_site,
230: HZ_CUST_ACCOUNTS_ALL cust_Acct
231: WHERE site_use.site_use_id = p_site_org_id
232: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1625: HZ_CUST_SITE_USES_ALL SITE,

1621:
1622: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1623: INTO l_dummy
1624: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1625: HZ_CUST_SITE_USES_ALL SITE,
1626: HZ_CUST_ACCT_SITES ADDR
1627: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1628: AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
1629: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'