APPS.PJI_FM_PLAN_MAINT dependencies on PA_FIN_PLAN_TYPES_B

Line 2000: FROM pa_fin_plan_types_b

1996: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
1997: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND
1998: ppfo.FIN_PLAN_TYPE_ID = (
1999: SELECT fin_plan_type_id
2000: FROM pa_fin_plan_types_b
2001: WHERE use_for_workplan_flag = 'Y'
2002: ) AND
2003: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2004:

Line 2052: FROM pa_fin_plan_types_b

2048: ppfo.PROJECT_ID=tmp.PROJECT_ID AND
2049: SUBSTR(tmp.RECVR_PERIOD_TYPE,1,1) = DECODE (ppfo.COST_TIME_PHASED_CODE,'N','G',ppfo.COST_TIME_PHASED_CODE) AND
2050: ppfo.FIN_PLAN_TYPE_ID = (
2051: SELECT fin_plan_type_id
2052: FROM pa_fin_plan_types_b
2053: WHERE use_for_workplan_flag = 'Y'
2054: ) AND
2055: ppfo.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE';
2056: