APPS.PAY_NZ_SOE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 218: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.

214: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
215: -- This is the salary amount
216: -- obtained when the pay basis isn't null. The pay basis and assignment_id
217: -- are passed in by the view. A check is made on the effective date of
218: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
219: --
220: cursor csr_lookup is
221: select eev.screen_entry_value
222: from pay_element_entry_values_f eev,

Line 224: pay_element_entries_f pe

220: cursor csr_lookup is
221: select eev.screen_entry_value
222: from pay_element_entry_values_f eev,
223: per_pay_bases ppb,
224: pay_element_entries_f pe
225: where ppb.pay_basis_id +0 = p_pay_basis_id
226: and pe.assignment_id = p_assignment_id
227: and eev.input_value_id = ppb.input_value_id
228: and eev.element_entry_id = pe.element_entry_id