APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PROJ_FP_OPTIONS

Line 695: pa_proj_fp_options fpo

691: select
692: bv.budget_version_id , fpo.rbs_version_id
693: from
694: pa_budget_versions bv ,
695: pa_proj_fp_options fpo
696: where
697: bv.project_id = fpo.project_id
698: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
699: AND fpo.project_id = c_project_id

Line 712: pa_proj_fp_options fpo

708: select
709: bv.budget_version_id , nvl(fpo.rbs_version_id ,-1) rbs_version_id
710: from
711: pa_budget_versions bv ,
712: pa_proj_fp_options fpo
713: where
714: bv.project_id = fpo.project_id
715: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
716: AND fpo.project_id = c_project_id

Line 1137: ,pa_proj_fp_options ppfo

1133: G2_BILL_BRDN_COST , G2_REVENUE_WRITEOFF , G2_SUP_INV_COMMITTED_COST ,
1134: G2_PO_COMMITTED_COST , G2_PR_COMMITTED_COST , G2_OTH_COMMITTED_COST ,
1135: ASSIGNMENT_ID , NAMED_ROLE --Bug#4590810
1136: FROM pji_fm_aggr_fin7 tmp
1137: ,pa_proj_fp_options ppfo
1138: WHERE
1139: tmp.PROJECT_ID= p_project_id AND
1140: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
1141: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND

Line 1186: ,pa_proj_fp_options ppfo

1182: G2_REVENUE , G2_RAW_COST , G2_BRDN_COST ,
1183: G2_BILL_RAW_COST , G2_BILL_BRDN_COST , ASSIGNMENT_ID ,
1184: p_worker_id , 'A' , NAMED_ROLE --Bug#4590810
1185: FROM pji_fp_txn_accum tmp
1186: ,pa_proj_fp_options ppfo
1187: WHERE
1188: tmp.PROJECT_ID= p_project_id AND
1189: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
1190: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND