DBA Data[Home] [Help]

APPS.PAY_GB_RTI dependencies on DUAL

Line 504: from dual;

500: cursor get_agg_start_end_dates is
501: select
502: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,
503: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date
504: from dual;
505:
506: cursor csr_get_irregular_details is
507: SELECT AEI_INFORMATION3
508: FROM PER_ASSIGNMENT_EXTRA_INFO

Line 1948: from dual;

1944: -- Create one assignment action for every assignment
1945: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
1946: select pay_assignment_actions_s.nextval
1947: into lockingactid
1948: from dual;
1949:
1950: -- Insert assignment into pay_assignment_actions
1951: hr_nonrun_asact.insact
1952: (

Line 2005: from dual;

2001: -- Create one assignment action for every assignment
2002: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2003: select pay_assignment_actions_s.nextval
2004: into lockingactid
2005: from dual;
2006:
2007: -- Insert assignment into pay_assignment_actions
2008: hr_nonrun_asact.insact
2009: (

Line 2180: from dual;

2176: -- Create one assignment action for every assignment
2177: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2178: select pay_assignment_actions_s.nextval
2179: into lockingactid
2180: from dual;
2181:
2182: -- Insert assignment into pay_assignment_actions
2183: hr_nonrun_asact.insact
2184: (