APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 202: pay_element_links_f pelf,

198: ,pty.er_contribution_bal_type_id
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'

Line 1079: ,pay_element_links_f pelf

1075: SELECT nvl (sum (round (fnd_number.canonical_to_number (peev.screen_entry_value)
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

Line 1127: ,pay_element_links_f pelf

1123: ,c_input_val_id IN NUMBER ) IS
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

Line 1173: ,pay_element_links_f pelf

1169: ,c_asg_id NUMBER) IS
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

Line 1218: ,pay_element_links_f pelf

1214:
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

Line 1276: ,pay_element_links_f pelf

1272: SELECT pay_paywsmee_pkg.get_original_date_earned (peef.element_entry_id) start_date
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