80: Iharding Changed get_work_phone so that
81: PER_PEOPLE is not searched.
82: Sxshah 19 Aug 97 Banner now on eack line.
83: mhoyes 27-AUG-97 110.5 n/a Added chk_geocodes_installed.
84: iharding 10-SEP-97 110.8 495719 Suppressed index on PER_PAY_BASES
85: within function GET_SALARY
86: dkerr 20-OCT-97 110.9 n/a Added get_business_group_id
87: mshah 17-NOV-97 110.10 n/a Added proc set_calling_context
88: and function get_calling_context
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
973: and pe.assignment_id = p_assignment_id
1088: p_pay_basis_id number) return varchar2 is
1089: --
1090: cursor csr_lookup is
1091: select name
1092: from per_pay_bases
1093: where pay_basis_id = p_pay_basis_id;
1094: --
1095: v_meaning varchar2(30) := null;
1096: --