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 1875: , pji_time_cal_period_v pji_time

1871: ) plr
1872: ---- End of first inline view plr ..........
1873: , PJI_ORG_EXTR_INFO orginfo
1874: , PJI_FM_EXTR_PLNVER3_T vers
1875: , pji_time_cal_period_v pji_time
1876: WHERE 1=1
1877: -- AND orginfo.projfunc_currency_mau is not NULL
1878: AND plr.project_org_id = orginfo.org_id
1879: AND plr.project_id = vers.project_id

Line 2612: , pji_time_cal_period_v prd

2608: , PJI_FM_EXTR_PLNVER3_T ver
2609: , pa_projects_all ppa
2610: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2611: , PJI_FM_AGGR_DLY_RATES_T rates
2612: , pji_time_cal_period_v prd
2613: , PJI_ORG_EXTR_INFO oei
2614: , pji_fp_txn_accum_header hdr
2615: , pa_rbs_txn_accum_map map
2616: , pji_pjp_rbs_header rhdr

Line 3673: , pji_time_cal_period_v prd

3669: , PJI_FM_EXTR_PLNVER3_T ver
3670: , pa_projects_all ppa
3671: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3672: , PJI_FM_AGGR_DLY_RATES_T rates
3673: , pji_time_cal_period_v prd
3674: , PJI_ORG_EXTR_INFO oei
3675: WHERE 1=1
3676: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3677: AND ra.project_id = ver.PROJECT_ID

Line 5000: , pji_time_cal_period_v pji_time

4996: ) plr
4997: ---- End of first inline view plr ..........
4998: , PJI_ORG_EXTR_INFO orginfo
4999: , PJI_FM_EXTR_PLNVER3_T vers
5000: , pji_time_cal_period_v pji_time
5001: WHERE 1=1
5002: AND plr.project_org_id = orginfo.org_id
5003: AND plr.project_id = vers.project_id
5004: AND plr.budget_version_id = vers.plan_version_id

Line 5216: , pji_time_cal_period_v prd

5212: , l_gl1_mau mau1
5213: , l_gl2_mau mau2
5214: FROM pa_budget_lines bl
5215: , pa_budget_versions bv -- added for bug 5842896
5216: , pji_time_cal_period_v prd
5217: , PJI_FM_EXTR_PLNVER3_T ver
5218: , pa_projects_all ppa
5219: ,PJI_ORG_EXTR_INFO inf
5220: WHERE bl.budget_version_id = ver.plan_version_id

Line 5277: pji_time_cal_period_v prd,

5273: SET rate_dangling_flag = 'Y'
5274: WHERE (project_id,plan_version_id) IN
5275: ( SELECT project_id,budget_version_id
5276: FROM PA_BUDGET_LINES bl,
5277: pji_time_cal_period_v prd,
5278: PJI_FM_AGGR_DLY_RATES_T rates
5279: WHERE rates.time_id=prd.cal_period_id
5280: AND bl.period_name = prd.name
5281: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)

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

5888: UNION
5889: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5890: ) curr
5891: , PJI_FM_AGGR_DLY_RATES_T rates
5892: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5893: UNION ALL
5894: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
5895: ) dates
5896: , pji_fm_extr_plnver3_t ver

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

6000: UNION
6001: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
6002: ) curr
6003: , PJI_FM_AGGR_DLY_RATES_T rates
6004: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6005: UNION ALL
6006: SELECT ent_period_id, start_date, end_date FROM pji_time_ent_period_v
6007: ) dates
6008: , pji_fm_extr_plnver3_t ver

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

6305: SELECT
6306: fact.PLAN_VERSION_ID
6307: FROM pji_fp_aggr_pjp1_t fact
6308: , PJI_FM_AGGR_DLY_RATES_T rates
6309: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
6310: UNION ALL
6311: SELECT cal_qtr_id, start_date, end_date FROM pji_time_cal_qtr_v
6312: UNION ALL
6313: SELECT cal_year_id, start_date, end_date FROM pji_time_cal_year_v

Line 7315: , pji_time_cal_period_v pji_time

7311: ) plr
7312: ---- End of first inline view plr ..........
7313: , PJI_ORG_EXTR_INFO orginfo
7314: , PJI_FM_EXTR_PLNVER3_T vers
7315: , pji_time_cal_period_v pji_time
7316: WHERE 1=1
7317: AND plr.project_org_id = orginfo.org_id
7318: AND plr.project_id = vers.project_id
7319: AND plr.budget_version_id = vers.plan_version_id

Line 9267: , pji_time_cal_period_v cal

9263: , l_last_update_date
9264: , l_last_updated_by
9265: , l_last_update_login
9266: FROM PJI_FP_AGGR_PJP1_T pjp1
9267: , pji_time_cal_period_v cal
9268: WHERE
9269: pjp1.worker_id = g_worker_id
9270: AND pjp1.plan_version_id = whdr.plan_version_id
9271: AND pjp1.project_id = whdr.project_id

Line 9309: , pji_time_cal_period_v time

9305: SET TIME_DANGLING_FLAG = 'Y'
9306: WHERE plan_version_id IN
9307: (SELECT fact.plan_version_id
9308: FROM pji_fp_aggr_pjp1_t fact
9309: , pji_time_cal_period_v time
9310: , pji_org_extr_info orginfo
9311: WHERE fact.period_type_id = 32
9312: AND fact.worker_id = g_worker_id
9313: AND fact.calendar_type = 'P'

Line 9323: , pji_time_cal_period_v time

9319: SET TIME_DANGLING_FLAG = 'Y'
9320: WHERE plan_version_id IN
9321: (SELECT fact.plan_version_id
9322: FROM pji_fp_aggr_pjp1_t fact
9323: , pji_time_cal_period_v time
9324: , pji_org_extr_info orginfo
9325: WHERE fact.period_type_id = 32
9326: AND fact.worker_id = g_worker_id
9327: AND fact.calendar_type = 'G'