APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PJI_PJP_WBS_HEADER

Line 18529: FROM pji_pjp_wbs_header h,

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,
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;

Line 18537: FROM pji_pjp_wbs_header

18533: AND h.plan_type_id=fin.fin_plan_type_id;
18534: /*
18535: SELECT 'Y'
18536:
18537: FROM pji_pjp_wbs_header
18538: WHERE wbs_version_id= p_pub_struc_ver_id;
18539: */
18540:
18541: l_dummy_pji_char VARCHAR2(1);