APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 741: pay_element_entry_values_f peev,

737: FROM pay_element_type_extra_info pei,
738: pay_element_types_f pet,
739: pay_element_entries_f peef,
740: pay_element_links_f pelf,
741: pay_element_entry_values_f peev,
742: pay_input_values_f pivf,
743: pqp_pension_types_f pty
744: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
745: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'

Line 826: pay_element_entry_values_f peev,

822: FROM pay_element_type_extra_info pei,
823: pay_element_types_f pet,
824: pay_element_entries_f peef,
825: pay_element_links_f pelf,
826: pay_element_entry_values_f peev,
827: pay_input_values_f pivf,
828: pqp_pension_types_f pty
829: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
830: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'

Line 951: FROM pay_element_entry_values_f

947: -- ============================================================================
948: CURSOR c_get_retro_num_value(c_element_entry_id in number
949: ,c_input_value_id in number) IS
950: SELECT fnd_number.canonical_to_number(nvl(screen_entry_value,'0'))
951: FROM pay_element_entry_values_f
952: WHERE element_entry_id = c_element_entry_id
953: AND input_value_id = c_input_value_id;
954:
955: -- ============================================================================

Line 962: FROM pay_element_entry_values_f

958: -- ============================================================================
959: CURSOR c_get_retro_txt_value(c_element_entry_id in number
960: ,c_input_value_id in number) IS
961: SELECT nvl(screen_entry_value,' ')
962: FROM pay_element_entry_values_f
963: WHERE element_entry_id = c_element_entry_id
964: AND input_value_id = c_input_value_id;
965:
966: -- ============================================================================

Line 975: FROM pay_element_entry_values_f

971: ,c_assignment_id in number
972: ,c_element_type_id in number
973: ,c_input_value_id in number) IS
974: SELECT 1
975: FROM pay_element_entry_values_f
976: WHERE input_value_id = c_input_value_id
977: AND screen_entry_value IS NOT NULL
978: AND element_entry_id IN
979: (SELECT element_entry_id

Line 1063: pay_element_entry_values_f peev

1059: ,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
1060: ,fnd_number.canonical_to_number(peev.screen_entry_value) ptp
1061: FROM pay_element_entries_f peef,
1062: pay_element_links_f pelf,
1063: pay_element_entry_values_f peev
1064: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1065: peef.effective_end_date
1066: AND c_effective_date BETWEEN pelf.effective_start_date AND
1067: pelf.effective_end_date

Line 1089: pay_element_entry_values_f peev

1085:
1086: SELECT 1
1087: FROM pay_element_entries_f peef,
1088: pay_element_links_f pelf,
1089: pay_element_entry_values_f peev
1090: WHERE c_effective_date BETWEEN peef.effective_start_date AND
1091: peef.effective_end_date
1092: AND c_effective_date BETWEEN pelf.effective_start_date AND
1093: pelf.effective_end_date

Line 1119: pay_element_entry_values_f peev,

1115: ,add_months(to_date('1/'||to_char(ppa.date_earned,'MM/YYYY'),'DD/MM/YYYY'),1) - 1 end_date
1116: ,fnd_number.canonical_to_number(prrv.result_value) ptp, 'Y' Yes
1117: FROM pay_element_entries_f peef,
1118: pay_element_links_f pelf,
1119: pay_element_entry_values_f peev,
1120: pay_run_results prr,
1121: pay_run_result_values prrv,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa

Line 3224: pay_element_entry_values_f peev

3220: ,c_input_val_id IN NUMBER ) IS
3221: SELECT NVL(sum(round(fnd_number.canonical_to_number(peev.screen_entry_value),2)),0) prior_ptp
3222: FROM pay_element_entries_f peef,
3223: pay_element_links_f pelf,
3224: pay_element_entry_values_f peev
3225: WHERE peef.effective_start_date < c_effective_date
3226: AND c_effective_date BETWEEN pelf.effective_start_date AND
3227: pelf.effective_end_date
3228: AND peev.effective_start_date < c_effective_date