APPS.OKL_ARINTF_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 793: , OKC_K_PARTY_ROLES_B CPR

789: , khr.application_id app_id
790: , khr.BILL_TO_SITE_USE_ID
791: , khr.CURRENCY_CODE
792: FROM OKL_K_HEADERS_FULL_V khr
793: , OKC_K_PARTY_ROLES_B CPR
794: WHERE khr.ID = cpr.chr_id
795: AND cpr.rle_code = 'LESSEE'
796: AND khr.ID = cp_khr_id;
797:

Line 806: Okc_k_party_roles_b cpl

802: SELECT rul.object1_id1
803: FROM OKC_RULES_B rul,
804: Okc_rule_groups_B rgp,
805: Okc_rg_party_roles rpr,
806: Okc_k_party_roles_b cpl
807: WHERE rul.rgp_id = rgp.id AND
808: rgp.rgd_code = 'LAVENB' AND
809: rgp.dnz_chr_id = rgp.chr_id AND
810: rul.rule_information_category = 'LABACC' AND

Line 837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,

833: -- Bug# 11669781: changed the cursor for adding iby_fndcpt_pmt_chnnls_vl
834: /* CURSOR instrument_payment_use_id_csr(
835: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
840: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
841: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS

Line 858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,

854: -- bug 11886651
855: CURSOR instrument_payment_use_id_csr(
856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE

Line 921: Okc_k_party_roles_b cpl

917: SELECT rul.object1_id1
918: FROM OKC_RULES_B rul,
919: Okc_rule_groups_B rgp,
920: Okc_rg_party_roles rpr,
921: Okc_k_party_roles_b cpl
922: WHERE rul.rgp_id = rgp.id AND
923: rgp.rgd_code = 'LAVENB' AND
924: rul.rule_information_category = 'LAPMTH' AND
925: rgp.dnz_chr_id = p_khr_id AND

Line 1554: , OKC_K_PARTY_ROLES_B CPR

1550: , khr.application_id app_id
1551: , khr.BILL_TO_SITE_USE_ID
1552: , khr.CURRENCY_CODE
1553: FROM OKL_K_HEADERS_FULL_V khr
1554: , OKC_K_PARTY_ROLES_B CPR
1555: WHERE khr.ID = cpr.chr_id
1556: AND cpr.rle_code = 'LESSEE'
1557: AND khr.ID = cp_khr_id;
1558: chr_dtls_rec chr_dtls_csr%ROWTYPE;

Line 1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,

1594: -- sosharma 10167846 changed the cursor for adding iby_fndcpt_pmt_chnnls_vl
1595: --instrument_payment_use_id to be passed to IBY Bug 7162253
1596: /* CURSOR instrument_payment_use_id_csr(
1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1600: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1601: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
1602: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS

Line 1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,

1614:
1615: -- bug 11886651
1616: CURSOR instrument_payment_use_id_csr(
1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE

Line 2088: okc_k_party_roles_b opr

2084: ,iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
2085: FROM okl_trx_ar_invoices_b tai,
2086: okc_k_headers_b khr,
2087: hz_cust_accounts hca,
2088: okc_k_party_roles_b opr
2089: WHERE tai.khr_id = khr.id
2090: AND khr.cust_acct_id <> tai.ixx_id
2091: AND tai.ixx_id = hca.cust_account_id
2092: AND opr.dnz_chr_id = khr.id