APPS.PJI_FM_PLAN_MAINT dependencies on PA_FIN_PLAN_TYPES_B

Line 2062: FROM pa_fin_plan_types_b

2058: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
2059: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND
2060: ppfo.FIN_PLAN_TYPE_ID = (
2061: SELECT fin_plan_type_id
2062: FROM pa_fin_plan_types_b
2063: WHERE use_for_workplan_flag = 'Y'
2064: ) AND
2065: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2066:

Line 2116: FROM pa_fin_plan_types_b

2112: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
2113: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND
2114: ppfo.FIN_PLAN_TYPE_ID = (
2115: SELECT fin_plan_type_id
2116: FROM pa_fin_plan_types_b
2117: WHERE use_for_workplan_flag = 'Y'
2118: ) AND
2119: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2120: