eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_SGC_PKG dependencies on PAY_BALANCE_TYPES

Line 34: p_legislation_code in pay_balance_types.

30: ----------------/* procedure global_super_values */-----------------------
31:
32: procedure global_super_values(
33: p_effective_date in date,
34: p_legislation_code in pay_balance_types.
35: legislation_code%type
36: )
37: as
38: cursor c_global(c_effective_date date,

Line 39: c_legislation_code pay_balance_types.legislation_code%type) is

35: legislation_code%type
36: )
37: as
38: cursor c_global(c_effective_date date,
39: c_legislation_code pay_balance_types.legislation_code%type) is
40: select global_name,global_value from
41: ff_globals_f where global_name in ('SUPER_MONTHLY_EARNINGS',
42: 'SUPER_MAX_AGE',
43: 'SUPER_MIN_AGE',

Line 52: cursor c_super_bal_id(c_legislation_code pay_balance_types.legislation_code%type,

48: and legislation_code=c_legislation_code;
49:
50: /*Bug 2610141----Modfied the cursor to return defined_balanace_id */
51:
52: cursor c_super_bal_id(c_legislation_code pay_balance_types.legislation_code%type,
53: c_dimension_name pay_balance_dimensions.database_item_suffix%type)
54: is
55: select pdb.defined_balance_id
56: FROM pay_balance_types pbt,

Line 56: FROM pay_balance_types pbt,

52: cursor c_super_bal_id(c_legislation_code pay_balance_types.legislation_code%type,
53: c_dimension_name pay_balance_dimensions.database_item_suffix%type)
54: is
55: select pdb.defined_balance_id
56: FROM pay_balance_types pbt,
57: pay_balance_dimensions pbd,
58: pay_defined_balances pdb
59: where pbt.balance_name='Super_Guarantee'
60: AND pbt.legislation_code=c_legislation_code

Line 127: p_legislation_code in pay_balance_types.legislation_code%type--2610141

123: p_effective_date in date,
124: p_sgc_rate in number,
125: p_business_group_id in per_all_people_f.business_group_id%type,
126: p_registered_employer in NUMBER, --2610141
127: p_legislation_code in pay_balance_types.legislation_code%type--2610141
128: ) return varchar2
129: IS
130:
131: /*Bug 2610141 - Portion added to get the latest assignment action id*/

Line 157: l_bal_id pay_balance_types.balance_type_id%type;

153: l_min_superable_salary number;
154: l_SGC_qtd number;
155: l_sgc_contribution number;
156: l_superable_sal number;
157: l_bal_id pay_balance_types.balance_type_id%type;
158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
159: l_salary number;
160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141

Line 158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141

154: l_SGC_qtd number;
155: l_sgc_contribution number;
156: l_superable_sal number;
157: l_bal_id pay_balance_types.balance_type_id%type;
158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
159: l_salary number;
160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
162: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141

Line 160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;

156: l_superable_sal number;
157: l_bal_id pay_balance_types.balance_type_id%type;
158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
159: l_salary number;
160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
162: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
163:
164:

Line 295: p_legislation_code in pay_balance_types.legislation_code%type,--2610141

291: p_employee_age in number,
292: p_effective_date in date,
293: p_sgc_rate in number,
294: p_business_group_id in per_all_people_f.business_group_id%type,
295: p_legislation_code in pay_balance_types.legislation_code%type,--2610141
296: p_superable_sal out NOCOPY number,
297: p_sgc_contribution out NOCOPY number,
298: p_compliance_mesg out NOCOPY varchar2,
299: p_warning_mesg out NOCOPY varchar2

Line 326: l_bal_id pay_balance_types.balance_type_id%type;

322: l_hrs_worked number ;
323: l_min_superable_salary number;
324: l_max_superable_salary number;
325: l_SGC_qtd number;
326: l_bal_id pay_balance_types.balance_type_id%type;
327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
328: l_salary number;
329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141

Line 327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141

323: l_min_superable_salary number;
324: l_max_superable_salary number;
325: l_SGC_qtd number;
326: l_bal_id pay_balance_types.balance_type_id%type;
327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
328: l_salary number;
329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141

Line 329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;

325: l_SGC_qtd number;
326: l_bal_id pay_balance_types.balance_type_id%type;
327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
328: l_salary number;
329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
332:
333: