APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 201: pay_element_entries_f peef,

197: ,pty.ee_contribution_bal_type_id
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

Line 1078: FROM pay_element_entries_f peef

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

Line 1126: FROM pay_element_entries_f peef

1122: ,c_ele_type_id IN NUMBER
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

Line 1172: FROM pay_element_entries_f peef

1168: ,c_end_dt_id NUMBER
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

Line 1217: FROM pay_element_entries_f peef

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

Line 1275: FROM pay_element_entries_f peef

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

Line 2488: FROM pay_element_entries_f peef

2484: ,c_start_date IN DATE
2485: ,c_end_date IN DATE)
2486: IS
2487: SELECT 1
2488: FROM pay_element_entries_f peef
2489: WHERE peef.assignment_id = c_asg_id
2490: AND (
2491: c_start_date BETWEEN peef.effective_start_date
2492: AND peef.effective_end_date