DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on HZ_CUST_SITE_USES_ALL

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

2329: l_rule_type VARCHAR2(10);
2330: l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
2331: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
2332:
2333: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
2334: SELECT cust_acct.cust_account_id,
2335: cust_Acct.party_id,
2336: acct_site.party_site_id,
2337: site_use.org_id

Line 2339: HZ_CUST_SITE_USES_ALL site_use,

2335: cust_Acct.party_id,
2336: acct_site.party_site_id,
2337: site_use.org_id
2338: FROM
2339: HZ_CUST_SITE_USES_ALL site_use,
2340: HZ_CUST_ACCT_SITES_ALL acct_site,
2341: HZ_CUST_ACCOUNTS_ALL cust_Acct
2342: WHERE site_use.site_use_id = p_site_org_id
2343: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id