APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_TIME_CAL_PERIOD_V

Line 3562: , pji_time_cal_period_v pji_time

3558: , collapse_bl.WP_FLAG
3559: ) plr
3560: ---- End of first inline view plr ..........
3561: , PJI_ORG_EXTR_INFO orginfo
3562: , pji_time_cal_period_v pji_time
3563: WHERE 1=1
3564: -- AND orginfo.projfunc_currency_mau is not NULL
3565: AND plr.project_org_id = orginfo.org_id
3566: AND DECODE(plr.time_phased_type_code

Line 4216: , pji_time_cal_period_v pji_time

4212: , collapse_bl.time_phased_type_code
4213: ) plr
4214: ---- End of first inline view plr ..........
4215: , PJI_ORG_EXTR_INFO orginfo
4216: , pji_time_cal_period_v pji_time
4217: WHERE 1=1
4218: -- AND orginfo.projfunc_currency_mau is not NULL
4219: AND plr.project_org_id = orginfo.org_id
4220: AND DECODE(plr.time_phased_type_code

Line 4943: , pji_time_cal_period_v prd

4939: , prd.end_date
4940: , TO_DATE(NULL)
4941: ) end_date
4942: FROM pa_budget_lines bl
4943: , pji_time_cal_period_v prd
4944: , PJI_FM_EXTR_PLNVER4 ver
4945: , pa_projects_all ppa
4946: ,PJI_ORG_EXTR_INFO inf
4947: WHERE 1=1

Line 5002: pji_time_cal_period_v prd,

4998: SET rate_dangling_flag = 'Y'
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)

Line 7342: , pji_time_cal_period_v cal

7338: , whdr.PLAN_TYPE_CODE
7339: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
7340: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
7341: FROM PJI_FP_AGGR_PJP1 pjp1
7342: , pji_time_cal_period_v cal
7343: , pji_pjp_wbs_header whdr
7344: WHERE
7345: pjp1.worker_id = g_worker_id
7346: AND pjp1.project_id = whdr.project_id

Line 8331: , pji_time_cal_period_v prd

8327: , PA_BUDGET_LINES bl
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

Line 9494: , pji_time_cal_period_v prd

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

Line 10504: , pji_time_cal_period_v pji_time

10500: ,collapse_bl.plan_type_code
10501: ) plr
10502: ---- End of first inline view plr ..........
10503: , PJI_ORG_EXTR_INFO orginfo
10504: , pji_time_cal_period_v pji_time
10505: WHERE 1=1
10506: -- AND orginfo.projfunc_currency_mau is not TO_NUMBER(NULL
10507: AND plr.project_org_id = orginfo.org_id
10508: AND DECODE(plr.time_phased_type_code

Line 11077: , pji_time_cal_period_v pji_time

11073: , collapse_bl.time_phased_type_code
11074: ) plr
11075: ---- End of first inline view plr ..........
11076: , PJI_ORG_EXTR_INFO orginfo
11077: , pji_time_cal_period_v pji_time
11078: WHERE 1=1
11079: -- AND orginfo.projfunc_currency_mau is not NULL
11080: AND plr.project_org_id = orginfo.org_id
11081: AND DECODE(plr.time_phased_type_code

Line 11151: , pji_time_cal_period_v cal

11147: , pjp1.PLAN_TYPE_CODE
11148: , cal.start_date min_txn_date
11149: , cal.end_date max_txn_date
11150: FROM PJI_FP_AGGR_PJP1 pjp1
11151: , pji_time_cal_period_v cal
11152: WHERE
11153: pjp1.worker_id = p_worker_id
11154: AND pjp1.time_id = cal.cal_period_id
11155: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.