APPS.PAY_NL_ABP_ARCHIVE dependencies on DUAL

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

2294: -- Return cursor that selects no rows
2295: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
2296: log_tech_exception(p_action_context_id => g_payroll_action_id,
2297: p_err_msg => 'range_code : '|| substr (sqlerrm, 1, 180)); --14793405
2298: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
2299: END range_code;
2300: --=========================================================================
2301:
2302: PROCEDURE initialization_code(p_action_context_id IN NUMBER) IS

Line 2395: FROM dual

2391: )
2392: UNION
2393: (
2394: SELECT c_org_id
2395: FROM dual
2396: )
2397: )
2398: OR nvl (paa.establishment_id
2399: ,- 1) = c_org_id

Line 2575: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;

2571: ,p_org_id IN NUMBER)
2572: IS
2573: l_asg_act_id NUMBER;
2574: BEGIN
2575: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
2576: hr_nonrun_asact.insact(
2577: lockingactid => l_asg_act_id
2578: ,assignid => p_assignid
2579: ,pactid => p_pactid

Line 2995: -- Individual Exemption

2991: AND nvl (pad.date_to
2992: ,hr_general.end_of_time)
2993: ORDER BY 1 DESC;
2994: --=========================================================================
2995: -- Individual Exemption
2996: CURSOR csr_prin_obj(c_assignment_id IN NUMBER
2997: ,c_effective_date IN DATE) IS
2998: SELECT decode (aei_information5
2999: ,'Y'

Line 3184: FROM dual

3180: last_day (date_earned) date_earned
3181: FROM (
3182: -- default current period
3183: SELECT c_end_date date_earned
3184: FROM dual
3185: UNION
3186: --to find the late hire scenarios paid in current period
3187: SELECT ppa.date_earned
3188: FROM pay_assignment_actions paa

Line 3297: l_individual_exem VARCHAR2(1) := NULL;

3293: l_nationality VARCHAR2(10);
3294: l_partner_details csr_get_partner_details%ROWTYPE;
3295: l_marital_status NUMBER:=NULL;
3296: l_start_date_ms DATE:=NULL;
3297: l_individual_exem VARCHAR2(1) := NULL;
3298: l_kind_emp VARCHAR2(2) := 'WN';
3299: l_income_code VARCHAR2(2) := NULL;
3300:
3301: l_street per_addresses.address_line1%TYPE := NULL;

Line 3849: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;

3845: END IF;
3846:
3847: hr_utility.trace('Payroll Id : ' ||l_payroll_id);
3848:
3849: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
3850:
3851: hr_nonrun_asact.insact(
3852: lockingactid => l_child_aa_id
3853: , assignid => l_assignment_id

Line 4374: FETCH csr_prin_obj into l_individual_exem;

4370: END IF;
4371: --
4372:
4373: OPEN csr_prin_obj(l_assignment_id,nvl(l_asg_end_date,l_end_date));
4374: FETCH csr_prin_obj into l_individual_exem;
4375: CLOSE csr_prin_obj;
4376:
4377: hr_utility.trace('Archiving Person Data : ');
4378:

Line 4414: , p_action_information25 => l_individual_exem

4410: , p_action_information21 => l_iso
4411: , p_action_information22 => l_person_addr.style
4412: , p_action_information23 => l_marital_status
4413: , p_action_information24 => fnd_date.date_to_canonical(l_start_date_ms)
4414: , p_action_information25 => l_individual_exem
4415: , p_action_information26 => fnd_date.date_to_canonical(l_start_date)
4416: , p_action_information27 => fnd_date.date_to_canonical(nvl(l_asg_end_date,l_end_date))
4417: , p_action_information28 => l_person_data
4418: );