APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on ZPB_CYCLE_RELATIONSHIPS

Line 76: FROM zpb_analysis_cycles a , zpb_cycle_relationships b

72:
73:
74:
75: CURSOR c_publ_id IS SELECT analysis_cycle_id, BUSINESS_AREA_ID, owner_id
76: FROM zpb_analysis_cycles a , zpb_cycle_relationships b
77: WHERE a.name = p_bp_name
78: AND a.analysis_cycle_id = b.published_ac_id
79: and a.BUSINESS_AREA_ID in (select BUSINESS_AREA_ID
80: from zPB_BUSINESS_AREAS_VL where name = p_ba_name);