APPS.PAY_SG_SOE dependencies on PAY_ELEMENT_ENTRIES_F

Line 10: -- and pay_element_entries_f as they're datetracked.

6: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
7: -- This is the salary amount obtained when the pay basis isn't null.
8: -- The pay basis and assignment_id are passed in by the view.
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,

Line 14: p_assignment_id in pay_element_entries_f.assignment_id%type,

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:
18: cursor salary

Line 20: c_assignment_id pay_element_entries_f.assignment_id%type,

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,
24: pay_element_entries_f pee,

Line 24: pay_element_entries_f pee,

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
28: and pee.element_entry_id = pev.element_entry_id