[Home] [Help]
111: 10-May-2006 sackumar 115.43 Bug 5068645. modified the dynamic query in load_er_tax procedure.
112: 24-May-2006 sackumar 115.44 Bug 5244469. modified the dynamic query in load_er_tax procedure.
113: 11-AUG-2006 saurgupt 115.45 Bug 5409416: Modified the procedure load_er_credit. Removed
114: prr.jurisdiction_code from select clause as this will fail if l_futa_from
115: is pay_run_balances table.
116: 16-OCT-2006 jdevasah 115.46 Bug 4942114: Dynamic cursors in procedures load_deductions, load_earnings,
117: load_ee_tax, load_er_tax, load_ee_credit, load_er_credit, load_er_liab
118: and load_wc_er_liab are replaced by static procedures. Input parameters
119: to all the above procedures are changed to status flags instead
1256: cursor csr_er_credit_rbr is
1257: select distinct 'ER Tax Credits' classification_name ,'FUTA CREDIT' balance_name ,
1258: pet.element_name element_name, prb.jurisdiction_code jurisdiction_code
1259: from pay_element_types_f pet,
1260: pay_run_balances prb
1261: where l_effective_date between pet.effective_start_date and pet.effective_end_date
1262: and pet.element_name ='FUTA CREDIT'
1263: and prb.defined_balance_id = p_futa_def_bal_id
1264: AND prb.assignment_action_id = l_assignment_action_id;
1447: pet.element_name element_name
1448: from pay_balance_types pbt,
1449: pay_element_types_f pet,
1450: pay_element_classifications pec,
1451: pay_run_balances prb,
1452: pay_defined_balances pdb,
1453: pay_balance_dimensions pbd
1454: where pec.classification_name ='Employer Liabilities'
1455: and pec.legislation_code ='US'
2078: pay_assignment_actions paa,
2079: per_all_assignments_f paf,
2080: pay_us_emp_fed_tax_rules_F pftr,
2081: pay_us_states pst,
2082: pay_run_balances prb,
2083: pay_balance_dimensions pbd,
2084: pay_defined_balances pdb
2085: where pec.classification_name ='Employer Taxes'
2086: and pec.legislation_code ='US'