DBA Data[Home] [Help]

APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PAY_OBJECT_GROUPS_S

Line 118: l_start_date pay_object_groups.start_date%type;

114: )
115: return number
116: is
117: l_object_group_id pay_object_groups.object_group_id%type;
118: l_start_date pay_object_groups.start_date%type;
119: l_end_date pay_object_groups.end_date%type;
120: l_cnt number;
121: begin
122: --

Line 159: select pay_object_groups_s.nextval

155: end if;
156: --
157: if (p_update_row = 'Y') then
158: --
159: select pay_object_groups_s.nextval
160: into l_object_group_id
161: from dual;
162: --
163: insert into pay_object_groups

Line 212: l_start_date pay_object_groups.start_date%type;

208: return number
209: is
210: l_definition_id pay_group_definitions.group_definition_id%type;
211: l_object_group_id pay_object_groups.object_group_id%type;
212: l_start_date pay_object_groups.start_date%type;
213: l_end_date pay_object_groups.end_date%type;
214: l_update boolean;
215: l_upd_start_date date;
216: l_upd_end_date date;

Line 266: select pay_object_groups_s.nextval

262: when no_data_found then
263: --
264: if (p_update_row = 'Y') then
265: --
266: select pay_object_groups_s.nextval
267: into l_object_group_id
268: from dual;
269: --
270: insert into pay_object_groups