APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FM_AGGR_DLY_RATES

Line 4885: DELETE FROM PJI_FM_AGGR_DLY_RATES

4881: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
4882: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
4883:
4884:
4885: DELETE FROM PJI_FM_AGGR_DLY_RATES
4886: WHERE worker_id = g_worker_id;
4887:
4888: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
4889:

Line 4894: INSERT INTO PJI_FM_AGGR_DLY_RATES (

4890: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
4891: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
4892: -- for bug 4149422
4893: -- SQL for getting rates for time phased budgets.
4894: INSERT INTO PJI_FM_AGGR_DLY_RATES (
4895: WORKER_ID ,
4896: PF_CURRENCY_CODE ,
4897: TIME_ID ,
4898: RATE ,

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

4992: ) temp;
4993:
4994: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
4995:
4996: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
4997: PJI_FM_EXTR_PLNVER4 ver
4998: SET rate_dangling_flag = 'Y'
4999: WHERE (project_id,plan_version_id) IN
5000: ( SELECT project_id,budget_version_id

Line 5003: PJI_FM_AGGR_DLY_RATES rates

4999: WHERE (project_id,plan_version_id) IN
5000: ( SELECT project_id,budget_version_id
5001: FROM PA_BUDGET_LINES bl,
5002: pji_time_cal_period_v prd,
5003: PJI_FM_AGGR_DLY_RATES rates
5004: WHERE rates.time_id=prd.cal_period_id
5005: AND bl.period_name = prd.name
5006: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)
5007: AND ver.time_phased_type_code IN ('P', 'G')

Line 5012: PJI_FM_AGGR_DLY_RATES rates

5008: AND rates.worker_id=g_worker_id /* Added for bug 4083581 */
5009: UNION ALL
5010: SELECT project_id,budget_version_id
5011: FROM pa_resource_assignments ra,
5012: PJI_FM_AGGR_DLY_RATES rates
5013: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5014: , 'S'
5015: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))
5016: , 'E'

Line 5042: DELETE FROM PJI_FM_AGGR_DLY_RATES

5038: BEGIN
5039:
5040: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Begin. ' );
5041:
5042: DELETE FROM PJI_FM_AGGR_DLY_RATES
5043: WHERE worker_id = g_worker_id;
5044:
5045: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5046:

Line 8332: , PJI_FM_AGGR_DLY_RATES rates

8328: , pa_projects_all ppa
8329: , PJI_ORG_EXTR_INFO oei
8330: , pji_pjp_rbs_header rhdr
8331: , pji_time_cal_period_v prd
8332: , PJI_FM_AGGR_DLY_RATES rates
8333: , pji_fp_txn_accum_header hdr
8334: , pa_rbs_txn_accum_map map
8335: , PA_PROJ_ELEM_VER_STRUCTURE pevs
8336: WHERE 1=1

Line 8639: , PJI_FM_AGGR_DLY_RATES rates

8635: , pa_resource_asSIGNments ra
8636: , PA_BUDGET_LINES bl
8637: , pa_projects_all ppa
8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates
8640: , pji_fp_txn_accum_header hdr
8641: , pa_rbs_txn_accum_map map
8642: , PA_PROJ_ELEM_VER_STRUCTURE pevs
8643: WHERE 1=1

Line 9495: , PJI_FM_AGGR_DLY_RATES rates

9491: , PA_BUDGET_LINES bl
9492: , pa_projects_all ppa
9493: , PJI_ORG_EXTR_INFO oei
9494: , pji_time_cal_period_v prd
9495: , PJI_FM_AGGR_DLY_RATES rates
9496: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9497: WHERE 1=1
9498: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
9499: AND ra.project_id = ver.PROJECT_ID

Line 9784: , PJI_FM_AGGR_DLY_RATES rates

9780: PJI_FM_EXTR_PLNVER4 ver
9781: , pa_resource_asSIGNments ra
9782: , PA_BUDGET_LINES bl
9783: , pa_projects_all ppa
9784: , PJI_FM_AGGR_DLY_RATES rates
9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9786: WHERE 1=1
9787: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
9788: AND ra.project_id = ver.PROJECT_ID