APPS.PJI_FM_EXTR dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1208: From pa_cost_distribution_lines_all cdl

1204: , cdl.Quantity AS QUANTITY
1205: , decode(cdl.Billable_Flag
1206: , 'Y', cdl.Quantity
1207: , 0) AS BILL_QUANTITY
1208: From pa_cost_distribution_lines_all cdl
1209: Where 1 = 1
1210: And cdl.line_type in ('R','I')
1211: And nvl(cdl.pji_summarized_flag,'Y') <> 'N'
1212: And cdl.gl_date is not null

Line 1589: PA_COST_DISTRIBUTION_LINES_ALL cdl

1585: , null
1586: , cdl.PJI_SUMMARIZED_FLAG
1587: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold)
1588: FROM
1589: PA_COST_DISTRIBUTION_LINES_ALL cdl
1590: WHERE
1591: cdl.LINE_TYPE in ('R', 'I') and
1592: cdl.PJI_SUMMARIZED_FLAG = 'N';
1593:

Line 1633: , pa_cost_distribution_lines_all cdl

1629: , bat.project_type_class
1630: , cdl.pji_summarized_flag
1631: FROM
1632: pji_fm_proj_batch_map bat
1633: , pa_cost_distribution_lines_all cdl
1634: WHERE
1635: bat.worker_id = p_worker_id
1636: and cdl.project_id = bat.project_id
1637: and cdl.line_type in ('R','I')

Line 1654: , pa_cost_distribution_lines_all cdl

1650: , bat.project_type_class
1651: , cdl.pji_summarized_flag
1652: FROM
1653: pji_fm_proj_batch_map bat
1654: , pa_cost_distribution_lines_all cdl
1655: WHERE
1656: bat.worker_id = p_worker_id
1657: and cdl.project_id = bat.project_id
1658: and cdl.line_type in ('R','I')

Line 2176: , pa_cost_distribution_lines_all cdl

2172: , 'Y', cdl.Quantity
2173: , 0) AS BILL_QUANTITY
2174: FROM
2175: PJI_FM_REXT_CDL scope
2176: , pa_cost_distribution_lines_all cdl
2177: , pa_expenditure_items_all ei
2178: , pa_expenditures_all exp
2179: , pa_expenditure_types et
2180: WHERE

Line 2443: update PA_COST_DISTRIBUTION_LINES_ALL cdl

2439: if (sql%rowcount <> 0) then
2440:
2441: commit;
2442:
2443: update PA_COST_DISTRIBUTION_LINES_ALL cdl
2444: set cdl.PJI_SUMMARIZED_FLAG = null
2445: where cdl.ROWID in (select /*+ cardinality(cdl, 1) */
2446: cdl.CDL_ROWID
2447: from PJI_FM_REXT_CDL cdl