DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT dependencies on AMS_ACT_LIST_GROUPS

Line 396: from ams_act_list_groups alg,

392: l_act_list_rec act_list_rec_type := p_act_list_rec;
393:
394: cursor c_check_group (cur_group_code in varchar2) is
395: select alg.act_list_group_id
396: from ams_act_list_groups alg,
397: ams_act_lists acl
398: where alg.arc_act_list_used_by = 'TARGET'
399: and alg.group_code = cur_group_code
400: and alg.act_list_used_by_id = acl.list_header_id

Line 826: from ams_act_list_groups alg,

822: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Act_List';
823: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
824: cursor c_check_group (cur_group_code in varchar2) is
825: select alg.act_list_group_id
826: from ams_act_list_groups alg,
827: ams_act_lists acl
828: where alg.arc_act_list_used_by = 'TARGET'
829: and alg.group_code = cur_group_code
830: and p_act_list_rec.list_header_id = alg.act_list_used_by_id