APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_ORG_EXTR_INFO

Line 3561: , PJI_ORG_EXTR_INFO orginfo

3557: , collapse_bl.plan_type_code
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

Line 4215: , PJI_ORG_EXTR_INFO orginfo

4211: , collapse_bl.plan_type_code
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

Line 4891: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info

4887:
4888: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
4889:
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 ,

Line 4946: ,PJI_ORG_EXTR_INFO inf

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
4948: AND bl.budget_version_id = ver.plan_version_id
4949: AND ver.time_phased_type_code IN ('P', 'G')
4950: AND bl.period_name = prd.name

Line 8329: , PJI_ORG_EXTR_INFO oei

8325: PJI_FM_EXTR_PLNVER4 ver
8326: , pa_resource_asSIGNments ra
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

Line 9493: , PJI_ORG_EXTR_INFO oei

9489: PJI_FM_EXTR_PLNVER4 ver
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

Line 10503: , PJI_ORG_EXTR_INFO orginfo

10499: , collapse_bl.row_id
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

Line 11076: , PJI_ORG_EXTR_INFO orginfo

11072: , collapse_bl.plan_type_code
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