APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 19318: -- bug 6414995 : Cursor query changed by adding join with pa_fin_plan_types_b

19314: where pevs.element_version_id = c_struc_ver_id
19315: and pevs.project_id = c_project_id;
19316:
19317: --bug 4472071
19318: -- bug 6414995 : Cursor query changed by adding join with pa_fin_plan_types_b
19319: CURSOR cur_chk_pji_failed
19320: IS
19321: SELECT 'Y'
19322: FROM pji_pjp_wbs_header h,

Line 19323: pa_fin_plan_types_b fin

19319: CURSOR cur_chk_pji_failed
19320: IS
19321: SELECT 'Y'
19322: FROM pji_pjp_wbs_header h,
19323: pa_fin_plan_types_b fin
19324: WHERE h.wbs_version_id= p_pub_struc_ver_id
19325: AND fin.use_for_workplan_flag='Y'
19326: AND h.plan_type_id=fin.fin_plan_type_id;
19327: /*