APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_FM_AGGR_FIN7

Line 634: pji_fm_aggr_fin7

630: txn_accum_header_id,
631: project_id,
632: named_role /*For bug 4590810 */
633: FROM
634: pji_fm_aggr_fin7
635: WHERE project_id = p_project_ids(i)
636: AND recvr_period_type='GL' --Bug#5356978
637: )
638: ) accum,

Line 670: SELECT /*+ index(pji_fm_aggr_fin7 pji_fm_aggr_fin7_n2) */

666: FROM pji_fp_txn_accum
667: WHERE recvr_period_type = 'GL'
668: and project_id = p_project_ids(i)
669: UNION ALL
670: SELECT /*+ index(pji_fm_aggr_fin7 pji_fm_aggr_fin7_n2) */
671: txn_accum_header_id,recvr_period_id
672: FROM pji_fm_aggr_fin7
673: WHERE recvr_period_type = 'GL'
674: and project_id = p_project_ids(i)

Line 672: FROM pji_fm_aggr_fin7

668: and project_id = p_project_ids(i)
669: UNION ALL
670: SELECT /*+ index(pji_fm_aggr_fin7 pji_fm_aggr_fin7_n2) */
671: txn_accum_header_id,recvr_period_id
672: FROM pji_fm_aggr_fin7
673: WHERE recvr_period_type = 'GL'
674: and project_id = p_project_ids(i)
675: )
676: GROUP BY txn_accum_header_id -- Bug#5262851

Line 978: /* Below select statment is added for workplan progress (periodic data) from PJI_FM_AGGR_FIN7

974: CBS_ELEMENT_ID
975: --End OLAP
976: FROM
977: (
978: /* Below select statment is added for workplan progress (periodic data) from PJI_FM_AGGR_FIN7
979: To identify those records check for period_flag ='Y'. This is for INCREMENTAL
980: Retrieve Task / Project Level Data for PA/ GL Period
981: */
982: SELECT /*+ ordered index (fin PJI_FM_AGGR_FIN8_U1) */ /* Added for bug 11843459 */