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 1605: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

1601: ******************************************************************/
1602: IS
1603: ln_person_id per_people_f.person_id%TYPE;
1604: ln_business_group_id per_people_f.business_group_id%TYPE;
1605: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1606: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1607: ln_gre_id hr_organization_units.organization_id%TYPE;
1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1609: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 1624: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;
1622: lv_state_code pay_us_states.state_code%TYPE;
1623: lv_state_default_code VARCHAR2(30);
1624: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1625: ln_dummy NUMBER(15);
1626: lb_comma_flag boolean := false;
1627: lv_datetrack_mode VARCHAR2(30);
1628: lv_update_method VARCHAR2(30);

Line 1723: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

1719: ******************************************************************/
1720: IS
1721: ln_person_id per_people_f.person_id%TYPE;
1722: ln_business_group_id per_people_f.business_group_id%TYPE;
1723: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1724: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1725: ln_gre_id hr_organization_units.organization_id%TYPE;
1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1727: ln_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 1743: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

1739: lv_state_name pay_us_states.state_name%TYPE;
1740: lv_state_code pay_us_states.state_code%TYPE;
1741: lv_state_default_code VARCHAR2(30);
1742: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;
1743: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1744: ln_dummy NUMBER(15);
1745: lb_comma_flag boolean := false;
1746: lv_datetrack_mode VARCHAR2(30);
1747: lv_update_method VARCHAR2(30) := 'PRIMARY';