APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_ANALYSIS_CYCLES

Line 65: ZPB_ANALYSIS_CYCLES B

61: --
62: select B.BUSINESS_AREA_ID, A.TEMPLATE_ID
63: into l_business_area_id , l_template_id
64: from ZPB_DC_OBJECTS A,
65: ZPB_ANALYSIS_CYCLES B
66: where A.OBJECT_ID = p_object_id
67: and A.AC_INSTANCE_ID = B.ANALYSIS_CYCLE_ID;
68:
69: select OBJECT_ID into l_master_object_id

Line 755: SELECT business_area_id FROM zpb_analysis_cycles

751: WHERE ANALYSIS_CYCLE_ID = p_ac_id
752: AND PARAM_ID = l_currency_param_id;
753:
754: CURSOR c_bus_area IS
755: SELECT business_area_id FROM zpb_analysis_cycles
756: WHERE ANALYSIS_CYCLE_ID = p_ac_id;
757:
758: --PRAGMA autonomous_transaction;
759:

Line 919: FROM zpb_analysis_cycles a1, zpb_analysis_cycles a2

915:
916: /* IF (l_ac_count <> 0) THEN*/
917: SELECT max(a2.analysis_cycle_id)
918: INTO l_last_ac_id
919: FROM zpb_analysis_cycles a1, zpb_analysis_cycles a2
920: WHERE a1.analysis_cycle_id = p_ac_id
921: AND a2.status_code = 'ENABLE_TASK_OLD'
922: AND a1.current_instance_id = a2.current_instance_id
923: AND a2.analysis_cycle_id <> p_ac_id;