DBA Data[Home] [Help]

APPS.HR_RUNGEN dependencies on DUAL

Line 231: FROM sys.dual;

227: l_set_name := l_master_set_name||l_ts_counter;
228: --
229: SELECT hr_assignment_sets_s.nextval
230: INTO l_ts_asg_set_id
231: FROM sys.dual;
232: --
233: INSERT INTO hr_assignment_sets (
234: ASSIGNMENT_SET_ID
235: ,BUSINESS_GROUP_ID

Line 330: FROM sys.dual;

326: l_set_name := l_master_set_name||l_sc_counter;
327: --
328: SELECT hr_assignment_sets_s.nextval
329: INTO l_sc_asg_set_id
330: FROM sys.dual;
331: --
332: INSERT INTO hr_assignment_sets (
333: ASSIGNMENT_SET_ID
334: ,BUSINESS_GROUP_ID

Line 456: from sys.dual

452: begin
453: --
454: select 1
455: into dummy
456: from sys.dual
457: where exists (select ''
458: from pay_assignment_actions
459: where payroll_action_id = p_payroll_act_id
460: and action_status <> 'C');

Line 780: FROM sys.dual;

776: l_sc_consoset_name := 'Separate Check Consolidation';
777: --
778: SELECT pay_consolidation_sets_s.nextval
779: INTO l_sc_consoset_id
780: FROM sys.dual;
781: --
782: INSERT INTO pay_consolidation_sets (
783: CONSOLIDATION_SET_ID,
784: BUSINESS_GROUP_ID,