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 772: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM

768: EQUIPMENT_HOURS, MIN_START_DATE, MAX_END_DATE
769: FROM
770: (
771:
772: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
773: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
774: Retrieve Task / Project Level Data for PA/ GL Period
775: */
776: SELECT

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

844:
845: -- Added the following Two union all caluses to populate
846: -- data for nontime phase: Bug : 4224314
847: UNION ALL
848: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
849: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
850: Retrieve Task / Project Level Data for Non Time Phased Period
851: */
852: SELECT

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

1024:
1025: -- Added the following Two union all caluses to populate
1026: -- data for nontime phase: Bug : 4224314
1027: UNION ALL
1028: /* Below select statment is added for workplan progress (periodic data) from PJI_FP_TXN_ACCUM
1029: To identify those records check for period_flag ='Y'. This is for FULL and PARTIAL
1030: Retrieve Task / Project Level Data for Non Time Phased Period
1031: */
1032: SELECT

Line 1175: --from pji_fp_txn_Accum

1171: MAX(END_DATE) MAX_END_DATE
1172: FROM
1173: (
1174: SELECT --Retreives actuals data by resource list as ITD amounts for TIME PHASED Calendar
1175: --from pji_fp_txn_Accum
1176: /*tmp4.TXN_SOURCE_ID, Commented for workplan progress */
1177: (null) SOURCE_ID,
1178: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
1179: accum.PROJECT_ID PROJECT_ID,

Line 1218: pji_fp_txn_accum accum,

1214: time.START_DATE,
1215: time.END_DATE
1216: FROM
1217: pa_res_list_map_tmp4 tmp4,
1218: pji_fp_txn_accum accum,
1219: pji_time_cal_period_v time,
1220: pji_org_extr_info info
1221: WHERE
1222: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND

Line 1288: --from pji_fp_txn_Accum

1284: MAX(END_DATE) MAX_END_DATE
1285: FROM
1286: (
1287: SELECT --Retreives actuals data by resource list as ITD amounts for NON-TIME PHASED Calendar
1288: --from pji_fp_txn_Accum
1289: /*tmp4.TXN_SOURCE_ID, Commented for workplan progress */
1290: (null) SOURCE_ID,
1291: tmp4.RESOURCE_LIST_MEMBER_ID RES_LIST_MEMBER_ID,
1292: accum.PROJECT_ID PROJECT_ID,

Line 1331: pji_fp_txn_accum accum,

1327: time.START_DATE,
1328: time.END_DATE
1329: FROM
1330: pa_res_list_map_tmp4 tmp4,
1331: pji_fp_txn_accum accum,
1332: pji_time_cal_period_v time
1333: WHERE
1334: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
1335: accum.PROJECT_ID = p_project_ids(i) AND