APPS.PAY_SG_SOE dependencies on PER_PAY_BASES

Line 13: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,

9: -- A check is made on the effective date of pay_element_entry_values_f
10: -- and pay_element_entries_f as they're datetracked.
11: ------------------------------------------------------------------------
12: function current_salary
13: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
14: p_assignment_id in pay_element_entries_f.assignment_id%type,
15: p_effective_date in date)
16: return varchar2 is
17:

Line 19: (c_pay_basis_id per_pay_bases.pay_basis_id%type,

15: p_effective_date in date)
16: return varchar2 is
17:
18: cursor salary
19: (c_pay_basis_id per_pay_bases.pay_basis_id%type,
20: c_assignment_id pay_element_entries_f.assignment_id%type,
21: c_effective_date date) is
22: select pev.screen_entry_value
23: from per_pay_bases ppb,

Line 23: from per_pay_bases ppb,

19: (c_pay_basis_id per_pay_bases.pay_basis_id%type,
20: c_assignment_id pay_element_entries_f.assignment_id%type,
21: c_effective_date date) is
22: select pev.screen_entry_value
23: from per_pay_bases ppb,
24: pay_element_entries_f pee,
25: pay_element_entry_values_f pev
26: where pee.assignment_id = c_assignment_id
27: and ppb.pay_basis_id = c_pay_basis_id