[Home] [Help]
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
1142: ppfo.FIN_PLAN_TYPE_ID = (
1143: SELECT fin_plan_type_id
1144: FROM pa_fin_plan_types_b
1145: WHERE use_for_workplan_flag = 'Y'
1146: ) AND
1147: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
1148:
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
1191: ppfo.FIN_PLAN_TYPE_ID = (
1192: SELECT fin_plan_type_id
1193: FROM pa_fin_plan_types_b
1194: WHERE use_for_workplan_flag = 'Y'
1195: ) AND
1196: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
1197: