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 di.project_id = did.project_id /* Added for bug 8505010*/
42:

Line 61: FROM pa_draft_invoices_all di,

57: WHERE ccd.transfer_status_code in ('P','R')
58: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
59: AND (ccd.line_type = 'BL' OR
60: (Ccd.line_type = 'PC' AND EXISTS (SELECT 'X'
61: FROM pa_draft_invoices_all di,
62: Pa_draft_invoice_details_all did
63: WHERE di.draft_invoice_num = did.draft_invoice_num
64: AND di.project_id = did.project_id /* Added for bug 8505010*/
65: AND ccd.reference_1 = did.draft_invoice_detail_id

Line 89: FROM pa_draft_invoices_all di,

85: WHERE ccd.transfer_status_code in ('P','R')
86: AND (p_gl_category is null OR ccd.line_type = p_gl_category)
87: AND (ccd.line_type = 'BL' OR
88: (ccd.line_type = 'PC' AND EXISTS (SELECT 'X'
89: FROM pa_draft_invoices_all di,
90: pa_draft_invoice_details_all did
91: WHERE di.draft_invoice_num = did.draft_invoice_num
92: AND di.project_id = did.project_id /* Added for bug 8505010*/
93: AND ccd.reference_1 = did.draft_invoice_detail_id

Line 162: FROM pa_draft_invoices_all di,

158: AND CCD.transfer_status_code IN ('P', 'R')
159: AND (p_gl_category IS NULL OR CCD.line_type = p_gl_category)
160: AND (CCD.line_type = 'BL'
161: OR (CCD.line_type = 'PC' AND EXISTS (SELECT 'X'
162: FROM pa_draft_invoices_all di,
163: Pa_draft_invoice_details_all did
164: WHERE di.draft_invoice_num = did.draft_invoice_num
165: AND di.project_id = did.project_id /* Added for bug 8505010*/
166: AND ccd.reference_1 = did.draft_invoice_detail_id