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_FM_AGGR_DLY_RATES_T

Line 2544: , PJI_FM_AGGR_DLY_RATES_T rates

2540: , pa_resource_asSIGNments ra
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

Line 2847: , PJI_FM_AGGR_DLY_RATES_T rates

2843: , pa_resource_asSIGNments ra
2844: , PJI_FM_EXTR_PLNVER3_T ver
2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2847: , PJI_FM_AGGR_DLY_RATES_T rates
2848: -- , pji_time_cal_period prd
2849: -- , PJI_ORG_EXTR_INFO oei
2850: , pji_fp_txn_accum_header hdr
2851: , pa_rbs_txn_accum_map map

Line 3588: , PJI_FM_AGGR_DLY_RATES_T rates

3584: , pa_resource_asSIGNments ra
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

Line 3877: , PJI_FM_AGGR_DLY_RATES_T rates

3873: , pa_resource_asSIGNments ra
3874: , PJI_FM_EXTR_PLNVER3_T ver
3875: , pa_projects_all ppa
3876: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3877: , PJI_FM_AGGR_DLY_RATES_T rates
3878: WHERE 1=1
3879: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3880: AND ra.project_id = ver.PROJECT_ID
3881: AND ra.budget_version_id = ver.plan_version_id

Line 5059: DELETE FROM PJI_FM_AGGR_DLY_RATES_T

5055: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
5056: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
5057:
5058:
5059: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5060: WHERE worker_id = g_worker_id;
5061: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5062: -- for bug 4149422
5063: -- SQL for getting rates for time phased budgets.

Line 5066: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (

5062: -- for bug 4149422
5063: -- SQL for getting rates for time phased budgets.
5064: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5065:
5066: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (
5067: WORKER_ID ,
5068: PF_CURRENCY_CODE ,
5069: TIME_ID ,
5070: RATE ,

Line 5177: PJI_FM_AGGR_DLY_RATES_T rates

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)
5181: AND ver.time_phased_type_code IN ('P', 'G')

Line 5185: PJI_FM_AGGR_DLY_RATES_T rates

5181: AND ver.time_phased_type_code IN ('P', 'G')
5182: UNION ALL
5183: SELECT project_id,budget_version_id
5184: FROM pa_resource_assignments ra,
5185: PJI_FM_AGGR_DLY_RATES_T rates
5186: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5187: , 'S'
5188: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))
5189: , 'E'

Line 5214: DELETE FROM PJI_FM_AGGR_DLY_RATES_T

5210: BEGIN
5211:
5212: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Begin. ' );
5213:
5214: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5215: WHERE worker_id = g_worker_id;
5216:
5217: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5218:

Line 5790: , PJI_FM_AGGR_DLY_RATES_T rates

5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
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

Line 5902: , PJI_FM_AGGR_DLY_RATES_T rates

5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
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

Line 6207: , PJI_FM_AGGR_DLY_RATES_T rates

6203: WHERE plan_version_id IN (
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