APPS.PAY_US_SQWL_UDF dependencies on PAY_US_STATES

Line 568: pay_us_states pus

564: select distinct pest.state_code,pus.state_abbrev
565: from per_all_assignments_f paaf,
566: hr_soft_coding_keyflex hsck,
567: pay_us_emp_state_tax_rules_f pest,
568: pay_us_states pus
569: where paaf.person_id = p_person_id
570: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
571: and paaf.effective_end_date >= p_year_start_date
572: and paaf.effective_start_date <= p_quarter_end_date

Line 593: pay_us_states pus

589: pay_input_values_f piv2,
590: pay_balance_types pbt,
591: pay_balance_feeds_f pbf,
592: pay_element_links_f pel,
593: pay_us_states pus
594: where paaf.person_id=p_person_id
595: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
596: and paaf.effective_end_date >= p_year_start_date
597: and paaf.effective_start_date <= p_quarter_end_date

Line 626: pay_us_states pus

622: select distinct pest.state_code,pus.state_abbrev
623: from per_all_assignments_f paaf,
624: hr_soft_coding_keyflex hsck,
625: pay_us_emp_state_tax_rules_f pest,
626: pay_us_states pus
627: where paaf.person_id = p_person_id
628: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
629: and paaf.effective_end_date >= p_year_start_date
630: and paaf.effective_start_date <= p_quarter_end_date

Line 651: l_state_code pay_us_states.state_code%TYPE;

647: and pdb.balance_type_id = pbt.balance_type_id
648: and pdb.balance_dimension_id = pbd.balance_dimension_id;
649:
650: l_person_id per_all_people_f.person_id%TYPE;
651: l_state_code pay_us_states.state_code%TYPE;
652: l_state_abbrev pay_us_states.state_abbrev%TYPE;
653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;
654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
655: l_year_start_date DATE;

Line 652: l_state_abbrev pay_us_states.state_abbrev%TYPE;

648: and pdb.balance_dimension_id = pbd.balance_dimension_id;
649:
650: l_person_id per_all_people_f.person_id%TYPE;
651: l_state_code pay_us_states.state_code%TYPE;
652: l_state_abbrev pay_us_states.state_abbrev%TYPE;
653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;
654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
655: l_year_start_date DATE;
656: l_quarter_start_date DATE;

Line 653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;

649:
650: l_person_id per_all_people_f.person_id%TYPE;
651: l_state_code pay_us_states.state_code%TYPE;
652: l_state_abbrev pay_us_states.state_abbrev%TYPE;
653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;
654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
655: l_year_start_date DATE;
656: l_quarter_start_date DATE;
657: l_quarter_end_date DATE;