APPS.PAY_IE_P45_ARCHIVE dependencies on DUAL

Line 2509: FROM DUAL

2505: l_business_group_id NUMBER;
2506: g_tax_dis_ref varchar2(10);
2507: CURSOR csr_check_archived(p_pact_id NUMBER) IS
2508: SELECT 1
2509: FROM DUAL
2510: WHERE EXISTS (SELECT NULL
2511: FROM pay_action_information pai
2512: WHERE pai.action_context_id = p_pact_id
2513: AND pai.action_context_type = 'PA'

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

2892: --get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
2893: --Added for bug fix 3567562
2894: /*
2895: if l_error ='Y' then
2896: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
2897: else
2898: */
2899: sqlstr := 'SELECT DISTINCT person_id
2900: FROM per_people_f ppf,

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

2906: --end if;
2907: Exception
2908: when others then
2909: hr_utility.set_location('Leaving via exception section ' || l_proc,40);
2910: sqlstr:='select 1 from dual where to_char(:payroll_action_id) = dummy';
2911: END range_cursor;
2912:
2913: -------------------------------------------------
2914: PROCEDURE action_creation (pactid in number,

Line 3124: FROM dual;

3120: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
3121:
3122: SELECT pay_assignment_actions_s.NEXTVAL
3123: INTO l_actid
3124: FROM dual;
3125:
3126: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3127: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3128: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);

Line 3403: FROM dual;

3399: -- Create child P45 action to lock the child payroll process child action
3400: -- To avoid data corruption 4468864
3401: SELECT pay_assignment_actions_s.NEXTVAL
3402: INTO l_actid
3403: FROM dual;
3404:
3405: hr_nonrun_asact.insact(
3406: lockingactid => l_actid
3407: , assignid => l_assignment_id