APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 760: pay_element_entry_values_f peev,

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'
764: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'

Line 845: pay_element_entry_values_f peev,

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'
849: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'

Line 970: FROM pay_element_entry_values_f

966: -- ============================================================================
967: CURSOR c_get_retro_num_value(c_element_entry_id in number
968: ,c_input_value_id in number) IS
969: SELECT fnd_number.canonical_to_number(nvl(screen_entry_value,'0'))
970: FROM pay_element_entry_values_f
971: WHERE element_entry_id = c_element_entry_id
972: AND input_value_id = c_input_value_id;
973:
974: -- ============================================================================

Line 981: FROM pay_element_entry_values_f

977: -- ============================================================================
978: CURSOR c_get_retro_txt_value(c_element_entry_id in number
979: ,c_input_value_id in number) IS
980: SELECT nvl(screen_entry_value,' ')
981: FROM pay_element_entry_values_f
982: WHERE element_entry_id = c_element_entry_id
983: AND input_value_id = c_input_value_id;
984:
985: -- ============================================================================

Line 994: FROM pay_element_entry_values_f

990: ,c_assignment_id in number
991: ,c_element_type_id in number
992: ,c_input_value_id in number) IS
993: SELECT 1
994: FROM pay_element_entry_values_f
995: WHERE input_value_id = c_input_value_id
996: AND screen_entry_value IS NOT NULL
997: AND element_entry_id IN
998: (SELECT element_entry_id

Line 1082: pay_element_entry_values_f peev

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
1086: pelf.effective_end_date

Line 1108: pay_element_entry_values_f peev

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
1112: pelf.effective_end_date

Line 1138: pay_element_entry_values_f peev,

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,
1142: pay_payroll_actions ppa

Line 3245: pay_element_entry_values_f peev

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
3249: AND peev.effective_start_date < c_effective_date

Line 3575: pay_element_entry_values_f peev,

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
3579: AND p_effective_date BETWEEN pelf.effective_start_date AND

Line 3576: pay_element_entry_values_f peev1

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
3579: AND p_effective_date BETWEEN pelf.effective_start_date AND
3580: pelf.effective_end_date

Line 3621: pay_element_entry_values_f peev

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
3625: pelf.effective_end_date