APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PJI_PJP_WBS_HEADER

Line 19322: FROM pji_pjp_wbs_header h,

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

Line 19330: FROM pji_pjp_wbs_header

19326: AND h.plan_type_id=fin.fin_plan_type_id;
19327: /*
19328: SELECT 'Y'
19329:
19330: FROM pji_pjp_wbs_header
19331: WHERE wbs_version_id= p_pub_struc_ver_id;
19332: */
19333:
19334: l_dummy_pji_char VARCHAR2(1);