DBA Data[Home] [Help]

APPS.OKC_CG_UPD_ASMBLR_PVT dependencies on OKX_COUNTER_GROUPS_V

Line 24: l_counter_group_id okx_counter_groups_v.counter_group_id%TYPE;

20: l_msg_tbl okc_aq_pvt.msg_tab_typ;
21: l_msg_count number;
22: l_msg_data varchar2(1000);
23: l_return_status varchar2(1);
24: l_counter_group_id okx_counter_groups_v.counter_group_id%TYPE;
25: l_contract_id okx_counter_groups_v.source_object_id%TYPE;
26:
27:
28: CURSOR ctr_grp_cur IS

Line 25: l_contract_id okx_counter_groups_v.source_object_id%TYPE;

21: l_msg_count number;
22: l_msg_data varchar2(1000);
23: l_return_status varchar2(1);
24: l_counter_group_id okx_counter_groups_v.counter_group_id%TYPE;
25: l_contract_id okx_counter_groups_v.source_object_id%TYPE;
26:
27:
28: CURSOR ctr_grp_cur IS
29: /*R12 changes

Line 34: okx_counter_groups_v cg

30: SELECT cg.counter_group_id counter_group_id,
31: cg.source_object_code source_object_code,
32: cg.source_object_id source_object_id
33: FROM okx_counter_grp_log_v log,
34: okx_counter_groups_v cg
35: WHERE log.counter_group_id = cg.counter_group_id
36: AND counter_grp_log_id = p_counter_grp_log_id;*/
37: SELECT ca.source_object_code source_object_code,
38: ca.source_object_id source_object_id