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_FM_PLAN_MAINT_T_PVT dependencies on PJI_TIME_CAL_PERIOD_V

Line 1833: , pji_time_cal_period_v pji_time

1829: ) plr
1830: ---- End of first inline view plr ..........
1831: , PJI_ORG_EXTR_INFO orginfo
1832: , PJI_FM_EXTR_PLNVER3_T vers
1833: , pji_time_cal_period_v pji_time
1834: WHERE 1=1
1835: -- AND orginfo.projfunc_currency_mau is not NULL
1836: AND plr.project_org_id = orginfo.org_id
1837: AND plr.project_id = vers.project_id

Line 2545: , pji_time_cal_period_v prd

2541: , PJI_FM_EXTR_PLNVER3_T ver
2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2544: , PJI_FM_AGGR_DLY_RATES_T rates
2545: , pji_time_cal_period_v prd
2546: , PJI_ORG_EXTR_INFO oei
2547: , pji_fp_txn_accum_header hdr
2548: , pa_rbs_txn_accum_map map
2549: , pji_pjp_rbs_header rhdr

Line 3589: , pji_time_cal_period_v prd

3585: , PJI_FM_EXTR_PLNVER3_T ver
3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3588: , PJI_FM_AGGR_DLY_RATES_T rates
3589: , pji_time_cal_period_v prd
3590: , PJI_ORG_EXTR_INFO oei
3591: WHERE 1=1
3592: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3593: AND ra.project_id = ver.PROJECT_ID

Line 4901: , pji_time_cal_period_v pji_time

4897: ) plr
4898: ---- End of first inline view plr ..........
4899: , PJI_ORG_EXTR_INFO orginfo
4900: , PJI_FM_EXTR_PLNVER3_T vers
4901: , pji_time_cal_period_v pji_time
4902: WHERE 1=1
4903: AND plr.project_org_id = orginfo.org_id
4904: AND plr.project_id = vers.project_id
4905: AND plr.budget_version_id = vers.plan_version_id

Line 5116: , pji_time_cal_period_v prd

5112: , l_gl1_mau mau1
5113: , l_gl2_mau mau2
5114: FROM pa_budget_lines bl
5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa
5119: ,PJI_ORG_EXTR_INFO inf
5120: WHERE bl.budget_version_id = ver.plan_version_id

Line 5176: pji_time_cal_period_v prd,

5172: SET rate_dangling_flag = 'Y'
5173: WHERE (project_id,plan_version_id) IN
5174: ( SELECT project_id,budget_version_id
5175: FROM PA_BUDGET_LINES bl,
5176: pji_time_cal_period_v prd,
5177: PJI_FM_AGGR_DLY_RATES_T rates
5178: WHERE rates.time_id=prd.cal_period_id
5179: AND bl.period_name = prd.name
5180: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

Line 5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5789: ) curr
5790: , PJI_FM_AGGR_DLY_RATES_T rates
5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5792: UNION ALL
5793: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5794: ) dates
5795: , pji_fm_extr_plnver3_t ver

Line 5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5901: ) curr
5902: , PJI_FM_AGGR_DLY_RATES_T rates
5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5904: UNION ALL
5905: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5906: ) dates
5907: , pji_fm_extr_plnver3_t ver

Line 6208: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v

6204: SELECT
6205: fact.PLAN_VERSION_ID
6206: FROM pji_fp_aggr_pjp1_t fact
6207: , PJI_FM_AGGR_DLY_RATES_T rates
6208: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6209: UNION ALL
6210: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v
6211: UNION ALL
6212: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v

Line 7182: , pji_time_cal_period_v pji_time

7178: ) plr
7179: ---- End of first inline view plr ..........
7180: , PJI_ORG_EXTR_INFO orginfo
7181: , PJI_FM_EXTR_PLNVER3_T vers
7182: , pji_time_cal_period_v pji_time
7183: WHERE 1=1
7184: AND plr.project_org_id = orginfo.org_id
7185: AND plr.project_id = vers.project_id
7186: AND plr.budget_version_id = vers.plan_version_id

Line 9119: , pji_time_cal_period_v cal

9115: , l_last_update_date
9116: , l_last_updated_by
9117: , l_last_update_login
9118: FROM PJI_FP_AGGR_PJP1_T pjp1
9119: , pji_time_cal_period_v cal
9120: WHERE
9121: pjp1.worker_id = g_worker_id
9122: AND pjp1.plan_version_id = whdr.plan_version_id
9123: AND pjp1.project_id = whdr.project_id

Line 9154: , pji_time_cal_period_v time

9150: SET TIME_DANGLING_FLAG = 'Y'
9151: WHERE plan_version_id IN
9152: (SELECT fact.plan_version_id
9153: FROM pji_fp_aggr_pjp1_t fact
9154: , pji_time_cal_period_v time
9155: , pji_org_extr_info orginfo
9156: WHERE fact.period_type_id = 32
9157: AND fact.worker_id = g_worker_id
9158: AND fact.calendar_type = 'P'

Line 9168: , pji_time_cal_period_v time

9164: SET TIME_DANGLING_FLAG = 'Y'
9165: WHERE plan_version_id IN
9166: (SELECT fact.plan_version_id
9167: FROM pji_fp_aggr_pjp1_t fact
9168: , pji_time_cal_period_v time
9169: , pji_org_extr_info orginfo
9170: WHERE fact.period_type_id = 32
9171: AND fact.worker_id = g_worker_id
9172: AND fact.calendar_type = 'G'