APPS.PAY_AU_SGC_PKG dependencies on PAY_BALANCE_TYPES

Line 66: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/

62: order by 1 ;
63:
64:
65: /*Bug 2610141 Cursor to get the balance value for a particular defined balance id*/
66: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
67:
68: cursor bal_id_mtd(c_balance_type_id pay_balance_types.balance_type_id%type,
69: c_legislation_code pay_balance_types.legislation_code%type)
70: is

Line 68: cursor bal_id_mtd(c_balance_type_id pay_balance_types.balance_type_id%type,

64:
65: /*Bug 2610141 Cursor to get the balance value for a particular defined balance id*/
66: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
67:
68: cursor bal_id_mtd(c_balance_type_id pay_balance_types.balance_type_id%type,
69: c_legislation_code pay_balance_types.legislation_code%type)
70: is
71: select pdb.defined_balance_id
72: FROM pay_balance_types pbt,

Line 69: c_legislation_code pay_balance_types.legislation_code%type)

65: /*Bug 2610141 Cursor to get the balance value for a particular defined balance id*/
66: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
67:
68: cursor bal_id_mtd(c_balance_type_id pay_balance_types.balance_type_id%type,
69: c_legislation_code pay_balance_types.legislation_code%type)
70: is
71: select pdb.defined_balance_id
72: FROM pay_balance_types pbt,
73: pay_balance_dimensions pbd,

Line 72: FROM pay_balance_types pbt,

68: cursor bal_id_mtd(c_balance_type_id pay_balance_types.balance_type_id%type,
69: c_legislation_code pay_balance_types.legislation_code%type)
70: is
71: select pdb.defined_balance_id
72: FROM pay_balance_types pbt,
73: pay_balance_dimensions pbd,
74: pay_defined_balances pdb
75: where pbt.balance_type_id=c_balance_type_id
76: AND nvl(pbt.legislation_code,'AU')=c_legislation_code

Line 83: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/

79: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
80:
81:
82: /*Bug 2610141 - Portion added to get the defined balance id for _ASG_LE_QTD*/
83: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
84: cursor bal_id_qtd(c_balance_type_id pay_balance_types.balance_type_id%type,
85: c_legislation_code pay_balance_types.legislation_code%type)
86: is
87: select pdb.defined_balance_id

Line 84: cursor bal_id_qtd(c_balance_type_id pay_balance_types.balance_type_id%type,

80:
81:
82: /*Bug 2610141 - Portion added to get the defined balance id for _ASG_LE_QTD*/
83: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
84: cursor bal_id_qtd(c_balance_type_id pay_balance_types.balance_type_id%type,
85: c_legislation_code pay_balance_types.legislation_code%type)
86: is
87: select pdb.defined_balance_id
88: FROM pay_balance_types pbt,

Line 85: c_legislation_code pay_balance_types.legislation_code%type)

81:
82: /*Bug 2610141 - Portion added to get the defined balance id for _ASG_LE_QTD*/
83: /* Bug 5143056 Modified check for legislation code from pay_balance_types put nvl*/
84: cursor bal_id_qtd(c_balance_type_id pay_balance_types.balance_type_id%type,
85: c_legislation_code pay_balance_types.legislation_code%type)
86: is
87: select pdb.defined_balance_id
88: FROM pay_balance_types pbt,
89: pay_balance_dimensions pbd,

Line 88: FROM pay_balance_types pbt,

84: cursor bal_id_qtd(c_balance_type_id pay_balance_types.balance_type_id%type,
85: c_legislation_code pay_balance_types.legislation_code%type)
86: is
87: select pdb.defined_balance_id
88: FROM pay_balance_types pbt,
89: pay_balance_dimensions pbd,
90: pay_defined_balances pdb
91: where pbt.balance_type_id=c_balance_type_id
92: AND nvl(pbt.legislation_code,'AU')=c_legislation_code

Line 153: p_legislation_code in pay_balance_types.legislation_code%type

149: --------------------------procedure global_super_values-----------------------------
150:
151: procedure global_super_values(
152: p_effective_date in date,
153: p_legislation_code in pay_balance_types.legislation_code%type
154: );
155:
156:
157: -------------------------------procedure employee_super_details------------------------

Line 166: p_legislation_code in pay_balance_types.legislation_code%type,--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,
170: p_warning_mesg out NOCOPY varchar2

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

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;
185:
186: END pay_au_sgc_pkg ;