DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 960: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.

956: --
957: p_pay_basis_id number,
958: p_assignment_id number) return varchar2 is
959: --
960: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
961: -- This is the salary amount
962: -- obtained when the pay basis isn't null. The pay basis and assignment_id
963: -- are passed in by the view. A check is made on the effective date of
964: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.

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

960: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
961: -- This is the salary amount
962: -- obtained when the pay basis isn't null. The pay basis and assignment_id
963: -- are passed in by the view. A check is made on the effective date of
964: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
965: --
966: cursor csr_lookup is
967: select eev.screen_entry_value
968: from pay_element_entry_values_f eev,

Line 968: from pay_element_entry_values_f eev,

964: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
965: --
966: cursor csr_lookup is
967: select eev.screen_entry_value
968: from pay_element_entry_values_f eev,
969: per_pay_bases ppb,
970: pay_element_entries_f pe,
971: fnd_sessions f
972: where ppb.pay_basis_id +0 = p_pay_basis_id