APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_TIME_CAL_PERIOD_V

Line 4714: , pji_time_cal_period_v pji_time

4710: , collapse_bl.WP_FLAG
4711: ) plr
4712: ---- End of first inline view plr ..........
4713: , PJI_ORG_EXTR_INFO orginfo
4714: , pji_time_cal_period_v pji_time
4715: WHERE 1=1
4716: -- AND orginfo.projfunc_currency_mau is not NULL
4717: AND plr.project_org_id = orginfo.org_id
4718: AND DECODE(plr.time_phased_type_code

Line 5387: , pji_time_cal_period_v pji_time

5383: , collapse_bl.time_phased_type_code
5384: ) plr
5385: ---- End of first inline view plr ..........
5386: , PJI_ORG_EXTR_INFO orginfo
5387: , pji_time_cal_period_v pji_time
5388: WHERE 1=1
5389: -- AND orginfo.projfunc_currency_mau is not NULL
5390: AND plr.project_org_id = orginfo.org_id
5391: AND DECODE(plr.time_phased_type_code

Line 6134: , pji_time_cal_period_v prd

6130: , prd.end_date
6131: , TO_DATE(NULL)
6132: ) end_date
6133: FROM pa_budget_lines bl
6134: , pji_time_cal_period_v prd
6135: , PJI_FM_EXTR_PLNVER4 ver
6136: , pa_projects_all ppa
6137: ,PJI_ORG_EXTR_INFO inf
6138: WHERE 1=1

Line 6193: pji_time_cal_period_v prd,

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

Line 8569: , pji_time_cal_period_v cal

8565: , whdr.PLAN_TYPE_CODE
8566: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
8567: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
8568: FROM PJI_FP_AGGR_PJP1 pjp1
8569: , pji_time_cal_period_v cal
8570: , pji_pjp_wbs_header whdr
8571: WHERE
8572: pjp1.worker_id = g_worker_id
8573: AND pjp1.project_id = whdr.project_id

Line 9614: , pji_time_cal_period_v prd

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

Line 10802: , pji_time_cal_period_v prd

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

Line 11836: , pji_time_cal_period_v pji_time

11832: ,collapse_bl.plan_type_code
11833: ) plr
11834: ---- End of first inline view plr ..........
11835: , PJI_ORG_EXTR_INFO orginfo
11836: , pji_time_cal_period_v pji_time
11837: WHERE 1=1
11838: -- AND orginfo.projfunc_currency_mau is not TO_NUMBER(NULL
11839: AND plr.project_org_id = orginfo.org_id
11840: AND DECODE(plr.time_phased_type_code

Line 12431: , pji_time_cal_period_v pji_time

12427: , collapse_bl.time_phased_type_code
12428: ) plr
12429: ---- End of first inline view plr ..........
12430: , PJI_ORG_EXTR_INFO orginfo
12431: , pji_time_cal_period_v pji_time
12432: WHERE 1=1
12433: -- AND orginfo.projfunc_currency_mau is not NULL
12434: AND plr.project_org_id = orginfo.org_id
12435: AND DECODE(plr.time_phased_type_code

Line 12508: , pji_time_cal_period_v cal

12504: , pjp1.PLAN_TYPE_CODE
12505: , cal.start_date min_txn_date
12506: , cal.end_date max_txn_date
12507: FROM PJI_FP_AGGR_PJP1 pjp1
12508: , pji_time_cal_period_v cal
12509: WHERE
12510: pjp1.worker_id = p_worker_id
12511: AND pjp1.time_id = cal.cal_period_id
12512: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.