APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_DRAFT_INVOICES_ALL

Line 38: FROM pa_draft_invoices_all di,

34: WHERE ccd.transfer_status_code in ('P','R')
35: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
36: AND (ccd.line_type = 'BL' OR
37: (Ccd.line_type = 'PC' AND EXISTS (SELECT 'X'
38: FROM pa_draft_invoices_all di,
39: Pa_draft_invoice_details_all did
40: WHERE di.draft_invoice_num = did.draft_invoice_num
41: AND ccd.reference_1 = did.draft_invoice_detail_id
42: AND di.transfer_status_code = 'A')))

Line 59: FROM pa_draft_invoices_all di,

55: WHERE ccd.transfer_status_code in ('P','R')
56: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
57: AND (ccd.line_type = 'BL' OR
58: (Ccd.line_type = 'PC' AND EXISTS (SELECT 'X'
59: FROM pa_draft_invoices_all di,
60: Pa_draft_invoice_details_all did
61: WHERE di.draft_invoice_num = did.draft_invoice_num
62: AND ccd.reference_1 = did.draft_invoice_detail_id
63: AND di.transfer_status_code = 'A')))

Line 86: FROM pa_draft_invoices_all di,

82: WHERE ccd.transfer_status_code in ('P','R')
83: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
84: AND (ccd.line_type = 'BL' OR
85: (ccd.line_type = 'PC' AND EXISTS (SELECT 'X'
86: FROM pa_draft_invoices_all di,
87: pa_draft_invoice_details_all did
88: WHERE di.draft_invoice_num = did.draft_invoice_num
89: AND ccd.reference_1 = did.draft_invoice_detail_id
90: AND di.transfer_status_code = 'A')))

Line 158: FROM pa_draft_invoices_all di,

154: AND CCD.transfer_status_code IN ('P', 'R')
155: AND (p_gl_category IS NULL OR CCD.line_type = p_gl_category)
156: AND (CCD.line_type = 'BL'
157: OR (CCD.line_type = 'PC' AND EXISTS (SELECT 'X'
158: FROM pa_draft_invoices_all di,
159: Pa_draft_invoice_details_all did
160: WHERE di.draft_invoice_num = did.draft_invoice_num
161: AND ccd.reference_1 = did.draft_invoice_detail_id
162: AND di.transfer_status_code = 'A')))