DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PER_PAY_BASES

Line 84: iharding 10-SEP-97 110.8 495719 Suppressed index on PER_PAY_BASES

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

Line 969: per_pay_bases ppb,

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

Line 1092: from per_pay_bases

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: --