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 2422: FROM OKC_K_PARTY_ROLES_B cplb,

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

Line 2445: FROM OKC_K_PARTY_ROLES_B cplb,

2441: chr.start_date,
2442: cplb.object1_id1,
2443: chr.cust_acct_id,
2444: chr.scs_code
2445: FROM OKC_K_PARTY_ROLES_B cplb,
2446: OKL_K_HEADERS khr,
2447: OKC_K_HEADERS_B chr
2448: WHERE cplb.chr_id = chr.id
2449: AND cplb.dnz_chr_id = chr.id