APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FM_AGGR_DLY_RATES

Line 6076: DELETE FROM PJI_FM_AGGR_DLY_RATES

6072: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
6073: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
6074:
6075:
6076: DELETE FROM PJI_FM_AGGR_DLY_RATES
6077: WHERE worker_id = g_worker_id;
6078:
6079: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
6080:

Line 6085: INSERT INTO PJI_FM_AGGR_DLY_RATES (

6081: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
6082: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
6083: -- for bug 4149422
6084: -- SQL for getting rates for time phased budgets.
6085: INSERT INTO PJI_FM_AGGR_DLY_RATES (
6086: WORKER_ID ,
6087: PF_CURRENCY_CODE ,
6088: TIME_ID ,
6089: RATE ,

Line 6187: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */

6183: ) temp;
6184:
6185: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
6186:
6187: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
6188: PJI_FM_EXTR_PLNVER4 ver
6189: SET rate_dangling_flag = 'Y'
6190: WHERE (project_id,plan_version_id) IN
6191: ( SELECT project_id,budget_version_id

Line 6194: PJI_FM_AGGR_DLY_RATES rates

6190: WHERE (project_id,plan_version_id) IN
6191: ( SELECT project_id,budget_version_id
6192: FROM PA_BUDGET_LINES bl,
6193: pji_time_cal_period_v prd,
6194: PJI_FM_AGGR_DLY_RATES rates
6195: WHERE rates.time_id=prd.cal_period_id
6196: AND bl.period_name = prd.name
6197: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)
6198: AND ver.time_phased_type_code IN ('P', 'G')

Line 6203: PJI_FM_AGGR_DLY_RATES rates

6199: AND rates.worker_id=g_worker_id /* Added for bug 4083581 */
6200: UNION ALL
6201: SELECT project_id,budget_version_id
6202: FROM pa_resource_assignments ra,
6203: PJI_FM_AGGR_DLY_RATES rates
6204: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
6205: , 'S'
6206: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))
6207: , 'E'

Line 6237: DELETE FROM PJI_FM_AGGR_DLY_RATES

6233: BEGIN
6234:
6235: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Begin. ' );
6236:
6237: DELETE FROM PJI_FM_AGGR_DLY_RATES
6238: WHERE worker_id = g_worker_id;
6239:
6240: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
6241:

Line 9615: , PJI_FM_AGGR_DLY_RATES rates

9611: , pa_projects_all ppa
9612: , PJI_ORG_EXTR_INFO oei
9613: , pji_pjp_rbs_header rhdr
9614: , pji_time_cal_period_v prd
9615: , PJI_FM_AGGR_DLY_RATES rates
9616: , pji_fp_txn_accum_header hdr
9617: , pa_rbs_txn_accum_map map
9618: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9619: WHERE 1=1

Line 9925: , PJI_FM_AGGR_DLY_RATES rates

9921: , pa_resource_asSIGNments ra
9922: , PA_BUDGET_LINES bl
9923: , pa_projects_all ppa
9924: , pji_pjp_rbs_header rhdr
9925: , PJI_FM_AGGR_DLY_RATES rates
9926: , pji_fp_txn_accum_header hdr
9927: , pa_rbs_txn_accum_map map
9928: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9929: WHERE 1=1

Line 10803: , PJI_FM_AGGR_DLY_RATES rates

10799: , PA_BUDGET_LINES bl
10800: , pa_projects_all ppa
10801: , PJI_ORG_EXTR_INFO oei
10802: , pji_time_cal_period_v prd
10803: , PJI_FM_AGGR_DLY_RATES rates
10804: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10805: WHERE 1=1
10806: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
10807: AND ra.project_id = ver.PROJECT_ID

Line 11095: , PJI_FM_AGGR_DLY_RATES rates

11091: PJI_FM_EXTR_PLNVER4 ver
11092: , pa_resource_asSIGNments ra
11093: , PA_BUDGET_LINES bl
11094: , pa_projects_all ppa
11095: , PJI_FM_AGGR_DLY_RATES rates
11096: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11097: WHERE 1=1
11098: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
11099: AND ra.project_id = ver.PROJECT_ID