958: --
959: p_pay_basis_id number,
960: p_assignment_id number) return varchar2 is
961: --
962: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
963: -- This is the salary amount
964: -- obtained when the pay basis isn't null. The pay basis and assignment_id
965: -- are passed in by the view. A check is made on the effective date of
966: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
962: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
963: -- This is the salary amount
964: -- obtained when the pay basis isn't null. The pay basis and assignment_id
965: -- are passed in by the view. A check is made on the effective date of
966: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
967: --
968: cursor csr_lookup is
969: select eev.screen_entry_value
970: from pay_element_entry_values_f eev,
966: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
967: --
968: cursor csr_lookup is
969: select eev.screen_entry_value
970: from pay_element_entry_values_f eev,
971: per_pay_bases ppb,
972: pay_element_entries_f pe,
973: fnd_sessions f
974: where ppb.pay_basis_id +0 = p_pay_basis_id