[Home] [Help]
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
48: hr_organization_information hoi,
97:
98: ---------------cursor to select working hours ------------------------
99: /* obsolete as per bug 1560081
100: Cursor assign_work_hrs (c_effective_date date,
101: c_assignment_id per_all_assignments_f.assignment_id%type)
102: is
103: select assign.normal_hours from
104: per_assignments_f assign,
105: hr_lookups hr3
120:
121: CURSOR assign_work_hrs
122: (c_effective_date date,
123: c_assignment_id per_assignments_f.assignment_id%TYPE,
124: c_business_group_id per_all_assignments_f.business_group_id%TYPE,
125: c_registered_employer NUMBER -- 2610141
126: )
127: is
128: select nvl(nvl(hsck.segment4,nvl(
156:
157: -------------------------------procedure employee_super_details------------------------
158:
159: procedure employee_super_details
160: (p_assignment_id in per_all_assignments_f.assignment_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,
172:
173: ----------------------------function compliance_mesg-----------------------------------
174:
175: function compliance_mesg(
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,