[Home] [Help]
755: ,pty.er_contribution_bal_type_id
756: FROM pay_element_type_extra_info pei,
757: pay_element_types_f pet,
758: pay_element_entries_f peef,
759: pay_element_links_f pelf,
760: pay_element_entry_values_f peev,
761: pay_input_values_f pivf,
762: pqp_pension_types_f pty
763: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
840: ,pty.er_contribution_bal_type_id
841: FROM pay_element_type_extra_info pei,
842: pay_element_types_f pet,
843: pay_element_entries_f peef,
844: pay_element_links_f pelf,
845: pay_element_entry_values_f peev,
846: pay_input_values_f pivf,
847: pqp_pension_types_f pty
848: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
1077: SELECT to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY') start_date
1078: ,add_months(to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1079: ,fnd_number.canonical_to_number(peev.screen_entry_value) ptp
1080: FROM pay_element_entries_f peef,
1081: pay_element_links_f pelf,
1082: pay_element_entry_values_f peev
1083: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1084: peef.effective_end_date
1085: AND c_effective_date BETWEEN pelf.effective_start_date AND
1103: ,c_input_val_id IN NUMBER ) IS
1104:
1105: SELECT 1
1106: FROM pay_element_entries_f peef,
1107: pay_element_links_f pelf,
1108: pay_element_entry_values_f peev
1109: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1110: peef.effective_end_date
1111: AND c_effective_date BETWEEN pelf.effective_start_date AND
1133: SELECT to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY') start_date
1134: ,add_months(to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1135: ,fnd_number.canonical_to_number(prrv.result_value) ptp, 'Y' Yes
1136: FROM pay_element_entries_f peef,
1137: pay_element_links_f pelf,
1138: pay_element_entry_values_f peev,
1139: pay_run_results prr,
1140: pay_run_result_values prrv,
1141: pay_assignment_actions paa,
2864: --
2865: CURSOR c_abp_entry IS
2866: SELECT 1
2867: FROM pay_element_entries_f peef,
2868: pay_element_links_f pelf
2869: WHERE p_effective_date BETWEEN peef.effective_start_date AND
2870: peef.effective_end_date
2871: AND p_effective_date BETWEEN pelf.effective_start_date AND
2872: pelf.effective_end_date
3240: ,c_ele_type_id IN NUMBER
3241: ,c_input_val_id IN NUMBER ) IS
3242: SELECT NVL(sum(round(fnd_number.canonical_to_number(peev.screen_entry_value),2)),0) prior_ptp
3243: FROM pay_element_entries_f peef,
3244: pay_element_links_f pelf,
3245: pay_element_entry_values_f peev
3246: WHERE peef.effective_start_date < c_effective_date
3247: AND c_effective_date BETWEEN pelf.effective_start_date AND
3248: pelf.effective_end_date
3570:
3571: CURSOR c_ude_rec05(p_effective_date date, p_ele_type_id number, p_start_dt_id number, p_end_dt_id number, p_asg_id number) IS
3572: SELECT fnd_date.canonical_to_date(peev.screen_entry_value) start_date, fnd_date.canonical_to_date(peev1.screen_entry_value) end_date
3573: FROM pay_element_entries_f peef,
3574: pay_element_links_f pelf,
3575: pay_element_entry_values_f peev,
3576: pay_element_entry_values_f peev1
3577: WHERE p_effective_date BETWEEN peef.effective_start_date AND
3578: peef.effective_end_date
3616: SELECT
3617: MIN(to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY')) start_date,
3618: MAX(add_months(to_date('1/'||to_char(pay_paywsmee_pkg.get_original_date_earned(peef.element_entry_id),'MM/YYYY'),'DD/MM/YYYY'),1) - 1) end_date
3619: FROM pay_element_entries_f peef,
3620: pay_element_links_f pelf,
3621: pay_element_entry_values_f peev
3622: WHERE c_effective_date BETWEEN peef.effective_start_date AND
3623: peef.effective_end_date
3624: AND c_effective_date BETWEEN pelf.effective_start_date AND