eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_TIME_CAL_PERIOD_V

Line 1349: , pji_time_cal_period_v non_pa_cal

1345: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
1346: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
1347: , fact.plan_type_code plan_type_code
1348: FROM pji_fp_aggr_pjp1 fact
1349: , pji_time_cal_period_v non_pa_cal
1350: , pji_time_ent_period_v pa_cal
1351: , pji_fm_extr_plnver4 ver
1352: , (SELECT currency_code,
1353: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 1946: pji_time_cal_period_v pri

1942: pri.cal_period_id pri_cal_period_id,
1943: sec.cal_period_id sec_cal_period_id,
1944: orginfo.org_id
1945: FROM
1946: pji_time_cal_period_v pri
1947: , pji_org_extr_info orginfo
1948: , pji_time_cal_period_v sec
1949: , pji_fm_extr_plnver4 ver
1950: , pa_projects_all ppa

Line 1948: , pji_time_cal_period_v sec

1944: orginfo.org_id
1945: FROM
1946: pji_time_cal_period_v pri
1947: , pji_org_extr_info orginfo
1948: , pji_time_cal_period_v sec
1949: , pji_fm_extr_plnver4 ver
1950: , pa_projects_all ppa
1951: WHERE 1=1
1952: AND ppa.org_id=orginfo.org_id

Line 2259: , pji_time_cal_period_v pa_cal

2255: / (fact.end_date - fact.start_date+1) factor
2256: , fact.plan_type_code plan_type_code
2257: FROM pji_fp_aggr_pjp1 fact
2258: , pji_org_extr_info orginfo
2259: , pji_time_cal_period_v pa_cal
2260: , pji_fm_extr_plnver4 ver
2261: ,(SELECT currency_code,
2262: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
2263: null, 0.01,

Line 2788: , pji_time_cal_period_v prd

2784: , prd.end_date
2785: , TO_DATE(NULL)
2786: ) end_date
2787: FROM pa_budget_lines bl
2788: , pji_time_cal_period_v prd
2789: , PJI_FM_EXTR_PLNVER4 ver
2790: , pa_projects_all ppa
2791: ,PJI_ORG_EXTR_INFO inf
2792: WHERE 1=1

Line 2848: pji_time_cal_period_v prd,

2844: SET rate_dangling_flag = 'Y'
2845: WHERE EXISTS
2846: ( SELECT NULL
2847: FROM PA_BUDGET_LINES bl,
2848: pji_time_cal_period_v prd,
2849: PJI_FM_AGGR_DLY_RATES rates
2850: WHERE rates.time_id=prd.cal_period_id
2851: AND bl.period_name = prd.name
2852: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

Line 3024: , pji_time_cal_period_v cal

3020: , whdr.PLAN_TYPE_CODE
3021: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
3022: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
3023: FROM PJI_FP_AGGR_PJP1 pjp1
3024: , pji_time_cal_period_v cal
3025: , pji_pjp_wbs_header whdr
3026: WHERE
3027: pjp1.worker_id = g_worker_id
3028: AND pjp1.project_id = whdr.project_id

Line 3783: , pji_time_cal_period_v prd

3779: , pa_resource_asSIGNments ra
3780: , PA_BUDGET_LINES bl
3781: , pa_projects_all ppa
3782: , PJI_ORG_EXTR_INFO oei
3783: , pji_time_cal_period_v prd
3784: , PJI_FM_AGGR_DLY_RATES rates
3785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3786: WHERE 1=1
3787: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 4407: , pji_time_cal_period_v cal

4403: , pjp1.PLAN_TYPE_CODE
4404: , MIN(cal.start_date) min_txn_date
4405: , MAX(cal.end_date) max_txn_date
4406: FROM PJI_FP_AGGR_PJP1 pjp1
4407: , pji_time_cal_period_v cal
4408: WHERE
4409: pjp1.worker_id = g_worker_id
4410: AND pjp1.time_id = cal.cal_period_id
4411: AND pjp1.calendar_type IN ('P', 'G')

Line 4427: , pji_time_cal_period_v cal

4423: , pjp2.PLAN_TYPE_CODE
4424: , MIN(cal.start_date) min_txn_date
4425: , MAX(cal.end_date) max_txn_date
4426: FROM PJI_FP_AGGR_PJP2 pjp2
4427: , pji_time_cal_period_v cal
4428: WHERE
4429: pjp2.worker_id = g_worker_id
4430: AND pjp2.time_id = cal.cal_period_id
4431: AND pjp2.calendar_type IN ('P', 'G')