APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 197: ,okc_k_party_roles_b cplb

193: ,okc_k_lines_tl clet
194: ,okc_k_lines_b cleb
195: ,okc_statuses_b stsb
196: ,okc_line_styles_b lseb
197: ,okc_k_party_roles_b cplb
198: WHERE kle.id = cleb.id
199: AND clet.id = cleb.id
200: AND clet.language = userenv('LANG')
201: AND cleb.dnz_chr_id = cp_chr_id

Line 819: ,okc_k_party_roles_b cplb

815: ,okc_k_lines_tl clet
816: ,okc_k_lines_b cleb
817: ,okc_statuses_b stsb
818: ,okc_line_styles_b lseb
819: ,okc_k_party_roles_b cplb
820: WHERE kle.id = cleb.id
821: AND clet.id = cleb.id
822: AND clet.language = userenv('LANG')
823: AND cleb.dnz_chr_id = p_chr_id

Line 854: ,okc_k_party_roles_b cplb

850: ,okc_k_lines_tl clet
851: ,okc_k_lines_b cleb
852: ,okc_statuses_b stsb
853: ,okc_line_styles_b lseb
854: ,okc_k_party_roles_b cplb
855: WHERE kle.id = cleb.id
856: AND clet.id = cleb.id
857: AND clet.language = userenv('LANG')
858: AND cleb.id = p_cle_id

Line 884: ,okc_k_party_roles_b cplb

880: ,cleb.currency_code
881: ,kle.subsidy_id subsidy
882: FROM okc_k_lines_b cleb
883: ,okc_line_styles_b lseb
884: ,okc_k_party_roles_b cplb
885: ,okl_k_lines kle
886: WHERE cleb.dnz_chr_id = p_orig_chr_id
887: AND lseb.id = cleb.lse_id
888: AND lseb.lty_code = 'SUBSIDY'

Line 927: ,okc_k_party_roles_b cplb

923: ,kle.sty_id sty_id
924: ,asst_cleb.orig_system_id1 orig_asst_cle_id
925: FROM okc_k_lines_b asst_cleb
926: ,okc_statuses_b asst_sts
927: ,okc_k_party_roles_b cplb
928: ,okc_k_lines_tl clet
929: ,okl_k_lines kle
930: ,okc_line_styles_b lseb
931: ,okc_k_lines_b cleb