DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKC_GOVERNANCES

Line 2565: OKC_GOVERNANCES MLA_GOV

2561: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2562: AND EXISTS (
2563: SELECT 1 -- MLA id
2564: FROM OKC_K_HEADERS_ALL_B KHR,
2565: OKC_GOVERNANCES MLA_GOV
2566: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2567: AND KHR.SCS_CODE = 'MASTER_LEASE'
2568: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2569: AND EXISTS (

Line 2572: OKC_GOVERNANCES CRD_GOV

2568: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2569: AND EXISTS (
2570: SELECT 1 -- credit line id
2571: FROM OKC_K_HEADERS_ALL_B CRD,
2572: OKC_GOVERNANCES CRD_GOV
2573: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2574: AND CRD.STS_CODE = 'ACTIVE'
2575: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2576: AND CRD.ID = p_creditline_id

Line 2591: OKC_GOVERNANCES CRD_GOV

2587: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2588: AND EXISTS (
2589: SELECT 1 -- credit line id
2590: FROM OKC_K_HEADERS_ALL_B CRD,
2591: OKC_GOVERNANCES CRD_GOV
2592: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2593: AND CRD.STS_CODE = 'ACTIVE'
2594: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2595: AND CRD.ID = p_creditline_id

Line 2638: OKC_GOVERNANCES MLA_GOV

2634: WHERE KHR_OP.ID = CN.ID -- link
2635: AND EXISTS (
2636: SELECT 1 -- MLA id
2637: FROM OKC_K_HEADERS_ALL_B KHR,
2638: OKC_GOVERNANCES MLA_GOV
2639: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2640: AND KHR.SCS_CODE = 'MASTER_LEASE'
2641: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2642: AND EXISTS (

Line 2645: OKC_GOVERNANCES CRD_GOV

2641: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2642: AND EXISTS (
2643: SELECT 1 -- credit line id
2644: FROM OKC_K_HEADERS_ALL_B CRD,
2645: OKC_GOVERNANCES CRD_GOV
2646: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2647: AND CRD.STS_CODE = 'ACTIVE'
2648: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2649: AND CRD.ID = p_creditline_id

Line 2664: OKC_GOVERNANCES CRD_GOV

2660: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2661: AND EXISTS (
2662: SELECT 1 -- credit line id
2663: FROM OKC_K_HEADERS_ALL_B CRD,
2664: OKC_GOVERNANCES CRD_GOV
2665: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2666: AND CRD.STS_CODE = 'ACTIVE'
2667: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2668: AND CRD.ID = p_creditline_id