APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_ORG_EXTR_INFO

Line 4713: , PJI_ORG_EXTR_INFO orginfo

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

Line 5386: , PJI_ORG_EXTR_INFO orginfo

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

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

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

Line 6137: ,PJI_ORG_EXTR_INFO inf

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

Line 9612: , PJI_ORG_EXTR_INFO oei

9608: PJI_FM_EXTR_PLNVER4 ver
9609: , pa_resource_asSIGNments ra
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

Line 10801: , PJI_ORG_EXTR_INFO oei

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

Line 11835: , PJI_ORG_EXTR_INFO orginfo

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

Line 12430: , PJI_ORG_EXTR_INFO orginfo

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