DBA Data[Home] [Help]

APPS.GMS_PA_XFACE dependencies on PA_COST_DISTRIBUTION_LINES

Line 219: from pa_cost_distribution_lines CDL,

215: X_REF3 VARCHAR2(30);
216: CURSOR C_CDL IS
217: select CDL.system_reference2 , -- AP INVOICE_ID
218: CDL.system_reference3 -- AP DIST LINE NUM
219: from pa_cost_distribution_lines CDL,
220: ap_invoice_distributions ADL
221: where CDL.expenditure_item_id = X_expenditure_item_id
222: and CDL.system_reference2 = ADL.invoice_id
223: and CDL.system_reference3 = ADL.distribution_line_number