APPS.PAY_US_WEB_W4 dependencies on PAY_STAT_TRANS_AUDIT

Line 47: 02-MAR-2001 meshah 115.9 now inserting source3 in pay_stat_trans_audit

43: report is run it uses the real GRE value
44: at that date, not the current one.
45: 19-FEB-2001 meshah 115.8 Changed update_tax_records to insert one
46: record for Federal and State each.
47: 02-MAR-2001 meshah 115.9 now inserting source3 in pay_stat_trans_audit
48: and attribute_category = W4 State for state
49: records.
50: 05-MAR-2001 meshah 115.10 Bug 1668926 is fixed now. We need to check the
51: filing status and exemptions between federal and

Line 55: in the pay_stat_trans_audit table.

51: filing status and exemptions between federal and
52: state records before updating state information.
53: Now inserting source3 for federal also.
54: 15-MAR-2001 meshah 115.11 Now truncating transaction_date before inserting
55: in the pay_stat_trans_audit table.
56: 27-APR-2001 meshah 115.12 Made changes to the package so that the same
57: package works with the new techstack.
58: 1. Added procedure check_update_status.
59: 2. Removed the checking from the cursors to get

Line 1746: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

1742: ******************************************************************/
1743: IS
1744: ln_person_id per_people_f.person_id%TYPE;
1745: ln_business_group_id per_people_f.business_group_id%TYPE;
1746: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1747: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1748: ln_gre_id hr_organization_units.organization_id%TYPE;
1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1750: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 1765: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;
1763: lv_state_code pay_us_states.state_code%TYPE;
1764: lv_state_default_code VARCHAR2(30);
1765: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1766: ln_dummy NUMBER(15);
1767: lb_comma_flag boolean := false;
1768: lv_datetrack_mode VARCHAR2(30);
1769: lv_update_method VARCHAR2(30);

Line 1864: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

1860: ******************************************************************/
1861: IS
1862: ln_person_id per_people_f.person_id%TYPE;
1863: ln_business_group_id per_people_f.business_group_id%TYPE;
1864: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1865: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1866: ln_gre_id hr_organization_units.organization_id%TYPE;
1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1868: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 1884: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

1880: lv_state_name pay_us_states.state_name%TYPE;
1881: lv_state_code pay_us_states.state_code%TYPE;
1882: lv_state_default_code VARCHAR2(30);
1883: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;
1884: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1885: ln_dummy NUMBER(15);
1886: lb_comma_flag boolean := false;
1887: lv_datetrack_mode VARCHAR2(30);
1888: lv_update_method VARCHAR2(30) := 'PRIMARY';