[Home] [Help]
1544: ,hr_loc.address_line_1 add_line1
1545: ,hr_loc.address_line_2 add_line2
1546: ,hr_loc.address_line_3 add_line3
1547: -- ,hr_loc.postal_code postal_code
1548: ,pay_nl_general.get_postal_code_new(hr_loc.postal_code) postal_code
1549: ,hr_loc.town_or_city city
1550: ,hr_loc.region_2 province
1551: ,hr_loc.country country
1552: ,hr_loc.region_3 po_box_no
2759: AND pet.element_name = NVL(p_element_name,pet.element_name)
2760: AND pec.legislation_code = 'NL'
2761: AND pet.element_type_id = pettl.element_type_id
2762: AND pettl.language = USERENV('LANG')
2763: AND p_retro_period = nvl( prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/,p_retro_period) --Bug 5107780
2764: AND p_date_earned BETWEEN pet.effective_start_date
2765: AND pet.effective_end_date
2766: AND p_date_earned BETWEEN piv.effective_start_date
2767: AND piv.effective_end_date;
2770: ,p_class_name VARCHAR2
2771: ,p_element_name VARCHAR2
2772: ,p_input_value_name VARCHAR2
2773: ,p_date_earned DATE) IS
2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2794: AND p_date_earned BETWEEN pet.effective_start_date
2795: AND pet.effective_end_date
2796: AND p_date_earned BETWEEN piv.effective_start_date
2797: AND piv.effective_end_date
2798: ORDER BY prr.start_date ; --pay_nl_general.get_retro_period(prr.source_id,p_date_earned); Bug 5107780
2799:
2800: CURSOR csr_element_values (p_run_assign_action_id NUMBER
2801: ,p_class_name VARCHAR2
2802: ,p_element_name VARCHAR2
2802: ,p_element_name VARCHAR2
2803: ,p_input_value_name VARCHAR2
2804: ,p_date_earned DATE) IS
2805: SELECT prv.result_value value
2806: ,fnd_date.date_to_canonical( prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ ) RDate
2807: ,pet.element_type_id element_type_id
2808: ,pet.element_name element_name
2809: ,nvl(pettl.reporting_name,pettl.element_name) reporting_name
2810: ,pet.processing_priority priority
4512: ,p_standard_bal_name VARCHAR2
4513: ,p_special_bal_name VARCHAR2
4514: ,p_date_earned DATE
4515: ,p_classification_id NUMBER ) IS
4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4589: AND p_date_earned BETWEEN pet.effective_start_date
4590: AND pet.effective_end_date
4591: AND p_date_earned BETWEEN piv.effective_start_date
4592: AND piv.effective_end_date
4593: and /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ prr.start_date = p_retro_date -- Bug 5107780
4594: group by pet.processing_priority;
4595:
4596:
4597: CURSOR csr_retro_values(p_assignment_action_id NUMBER
4652: AND p_date_earned BETWEEN piv1.effective_start_date
4653: AND piv1.effective_end_date
4654: AND p_date_earned BETWEEN piv2.effective_start_date
4655: AND piv2.effective_end_date
4656: and /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ prr.start_date = p_retro_date
4657: group by prrv1.result_value,pet.processing_priority; -- Bug 5107780
4658:
4659:
4660: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
6246: --
6247: FETCH csr_assignment_actions into csr_rec;
6248:
6249: --Bug 5982957 Starts (To identify the Late Hire Assignments)
6250: l_dp_de := pay_nl_general.check_de_dp_dimension_old(csr_rec.pay_payroll_action_id
6251: ,csr_rec.assignment_id
6252: ,csr_rec.master_assignment_action_id
6253: );
6254: --Bug 5982957 Ends