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 ccd.reference_1 = did.draft_invoice_detail_id
42: AND di.transfer_status_code = 'A')))
43: AND TRUNC (CCD.GL_Date) <= NVL (p_END_GL_DATE, CCD.GL_DATE)

Line 60: Pa_draft_invoice_details_all did

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')))
64: AND TRUNC (CCD.GL_DATE) <= NVL (p_END_GL_DATE, CCD.GL_DATE)

Line 87: pa_draft_invoice_details_all did

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')))
91: AND TRUNC (CCD.GL_DATE) <= NVL (p_END_GL_DATE, CCD.GL_DATE)

Line 159: Pa_draft_invoice_details_all did

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')))
163: AND TRUNC (CCD.GL_DATE) <= NVL (p_END_GL_DATE, CCD.GL_DATE)