DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_EXPENDITURES_ALL

Line 1287: , pa_expenditures_all exp

1283: And drev.gl_date is not null
1284: And drev.pa_date is not null
1285: ) CnR
1286: , pa_expenditure_items_all ei
1287: , pa_expenditures_all exp
1288: , pa_expenditure_types et
1289: WHERE 1 = 1
1290: And CnR.expenditure_item_id = ei.expenditure_item_id
1291: And exp.expenditure_id = ei.expenditure_id

Line 2189: , pa_expenditures_all exp

2185: FROM
2186: PJI_FM_REXT_CDL scope
2187: , pa_cost_distribution_lines_all cdl
2188: , pa_expenditure_items_all ei
2189: , pa_expenditures_all exp
2190: , pa_expenditure_types et
2191: WHERE
2192: scope.worker_id = p_worker_id
2193: and scope.cdl_rowid = cdl.rowid

Line 2292: , pa_expenditures_all exp

2288: FROM
2289: PJI_FM_REXT_CRDL scope
2290: , pa_cust_rev_dist_lines_all crdl
2291: , pa_expenditure_items_all ei
2292: , pa_expenditures_all exp
2293: , pa_expenditure_types et
2294: WHERE
2295: scope.worker_id = p_worker_id
2296: and scope.crdl_rowid = crdl.rowid