APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_BALANCE_TYPES

Line 130: , p_bal_id pay_balance_types.balance_type_id%type

126: -- Cursor definitions
127: -- added by rp 29-dec-2012
128: cursor get_TU_MU_LU_BIMONTH
129: (P_date pay_payroll_actions.effective_date%type
130: , p_bal_id pay_balance_types.balance_type_id%type
131: , p_tax_id pay_assignment_Actions.tax_unit_id%type
132: , p_jur_code pay_run_results.jurisdiction_code%type
133: , p_local_unit pay_run_results.local_unit_id%type)
134: is

Line 160: (p_bal_name pay_balance_types.balance_name%type

156: and RR.local_unit_id= p_local_unit ;
157:
158:
159: cursor get_balance_type_id
160: (p_bal_name pay_balance_types.balance_name%type
161: )is
162: Select balance_type_id
163: from pay_balance_types pbt
164: where pbt.balance_name = p_bal_name

Line 163: from pay_balance_types pbt

159: cursor get_balance_type_id
160: (p_bal_name pay_balance_types.balance_name%type
161: )is
162: Select balance_type_id
163: from pay_balance_types pbt
164: where pbt.balance_name = p_bal_name
165: and pbt.legislation_code = 'NO';
166:
167: cursor get_ASG_TU_MU_LU_BIMONTH

Line 169: , p_bal_id pay_balance_types.balance_type_id%type

165: and pbt.legislation_code = 'NO';
166:
167: cursor get_ASG_TU_MU_LU_BIMONTH
168: (P_asg_id pay_assignment_Actions.assignment_Action_id%type
169: , p_bal_id pay_balance_types.balance_type_id%type
170: , p_tax_id pay_assignment_Actions.tax_unit_id%type
171: , p_jur_code pay_run_results.jurisdiction_code%type
172: , p_local_unit pay_run_results.local_unit_id%type
173: ) is

Line 1515: ,pay_balance_types pbt

1511:
1512: SELECT pdb.defined_balance_id
1513: INTO l_defined_balance_id
1514: FROM pay_defined_balances pdb
1515: ,pay_balance_types pbt
1516: ,pay_balance_dimensions pbd
1517: WHERE pbd.database_item_suffix = p_dbi_suffix
1518: AND pbd.legislation_code = 'NO'
1519: AND pbt.balance_name = p_balance_name