APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on DUAL

Line 367: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';

363: --
364: END LOOP;
365: --
366: IF l_test_flag = 0 THEN
367: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
368: ELSE
369: sqlstr := 'SELECT distinct person_id
370: FROM per_people_f ppf
371: ,pay_payroll_actions ppa

Line 379: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';

375: END IF;
376: --
377: EXCEPTION
378: WHEN OTHERS THEN
379: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
380:
381: END range_cursor_archive;
382: --------------------------------------------------------------------------------
383: -- ACTION CREATION --

Line 643: FROM dual;

639: IF csr_filter_legal_employer%FOUND THEN
640:
641: SELECT pay_assignment_actions_s.NEXTVAL
642: INTO l_actid
643: FROM dual;
644:
645: hr_nonrun_asact.insact(l_actid
646: ,qualifying_assignments.assignment_id
647: ,pactid

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

1468: and ppa.business_group_id = ppf.business_group_id
1469: order by ppf.person_id';
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1473: --
1474: END range_cursor_lock;
1475: --------------------------------------------------------------------------------
1476: -- ACTION CREATION -- Data Lock Process

Line 1538: FROM dual;

1534: -- create a new action and lock the fetched one
1535: --
1536: SELECT pay_assignment_actions_s.NEXTVAL
1537: INTO l_actid
1538: FROM dual;
1539: --
1540: hr_nonrun_asact.insact(l_actid
1541: ,qualifying_assignments.action_context_id
1542: ,pactid