DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKC_GOVERNANCES

Line 2618: OKC_GOVERNANCES MLA_GOV

2614: WHERE KHR_OP.ID = TPL.KHR_ID -- link
2615: AND EXISTS (
2616: SELECT 1 -- MLA id
2617: FROM OKC_K_HEADERS_ALL_B KHR,
2618: OKC_GOVERNANCES MLA_GOV
2619: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2620: AND KHR.SCS_CODE = 'MASTER_LEASE'
2621: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2622: AND EXISTS (

Line 2625: OKC_GOVERNANCES CRD_GOV

2621: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2622: AND EXISTS (
2623: SELECT 1 -- credit line id
2624: FROM OKC_K_HEADERS_ALL_B CRD,
2625: OKC_GOVERNANCES CRD_GOV
2626: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2627: AND CRD.STS_CODE = 'ACTIVE'
2628: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2629: AND CRD.ID = p_creditline_id

Line 2644: OKC_GOVERNANCES CRD_GOV

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

Line 2691: OKC_GOVERNANCES MLA_GOV

2687: WHERE KHR_OP.ID = CN.ID -- link
2688: AND EXISTS (
2689: SELECT 1 -- MLA id
2690: FROM OKC_K_HEADERS_ALL_B KHR,
2691: OKC_GOVERNANCES MLA_GOV
2692: WHERE KHR.ID = MLA_GOV.CHR_ID_REFERRED
2693: AND KHR.SCS_CODE = 'MASTER_LEASE'
2694: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2695: AND EXISTS (

Line 2698: OKC_GOVERNANCES CRD_GOV

2694: AND MLA_GOV.DNZ_CHR_ID = KHR_OP.ID -- link
2695: AND EXISTS (
2696: SELECT 1 -- credit line id
2697: FROM OKC_K_HEADERS_ALL_B CRD,
2698: OKC_GOVERNANCES CRD_GOV
2699: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2700: AND CRD.STS_CODE = 'ACTIVE'
2701: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2702: AND CRD.ID = p_creditline_id

Line 2717: OKC_GOVERNANCES CRD_GOV

2713: AND KHR.SCS_CODE <> 'MASTER_LEASE'
2714: AND EXISTS (
2715: SELECT 1 -- credit line id
2716: FROM OKC_K_HEADERS_ALL_B CRD,
2717: OKC_GOVERNANCES CRD_GOV
2718: WHERE CRD.ID = CRD_GOV.CHR_ID_REFERRED
2719: AND CRD.STS_CODE = 'ACTIVE'
2720: AND KHR.ID = CRD_GOV.DNZ_CHR_ID -- link
2721: AND CRD.ID = p_creditline_id