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 971: per_pay_bases ppb,

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
975: and pe.assignment_id = p_assignment_id

Line 1094: from per_pay_bases

1090: p_pay_basis_id number) return varchar2 is
1091: --
1092: cursor csr_lookup is
1093: select name
1094: from per_pay_bases
1095: where pay_basis_id = p_pay_basis_id;
1096: --
1097: v_meaning varchar2(30) := null;
1098: --