APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_FP_TXN_ACCUM

Line 625: pji_fp_txn_accum

621: txn_accum_header_id,
622: project_id,
623: named_role /*For bug 4590810 */
624: FROM
625: pji_fp_txn_accum
626: WHERE project_id = p_project_ids(i)
627: AND recvr_period_type='GL' --Bug#5356978
628: UNION ALL
629: SELECT

Line 639: pji_fp_txn_accum_header head,

635: WHERE project_id = p_project_ids(i)
636: AND recvr_period_type='GL' --Bug#5356978
637: )
638: ) accum,
639: pji_fp_txn_accum_header head,
640: pa_non_labor_resources nlr,
641: pa_resource_classes_b cls
642: WHERE
643: head.TXN_ACCUM_HEADER_ID = accum.TXN_ACCUM_HEADER_ID AND

Line 666: FROM pji_fp_txn_accum

662: FROM
663: (
664: SELECT
665: txn_accum_header_id,recvr_period_id
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) */

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

774: --END OLAP
775: FROM
776: (
777:
778: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
779: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
780: Retrieve Task / Project Level Data for PA/ GL Period
781: */
782: SELECT

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

857:
858: -- Added the following Two union all caluses to populate
859: -- data for nontime phase: Bug : 4224314
860: UNION ALL
861: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
862: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
863: Retrieve Task / Project Level Data for Non Time Phased Period
864: */
865: SELECT

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

1057:
1058: -- Added the following Two union all caluses to populate
1059: -- data for nontime phase: Bug : 4224314
1060: UNION ALL
1061: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
1062: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
1063: Retrieve Task / Project Level Data for Non Time Phased Period
1064: */
1065: SELECT /*+ ordered index (fin PJI_FM_AGGR_FIN8_U1) */ /* Added for bug 11843459 */

Line 1225: --from pji_fp_txn_Accum

1221: FROM
1222: (
1223: SELECT --DISTINCT /* Added distinct clause for Bug 9691708 */ -- Bug 15843264
1224: --Retreives actuals data by resource list as ITD amounts for TIME PHASED Calendar
1225: --from pji_fp_txn_Accum
1226: /*tmp4.TXN_SOURCE_ID, Commented for workplan progress */
1227: (null) SOURCE_ID,
1228: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
1229: accum.PROJECT_ID PROJECT_ID,

Line 1271: pji_fp_txn_accum accum,

1267: accum.CBS_ELEMENT_ID
1268: --End OLAP
1269: FROM
1270: pa_res_list_map_tmp4 tmp4,
1271: pji_fp_txn_accum accum,
1272: pji_time_cal_period_v time,
1273: pji_org_extr_info info
1274: WHERE
1275: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND

Line 1346: --from pji_fp_txn_Accum

1342: CBS_ELEMENT_ID
1343: FROM
1344: (
1345: SELECT --Retreives actuals data by resource list as ITD amounts for NON-TIME PHASED Calendar
1346: --from pji_fp_txn_Accum
1347: /*tmp4.TXN_SOURCE_ID, Commented for workplan progress */
1348: (null) SOURCE_ID,
1349: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
1350: accum.PROJECT_ID PROJECT_ID,

Line 1392: pji_fp_txn_accum accum,

1388: accum.CBS_ELEMENT_ID
1389: -- End OLAP
1390: FROM
1391: pa_res_list_map_tmp4 tmp4,
1392: pji_fp_txn_accum accum,
1393: pji_time_cal_period_v time
1394: WHERE
1395: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
1396: accum.PROJECT_ID = p_project_ids(i) AND