APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_ORG_EXTR_INFO

Line 1831: , PJI_ORG_EXTR_INFO orginfo

1827: , collapse_bl.row_id
1828: , collapse_bl.plan_type_code /* 4471527 */
1829: ) plr
1830: ---- End of first inline view plr ..........
1831: , PJI_ORG_EXTR_INFO orginfo
1832: , PJI_FM_EXTR_PLNVER3_T vers
1833: , pji_time_cal_period_v pji_time
1834: WHERE 1=1
1835: -- AND orginfo.projfunc_currency_mau is not NULL

Line 2546: , PJI_ORG_EXTR_INFO oei

2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2544: , PJI_FM_AGGR_DLY_RATES_T rates
2545: , pji_time_cal_period_v prd
2546: , PJI_ORG_EXTR_INFO oei
2547: , pji_fp_txn_accum_header hdr
2548: , pa_rbs_txn_accum_map map
2549: , pji_pjp_rbs_header rhdr
2550: WHERE 1=1

Line 2849: -- , PJI_ORG_EXTR_INFO oei

2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2847: , PJI_FM_AGGR_DLY_RATES_T rates
2848: -- , pji_time_cal_period prd
2849: -- , PJI_ORG_EXTR_INFO oei
2850: , pji_fp_txn_accum_header hdr
2851: , pa_rbs_txn_accum_map map
2852: , pji_pjp_rbs_header rhdr
2853: WHERE 1=1

Line 3590: , PJI_ORG_EXTR_INFO oei

3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3588: , PJI_FM_AGGR_DLY_RATES_T rates
3589: , pji_time_cal_period_v prd
3590: , PJI_ORG_EXTR_INFO oei
3591: WHERE 1=1
3592: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3593: AND ra.project_id = ver.PROJECT_ID
3594: AND ra.budget_version_id = ver.plan_version_id

Line 4899: , PJI_ORG_EXTR_INFO orginfo

4895: , collapse_bl.row_id
4896: , collapse_bl.plan_type_code /* 4471527 */
4897: ) plr
4898: ---- End of first inline view plr ..........
4899: , PJI_ORG_EXTR_INFO orginfo
4900: , PJI_FM_EXTR_PLNVER3_T vers
4901: , pji_time_cal_period_v pji_time
4902: WHERE 1=1
4903: AND plr.project_org_id = orginfo.org_id

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

5057:
5058:
5059: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5060: WHERE worker_id = g_worker_id;
5061: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5062: -- for bug 4149422
5063: -- SQL for getting rates for time phased budgets.
5064: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5065:

Line 5119: ,PJI_ORG_EXTR_INFO inf

5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa
5119: ,PJI_ORG_EXTR_INFO inf
5120: WHERE bl.budget_version_id = ver.plan_version_id
5121: AND bl.budget_version_id = bv.budget_version_id -- added for bug 5842896
5122: AND bv.project_id = ppa.project_id -- added for bug 5842896
5123: AND ver.time_phased_type_code IN ('P', 'G')

Line 7180: , PJI_ORG_EXTR_INFO orginfo

7176: , collapse_bl.row_id
7177: , collapse_bl.plan_type_code
7178: ) plr
7179: ---- End of first inline view plr ..........
7180: , PJI_ORG_EXTR_INFO orginfo
7181: , PJI_FM_EXTR_PLNVER3_T vers
7182: , pji_time_cal_period_v pji_time
7183: WHERE 1=1
7184: AND plr.project_org_id = orginfo.org_id

Line 9155: , pji_org_extr_info orginfo

9151: WHERE plan_version_id IN
9152: (SELECT fact.plan_version_id
9153: FROM pji_fp_aggr_pjp1_t fact
9154: , pji_time_cal_period_v time
9155: , pji_org_extr_info orginfo
9156: WHERE fact.period_type_id = 32
9157: AND fact.worker_id = g_worker_id
9158: AND fact.calendar_type = 'P'
9159: AND fact.time_id = time.cal_period_id

Line 9169: , pji_org_extr_info orginfo

9165: WHERE plan_version_id IN
9166: (SELECT fact.plan_version_id
9167: FROM pji_fp_aggr_pjp1_t fact
9168: , pji_time_cal_period_v time
9169: , pji_org_extr_info orginfo
9170: WHERE fact.period_type_id = 32
9171: AND fact.worker_id = g_worker_id
9172: AND fact.calendar_type = 'G'
9173: AND fact.time_id = time.cal_period_id