APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FM_AGGR_DLY_RATES

Line 2731: DELETE FROM PJI_FM_AGGR_DLY_RATES

2727: l_gl2_cur_code := g_global2_currency_code;
2728: l_gl1_mau := g_global1_currency_mau;
2729: l_gl2_mau := g_global2_currency_mau;
2730:
2731: DELETE FROM PJI_FM_AGGR_DLY_RATES
2732: WHERE worker_id = g_worker_id;
2733:
2734: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
2735:

Line 2736: INSERT INTO PJI_FM_AGGR_DLY_RATES (

2732: WHERE worker_id = g_worker_id;
2733:
2734: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
2735:
2736: INSERT INTO PJI_FM_AGGR_DLY_RATES (
2737: WORKER_ID ,
2738: PF_CURRENCY_CODE ,
2739: TIME_ID ,
2740: RATE ,

Line 2849: PJI_FM_AGGR_DLY_RATES rates

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

Line 2860: PJI_FM_AGGR_DLY_RATES rates

2856: AND ver.plan_version_id = bl.budget_version_id
2857: UNION ALL
2858: SELECT NULL
2859: FROM pa_resource_assignments ra,
2860: PJI_FM_AGGR_DLY_RATES rates
2861: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
2862: , 'S'
2863: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))
2864: , 'E'

Line 3784: , PJI_FM_AGGR_DLY_RATES rates

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
3788: AND ra.project_id = ver.PROJECT_ID

Line 4073: , PJI_FM_AGGR_DLY_RATES rates

4069: PJI_FM_EXTR_PLNVER4 ver
4070: , pa_resource_asSIGNments ra
4071: , PA_BUDGET_LINES bl
4072: , pa_projects_all ppa
4073: , PJI_FM_AGGR_DLY_RATES rates
4074: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4075: WHERE 1=1
4076: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
4077: AND ra.project_id = ver.PROJECT_ID