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 2611: , PJI_FM_AGGR_DLY_RATES_T rates

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

Line 2917: , PJI_FM_AGGR_DLY_RATES_T rates

2913: , pa_resource_asSIGNments ra
2914: , PJI_FM_EXTR_PLNVER3_T ver
2915: , pa_projects_all ppa
2916: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2917: , PJI_FM_AGGR_DLY_RATES_T rates
2918: -- , pji_time_cal_period prd
2919: -- , PJI_ORG_EXTR_INFO oei
2920: , pji_fp_txn_accum_header hdr
2921: , pa_rbs_txn_accum_map map

Line 3672: , PJI_FM_AGGR_DLY_RATES_T rates

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

Line 3964: , PJI_FM_AGGR_DLY_RATES_T rates

3960: , pa_resource_asSIGNments ra
3961: , PJI_FM_EXTR_PLNVER3_T ver
3962: , pa_projects_all ppa
3963: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3964: , PJI_FM_AGGR_DLY_RATES_T rates
3965: WHERE 1=1
3966: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3967: AND ra.project_id = ver.PROJECT_ID
3968: AND ra.budget_version_id = ver.plan_version_id

Line 5159: DELETE FROM PJI_FM_AGGR_DLY_RATES_T

5155: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
5156: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
5157:
5158:
5159: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5160: WHERE worker_id = g_worker_id;
5161: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5162: -- for bug 4149422
5163: -- SQL for getting rates for time phased budgets.

Line 5166: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (

5162: -- for bug 4149422
5163: -- SQL for getting rates for time phased budgets.
5164: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5165:
5166: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (
5167: WORKER_ID ,
5168: PF_CURRENCY_CODE ,
5169: TIME_ID ,
5170: RATE ,

Line 5278: PJI_FM_AGGR_DLY_RATES_T rates

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

Line 5286: PJI_FM_AGGR_DLY_RATES_T rates

5282: AND ver.time_phased_type_code IN ('P', 'G')
5283: UNION ALL
5284: SELECT project_id,budget_version_id
5285: FROM pa_resource_assignments ra,
5286: PJI_FM_AGGR_DLY_RATES_T rates
5287: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5288: , 'S'
5289: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))
5290: , 'E'

Line 5315: DELETE FROM PJI_FM_AGGR_DLY_RATES_T

5311: BEGIN
5312:
5313: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Begin. ' );
5314:
5315: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5316: WHERE worker_id = g_worker_id;
5317:
5318: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5319:

Line 5891: , PJI_FM_AGGR_DLY_RATES_T rates

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

Line 6003: , PJI_FM_AGGR_DLY_RATES_T rates

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

Line 6308: , PJI_FM_AGGR_DLY_RATES_T rates

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