DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 666: select b.id from okc_k_party_roles_b b,okx_cust_site_uses_v a

662: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
663:
664: --sosharma bug 10288332 Added cursors to find cpl_id and quote type
665: Cursor role_info(c_khr_id IN NUMBER,c_site_id IN NUMBER,c_cust_id IN NUMBER) IS
666: select b.id from okc_k_party_roles_b b,okx_cust_site_uses_v a
667: where b.chr_id=c_khr_id
668: and b.bill_to_site_use_id = a.id1
669: and a.site_use_code='BILL_TO'
670: and a.cust_account_id=b.cust_acct_id

Line 3525: okc_k_party_roles_b kpr

3521: qpt.party_object1_id1 party_id1,
3522: qpt.party_object1_id2 party_id2,
3523: qpt.allocation_percentage allc_perc
3524: FROM okl_quote_parties qpt,
3525: okc_k_party_roles_b kpr
3526: WHERE qpt.qte_id = cp_quote_id
3527: AND qpt.qpt_code IN ('RECIPIENT','RECIPIENT_ADDITIONAL')
3528: AND kpr.id (+) = qpt.cpl_id
3529: AND qpt.allocation_percentage <> 0; -- rmunjulu bug 4341480