APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_STATES

Line 1783: l_state_code pay_us_states.state_code%type;

1779: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1780: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1781: l_arch_gre_step number := 0;
1782:
1783: l_state_code pay_us_states.state_code%type;
1784:
1785: l_from number;
1786: l_to number;
1787: l_length number;

Line 1829: from pay_us_states

1825: l_length := l_to - l_from - 1 ;
1826:
1827: Select state_code
1828: into l_state_code
1829: from pay_us_states
1830: where state_abbrev = (
1831: select substr(legislative_parameters,l_from, l_length )
1832: from pay_payroll_actions
1833: where payroll_action_id = p_payroll_action_id);

Line 2027: -- pay_us_states pus ,

2023: -- SELECT DISTINCT aei_information3 ,
2024: -- paf1.assignment_id
2025: -- FROM per_assignment_extra_info paei,
2026: -- pay_us_asg_reporting puar,
2027: -- pay_us_states pus ,
2028: -- per_assignments_f paf1,
2029: -- per_assignments_f paf
2030: -- WHERE paf.assignment_id = asgid
2031: -- AND date_earned BETWEEN paf.effective_start_date

Line 2077: -- pay_us_states pus ,

2073: -- SELECT DISTINCT aei_information3 ,
2074: -- paf1.assignment_id
2075: -- FROM per_assignment_extra_info paei,
2076: -- pay_us_asg_reporting puar,
2077: -- pay_us_states pus ,
2078: -- per_assignments_f paf1,
2079: -- per_assignments_f paf
2080: -- WHERE paf.assignment_id = asgid
2081: -- AND date_earned BETWEEN paf.effective_start_date

Line 2339: pay_us_states pus

2335: l_ar_state_abbrev IN VARCHAR2)
2336: IS
2337: SELECT pus.state_abbrev
2338: FROM pay_us_emp_fed_tax_rules_f pef,
2339: pay_us_states pus
2340: WHERE pef.sui_state_code = pus.state_code
2341: AND pus.state_abbrev <> l_ar_state_abbrev
2342: AND pef.effective_start_date <= l_eff_end_date
2343: AND pef.effective_end_date >= l_eff_start_date

Line 2367: pay_us_states pus

2363: l_ar_state_abbrev IN VARCHAR2)
2364: IS
2365: SELECT pus.state_abbrev
2366: FROM pay_us_emp_state_tax_rules_f pes,
2367: pay_us_states pus
2368: WHERE pes.state_code = pus.state_code
2369: AND pus.state_abbrev <> l_ar_state_abbrev
2370: AND pes.effective_start_date <= l_eff_end_date
2371: AND pes.effective_end_date >= l_eff_start_date

Line 2607: pay_us_states pus

2603: SELECT LEAST(MAX(pef.effective_end_date), p_effective_date)
2604: INTO l_effective_date
2605: FROM per_all_assignments_f paa,
2606: pay_us_emp_fed_tax_rules_f pef,
2607: pay_us_states pus
2608: WHERE paa.assignment_id = pef.assignment_id
2609: AND paa.assignment_id = asgid
2610: AND paa.assignment_type = 'E'
2611: AND pef.sui_state_code = pus.state_code