APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PAY_OBJECT_GROUPS_S

Line 130: l_start_date pay_object_groups.start_date%type;

126: )
127: return number
128: is
129: l_object_group_id pay_object_groups.object_group_id%type;
130: l_start_date pay_object_groups.start_date%type;
131: l_end_date pay_object_groups.end_date%type;
132: l_cnt number;
133: begin
134: --

Line 186: select pay_object_groups_s.nextval

182: end if;
183: --
184: if (p_update_row = 'Y') then
185: --
186: select pay_object_groups_s.nextval
187: into l_object_group_id
188: from dual;
189: --
190: if g_debug then

Line 248: l_start_date pay_object_groups.start_date%type;

244: return number
245: is
246: l_definition_id pay_group_definitions.group_definition_id%type;
247: l_object_group_id pay_object_groups.object_group_id%type;
248: l_start_date pay_object_groups.start_date%type;
249: l_end_date pay_object_groups.end_date%type;
250: l_update boolean;
251: l_upd_start_date date;
252: l_upd_end_date date;

Line 318: select pay_object_groups_s.nextval

314: when no_data_found then
315: --
316: if (p_update_row = 'Y') then
317: --
318: select pay_object_groups_s.nextval
319: into l_object_group_id
320: from dual;
321: --
322: insert into pay_object_groups