[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
1428: --nvl(pet.reporting_name, pet.element_name) element_name,
1429: pet.element_name element_name, /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
1430: prb.jurisdiction_code jurisdiction_code
1431: from pay_element_types_f pet,
1432: pay_run_balances prb
1433: where l_effective_date between pet.effective_start_date and pet.effective_end_date
1434: and pet.element_name ='FUTA CREDIT'
1435: and prb.defined_balance_id = p_futa_def_bal_id
1436: AND prb.assignment_action_id = l_assignment_action_id;
1624: pet.element_name element_name /* Bug 14406013: Reverting back changes done as part of Bug 5918981 */
1625: from pay_balance_types pbt,
1626: pay_element_types_f pet,
1627: pay_element_classifications pec,
1628: pay_run_balances prb,
1629: pay_defined_balances pdb,
1630: pay_balance_dimensions pbd
1631: where pec.classification_name ='Employer Liabilities'
1632: and pec.legislation_code ='US'
2259: pay_assignment_actions paa,
2260: per_all_assignments_f paf,
2261: pay_us_emp_fed_tax_rules_F pftr,
2262: pay_us_states pst,
2263: pay_run_balances prb,
2264: pay_balance_dimensions pbd,
2265: pay_defined_balances pdb
2266: where pec.classification_name ='Employer Taxes'
2267: and pec.legislation_code ='US'