DBA Data[Home] [Help]

APPS.PAY_AU_SGC_PKG dependencies on PER_ALL_PEOPLE_F

Line 43: cursor bal (c_business_group_id per_all_people_f.business_group_id%type,

39:
40: ---------------------Cursor to select balance id and superable salary ----------------
41: /*Bug 2610141 modfied to return on the defined balance id*/
42:
43: cursor bal (c_business_group_id per_all_people_f.business_group_id%type,
44: c_assignment_id per_all_assignments_f.assignment_id%type,
45: c_effective_date date) is
46: select hoi.org_information8
47: from

Line 165: p_business_group_id in per_all_people_f.business_group_id%type,

161: p_registered_employer NUMBER, -- 2610141
162: p_employee_age in number,
163: p_effective_date in date,
164: p_sgc_rate in number,
165: p_business_group_id in per_all_people_f.business_group_id%type,
166: p_legislation_code in pay_balance_types.legislation_code%type,--2610141
167: p_superable_sal out NOCOPY number,
168: p_sgc_contribution out NOCOPY number,
169: p_compliance_mesg out NOCOPY varchar2,

Line 180: p_business_group_id in per_all_people_f.business_group_id%type,

176: p_assignment_id in per_all_assignments_f.assignment_id%type,
177: p_employee_age in number,
178: p_effective_date in date,
179: p_sgc_rate in number,
180: p_business_group_id in per_all_people_f.business_group_id%type,
181: p_registered_employer NUMBER, -- 2610141
182: p_legislation_code in pay_balance_types.legislation_code%type--2610141
183: )
184: return varchar2;