DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_EXPENDITURE_TYPES

Line 1288: , pa_expenditure_types et

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
1292: And ei.expenditure_type = et.expenditure_type

Line 2190: , pa_expenditure_types et

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
2194: and cdl.expenditure_item_id = ei.expenditure_item_id

Line 2293: , pa_expenditure_types et

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
2297: and crdl.function_code NOT IN ('LRL','LRB','URL','URB')