APPS.PAY_AU_SOE_PKG dependencies on PER_PAY_BASES

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

97: -- A check is made on the effective date of pay_element_entry_values_f
98: -- and pay_element_entries_f as they're datetracked.
99: ------------------------------------------------------------------------
100: function get_salary
101: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
102: p_assignment_id in pay_element_entries_f.assignment_id%type,
103: p_effective_date in date)
104: return varchar2 is
105:

Line 107: (c_pay_basis_id per_pay_bases.pay_basis_id%type,

103: p_effective_date in date)
104: return varchar2 is
105:
106: cursor salary
107: (c_pay_basis_id per_pay_bases.pay_basis_id%type,
108: c_assignment_id pay_element_entries_f.assignment_id%type,
109: c_effective_date date) is
110: select pev.screen_entry_value
111: from per_pay_bases ppb,

Line 111: from per_pay_bases ppb,

107: (c_pay_basis_id per_pay_bases.pay_basis_id%type,
108: c_assignment_id pay_element_entries_f.assignment_id%type,
109: c_effective_date date) is
110: select pev.screen_entry_value
111: from per_pay_bases ppb,
112: pay_element_entries_f pee,
113: pay_element_entry_values_f pev
114: where pee.assignment_id = c_assignment_id
115: and ppb.pay_basis_id = c_pay_basis_id

Line 1160: FROM pay_input_values_f pivf, per_pay_bases ppb

1156: and pet.element_name= 'Normal Hours');
1157:
1158: CURSOR Cr_element_type_id IS (
1159: SELECT pivf.element_type_id
1160: FROM pay_input_values_f pivf, per_pay_bases ppb
1161: WHERE pivf.input_value_id = ppb.input_value_id
1162: AND ppb.pay_basis_id = p_pay_bases_id);
1163:
1164: /* Bug 5967108 - Added Check for Input with Name - Hours */