APPS.PA_ALTERNATE_TASK_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 1125: (select * from pa_proj_fp_options

1121:
1122: cursor validateLowestTask IS
1123: select 'Y' from dual where
1124: EXISTS
1125: (select * from pa_proj_fp_options
1126: where (REVENUE_FIN_PLAN_LEVEL_CODE = 'P' OR
1127: COST_FIN_PLAN_LEVEL_CODE = 'P' OR
1128: ALL_FIN_PLAN_LEVEL_CODE = 'P') and FIN_PLAN_VERSION_ID = p_budget_version_id
1129: );

Line 1134: (select * from pa_proj_fp_options

1130:
1131: cursor validateStaffPlan IS
1132: select 'Y' from dual where
1133: EXISTS
1134: (select * from pa_proj_fp_options
1135: where (GEN_ALL_ETC_SRC_CODE = 'RESOURCE_SCHEDULE' OR
1136: GEN_ALL_SRC_CODE = 'RESOURCE_SCHEDULE' OR
1137: GEN_REV_SRC_CODE = 'RESOURCE_SCHEDULE' OR
1138: GEN_COST_SRC_CODE = 'RESOURCE_SCHEDULE'OR

Line 1146: (select * from pa_proj_fp_options

1142:
1143: cursor validateBillEvent IS
1144: select 'Y' from dual where
1145: EXISTS
1146: (select * from pa_proj_fp_options
1147: where (GEN_REV_INCL_BILL_EVENT_FLAG = 'Y' OR
1148: GEN_ALL_INCL_BILL_EVENT_FLAG = 'Y') and FIN_PLAN_VERSION_ID = p_budget_version_id
1149: );
1150:

Line 1154: (select * from pa_proj_fp_options

1150:
1151: cursor validateRevDerv IS
1152: select 'Y' from dual where
1153: EXISTS
1154: (select * from pa_proj_fp_options
1155: where (REVENUE_DERIVATION_METHOD = 'EVENT' ) and FIN_PLAN_VERSION_ID = p_budget_version_id
1156: );
1157:
1158: l_Cbs_Enabled VARCHAR2(1) := 'N';