DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_IB_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 430: FROM HZ_PARTIES P, OKC_K_PARTY_ROLES_B OKPRV

426: */
427: Begin
428: SELECT P.PARTY_ID
429: INTO l_party_id
430: FROM HZ_PARTIES P, OKC_K_PARTY_ROLES_B OKPRV
431: WHERE OKPRV.chr_id = p_chrv_id
432: AND OKPRV.rle_code = 'LESSEE'
433: AND OKPRV.jtot_object1_code = 'OKX_PARTY'
434: AND p.PARTY_ID = OKPRV.object1_id1

Line 2421: FROM OKC_K_PARTY_ROLES_B cplb,

2417: chr.start_date,
2418: cplb.object1_id1,
2419: chr.cust_acct_id,
2420: chr.scs_code
2421: FROM OKC_K_PARTY_ROLES_B cplb,
2422: OKC_RULES_B rul,
2423: OKL_K_HEADERS khr,
2424: OKC_K_HEADERS_B chr
2425: WHERE cplb.chr_id = chr.id