DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on DUAL

Line 1572: sqlstr:='select 1 from dual where to_char(:payroll_action_id) = dummy';

1568:
1569: Exception
1570: when others then
1571: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
1572: sqlstr:='select 1 from dual where to_char(:payroll_action_id) = dummy';
1573: END range_code;
1574:
1575:
1576: /* Action Creation */

Line 1880: FROM dual;

1876: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
1877:
1878: SELECT pay_assignment_actions_s.NEXTVAL
1879: INTO l_actid
1880: FROM dual;
1881:
1882: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
1883: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
1884: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);

Line 2313: FROM dual;

2309: -- Create child cess action to lock the child payroll process child action
2310: -- To avoid data corruption 4468864
2311: SELECT pay_assignment_actions_s.NEXTVAL
2312: INTO l_actid
2313: FROM dual;
2314:
2315: hr_nonrun_asact.insact(
2316: lockingactid => l_actid
2317: , assignid => l_assignment_id