[Home] [Help]
33: g_age_min number;
34: g_min_hrs_worked number;
35: g_qtd_threshold number;
36: g_super_guarantee_bal_id_mtd pay_defined_balances.defined_balance_id%type; --2610141
37: g_end_date hr_organization_information.org_information10%type;
38:
39:
40: ---------------------Cursor to select balance id and superable salary ----------------
41: /*Bug 2610141 modfied to return on the defined balance id*/
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,
49: hr_organization_units hou,
50: pay_personal_payment_methods_f pppm
51: where
52: hoi.org_information_context='AU_SUPER_FUND'
132: )),g_min_hrs_worked + 1)
133: from
134: per_assignments_f paa,
135: hr_soft_coding_keyflex hsck,
136: hr_organization_information hoi,
137: hr_organization_units hou
138: where
139: hoi.org_information_context='Work Day Information' and
140: hoi.organization_id=hou.organization_id and