APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on DUAL

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

797: EXCEPTION
798:
799: WHEN OTHERS THEN
800: -- Return cursor that selects no rows
801: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
802:
803:
804:
805: END RANGE_CODE;

Line 965: FROM dual;

961: --
962:
963: SELECT pay_assignment_actions_s.NEXTVAL
964: INTO l_actid
965: FROM dual;
966: --
967: -- Create the archive assignment action
968: --
969: --Bug 3384315

Line 1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours

1480: ,FND_NUMBER.Canonical_To_Number(scl.segment12) prev_year_sal
1481: ,scl.segment4 tax_reduction
1482: ,scl.segment7 labour_tax_reduction
1483: ,scl.segment9 add_senior_tax_reduction
1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours
1485: FROM per_assignments_f paf
1486: ,hr_soft_coding_keyflex scl
1487: WHERE paf.assignment_id = p_assignment_id
1488: AND p_date_earned BETWEEN paf.effective_start_date

Line 1687: l_individual_working_hours NUMBER;

1683: l_regular_working_hours NUMBER;
1684: l_action_info_id NUMBER;
1685: l_ovn NUMBER;
1686: l_organization_Id NUMBER;
1687: l_individual_working_hours NUMBER;
1688: l_not_defined VARCHAR2(255);
1689: l_province hr_lookups.meaning%TYPE;
1690: l_city hr_lookups.meaning%TYPE;
1691: l_street_name hr_lookups.meaning%TYPE;

Line 1704: ,l_individual_working_hours;

1700: ,l_dummy
1701: ,l_tax_reduction
1702: ,l_labour_tax_reduction
1703: ,l_add_senior_tax_reduction
1704: ,l_individual_working_hours;
1705: --
1706: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_prev_year_sal'||l_prev_year_sal,1420);
1707:
1708: IF csr_nl_employee_details%FOUND THEN

Line 1912: --l_individual_working_hours

1908: -- Archive NL OTHER EMPLOYEE DETAILS
1909: --
1910: --pay_action_information_api.create_action_information ();
1911: --
1912: --l_individual_working_hours
1913: --
1914: pay_action_information_api.create_action_information (
1915: p_action_information_id => l_action_info_id
1916: ,p_action_context_id => p_assg_action_id

Line 1925: ,p_action_information6 =>fnd_number.number_to_canonical(l_individual_working_hours)

1921: ,p_source_text => NULL
1922: ,p_action_information_category => 'NL OTHER EMPLOYEE DETAILS'
1923: ,p_action_information4 =>p_payroll_id
1924: ,p_action_information5 =>l_employer_id
1925: ,p_action_information6 =>fnd_number.number_to_canonical(l_individual_working_hours)
1926: ,p_action_information7 =>l_legal_min_payment
1927: ,p_action_information8 =>fnd_number.number_to_canonical(l_si_days));
1928:
1929: OPEN csr_get_hr_org_address(l_employer_id);

Line 3181: -- Get Individual Percentage Value

3177: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3178: -- Rate to be archived.
3179: IF p_element_name = 'Special Tax Deduction' THEN
3180: --
3181: -- Get Individual Percentage Value
3182: --
3183: OPEN csr_add_element_values(p_run_assign_action_id
3184: ,p_class_name
3185: ,p_element_name

Line 3415: -- Get Individual Percentage Value

3411: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3412: -- Rate to be archived.
3413: IF p_element_name = 'Retro Special Tax Deduction' THEN
3414: --
3415: -- Get Individual Percentage Value
3416: --
3417: OPEN csr_add_element_values(csr_np_rec.np_assignment_action_id
3418: ,p_class_name
3419: ,p_element_name

Line 3626: -- Get Individual Percentage Value

3622: -- Special Tax Deduction Elemetns requires Pay Value and Percentage
3623: -- Rate to be archived.
3624: IF p_element_name = 'Special Tax Deduction' THEN
3625: --
3626: -- Get Individual Percentage Value
3627: --
3628: OPEN csr_add_element_values(csr_np_rec.np_assignment_action_id
3629: ,p_class_name
3630: ,p_element_name