APPS.PAY_IE_P45_ARCHIVE dependencies on DUAL

Line 3215: FROM DUAL

3211: l_business_group_id NUMBER;
3212: g_tax_dis_ref varchar2(10);
3213: CURSOR csr_check_archived(p_pact_id NUMBER) IS
3214: SELECT 1
3215: FROM DUAL
3216: WHERE EXISTS (SELECT NULL
3217: FROM pay_action_information pai
3218: WHERE pai.action_context_id = p_pact_id
3219: AND pai.action_context_type = 'PA'

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

3600: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
3601: --Added for bug fix 3567562
3602: /*
3603: if l_error ='Y' then
3604: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
3605: else
3606: */
3607: sqlstr := 'SELECT DISTINCT person_id
3608: FROM per_people_f ppf,

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

3614: --end if;
3615: Exception
3616: when others then
3617: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
3618: sqlstr:='select 1 from dual where to_char(:payroll_action_id) = dummy';
3619: END range_cursor;
3620:
3621: -------------------------------------------------
3622: PROCEDURE action_creation (pactid in number,

Line 3893: FROM dual;

3889: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
3890:
3891: SELECT pay_assignment_actions_s.NEXTVAL
3892: INTO l_actid
3893: FROM dual;
3894:
3895: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3896: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3897: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);

Line 4235: FROM dual;

4231: -- Create child P45 action to lock the child payroll process child action
4232: -- To avoid data corruption 4468864
4233: SELECT pay_assignment_actions_s.NEXTVAL
4234: INTO l_actid
4235: FROM dual;
4236:
4237: hr_nonrun_asact.insact(
4238: lockingactid => l_actid
4239: , assignid => l_assignment_id