APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 66: FROM pa_cost_distribution_lines_all cdl,

62: CURSOR IsAdjNotXferToAP IS
63: SELECT 'ADJ NOT TRANSFERRED TO AP'
64: FROM dual
65: WHERE EXISTS (SELECT ei.expenditure_item_id
66: FROM pa_cost_distribution_lines_all cdl,
67: pa_expenditure_items_all ei
68: WHERE ei.expenditure_item_id = cdl.expenditure_item_id
69: AND ((cdl.transfer_status_code in ('P','R','X')
70: and ei.system_linkage_function = 'VI') or

Line 104: FROM pa_cost_distribution_lines_all pcdl,

100: CURSOR IsEiNotCapitalized IS
101: SELECT 'EXP ITEM NOT CAPITALIZED'
102: FROM dual
103: WHERE EXISTS ( SELECT pcdl.expenditure_item_id
104: FROM pa_cost_distribution_lines_all pcdl,
105: pa_expenditure_items_all pei,
106: pa_tasks pt,
107: pa_projects pp,
108: pa_project_types ppt