APPS.PA_CC_GL_TRANS_CCDS dependencies on PA_DRAFT_INVOICE_DETAILS_ALL

Line 39: Pa_draft_invoice_details_all did

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:
43: AND ccd.reference_1 = did.draft_invoice_detail_id

Line 62: Pa_draft_invoice_details_all did

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
66: AND di.transfer_status_code = 'A')))

Line 90: pa_draft_invoice_details_all did

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
94: AND di.transfer_status_code = 'A')))

Line 163: Pa_draft_invoice_details_all did

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
167: AND di.transfer_status_code = 'A')))