APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_US_STATES

Line 1684: l_state_code pay_us_states.state_code%type;

1680: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1681: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1682: l_arch_gre_step number := 0;
1683:
1684: l_state_code pay_us_states.state_code%type;
1685:
1686: l_from number;
1687: l_to number;
1688: l_length number;

Line 1730: from pay_us_states

1726: l_length := l_to - l_from - 1 ;
1727:
1728: Select state_code
1729: into l_state_code
1730: from pay_us_states
1731: where state_abbrev = (
1732: select substr(legislative_parameters,l_from, l_length )
1733: from pay_payroll_actions
1734: where payroll_action_id = p_payroll_action_id);

Line 1929: -- pay_us_states pus ,

1925: -- SELECT DISTINCT aei_information3 ,
1926: -- paf1.assignment_id
1927: -- FROM per_assignment_extra_info paei,
1928: -- pay_us_asg_reporting puar,
1929: -- pay_us_states pus ,
1930: -- per_assignments_f paf1,
1931: -- per_assignments_f paf
1932: -- WHERE paf.assignment_id = asgid
1933: -- AND date_earned BETWEEN paf.effective_start_date

Line 1979: -- pay_us_states pus ,

1975: -- SELECT DISTINCT aei_information3 ,
1976: -- paf1.assignment_id
1977: -- FROM per_assignment_extra_info paei,
1978: -- pay_us_asg_reporting puar,
1979: -- pay_us_states pus ,
1980: -- per_assignments_f paf1,
1981: -- per_assignments_f paf
1982: -- WHERE paf.assignment_id = asgid
1983: -- AND date_earned BETWEEN paf.effective_start_date