APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_FIN_PLAN_TYPES_B

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

18521: where pevs.element_version_id = c_struc_ver_id
18522: and pevs.project_id = c_project_id;
18523:
18524: --bug 4472071
18525: -- bug 6414995 : Cursor query changed by adding join with pa_fin_plan_types_b
18526: CURSOR cur_chk_pji_failed
18527: IS
18528: SELECT 'Y'
18529: FROM pji_pjp_wbs_header h,

Line 18530: pa_fin_plan_types_b fin

18526: CURSOR cur_chk_pji_failed
18527: IS
18528: SELECT 'Y'
18529: FROM pji_pjp_wbs_header h,
18530: pa_fin_plan_types_b fin
18531: WHERE h.wbs_version_id= p_pub_struc_ver_id
18532: AND fin.use_for_workplan_flag='Y'
18533: AND h.plan_type_id=fin.fin_plan_type_id;
18534: /*