APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 203: pay_element_entry_values_f peev,

199: FROM pay_element_type_extra_info pei,
200: pay_element_types_f pet,
201: pay_element_entries_f peef,
202: pay_element_links_f pelf,
203: pay_element_entry_values_f peev,
204: pay_input_values_f pivf,
205: pqp_pension_types_f pty
206: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
207: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'

Line 1080: ,pay_element_entry_values_f peev

1076: ,2))
1077: ,0) prior_ptp
1078: FROM pay_element_entries_f peef
1079: ,pay_element_links_f pelf
1080: ,pay_element_entry_values_f peev
1081: WHERE peef.effective_start_date > c_effective_date
1082: AND c_effective_date BETWEEN pelf.effective_start_date
1083: AND pelf.effective_end_date
1084: AND peev.effective_start_date > c_effective_date

Line 1128: ,pay_element_entry_values_f peev

1124:
1125: SELECT 1
1126: FROM pay_element_entries_f peef
1127: ,pay_element_links_f pelf
1128: ,pay_element_entry_values_f peev
1129: WHERE c_effective_date BETWEEN peef.effective_start_date
1130: AND peef.effective_end_date
1131: AND c_effective_date BETWEEN pelf.effective_start_date
1132: AND pelf.effective_end_date

Line 1174: ,pay_element_entry_values_f peev

1170: SELECT fnd_date.canonical_to_date (peev.screen_entry_value) start_date
1171: ,fnd_date.canonical_to_date (peev1.screen_entry_value) end_date
1172: FROM pay_element_entries_f peef
1173: ,pay_element_links_f pelf
1174: ,pay_element_entry_values_f peev
1175: ,pay_element_entry_values_f peev1
1176: WHERE c_effective_date BETWEEN peef.effective_start_date
1177: AND peef.effective_end_date
1178: AND c_effective_date BETWEEN pelf.effective_start_date

Line 1175: ,pay_element_entry_values_f peev1

1171: ,fnd_date.canonical_to_date (peev1.screen_entry_value) end_date
1172: FROM pay_element_entries_f peef
1173: ,pay_element_links_f pelf
1174: ,pay_element_entry_values_f peev
1175: ,pay_element_entry_values_f peev1
1176: WHERE c_effective_date BETWEEN peef.effective_start_date
1177: AND peef.effective_end_date
1178: AND c_effective_date BETWEEN pelf.effective_start_date
1179: AND pelf.effective_end_date

Line 1219: ,pay_element_entry_values_f peev

1215: SELECT min (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) start_date
1216: ,max (pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id)) end_date
1217: FROM pay_element_entries_f peef
1218: ,pay_element_links_f pelf
1219: ,pay_element_entry_values_f peev
1220: WHERE c_effective_date BETWEEN peef.effective_start_date
1221: AND peef.effective_end_date
1222: AND c_effective_date BETWEEN pelf.effective_start_date
1223: AND pelf.effective_end_date

Line 1277: ,pay_element_entry_values_f peev

1273: ,pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) end_date
1274: ,fnd_number.canonical_to_number (peev.screen_entry_value) ptp
1275: FROM pay_element_entries_f peef
1276: ,pay_element_links_f pelf
1277: ,pay_element_entry_values_f peev
1278: WHERE c_effective_date BETWEEN peef.effective_start_date
1279: AND peef.effective_end_date
1280: AND c_effective_date BETWEEN pelf.effective_start_date
1281: AND pelf.effective_end_date

Line 1517: FROM pay_element_entry_values_f

1513: ,c_input_value_id in number) IS
1514: SELECT fnd_number.canonical_to_number (nvl (screen_entry_value
1515: ,'0')) amt
1516: ,pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id) date_earned
1517: FROM pay_element_entry_values_f
1518: WHERE element_entry_id = c_element_entry_id
1519: AND input_value_id = c_input_value_id;
1520: --=========================================================================
1521: