DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on HR_SOFT_CODING_KEYFLEX

Line 566: hr_soft_coding_keyflex hsck,

562: p_year_start_date DATE,
563: p_quarter_end_date DATE) IS
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

Line 585: hr_soft_coding_keyflex hsck,

581: p_year_start_date DATE,
582: p_quarter_end_date DATE) IS
583: select distinct substr(peev.screen_entry_value,1,2),pus.state_abbrev
584: from per_all_assignments_f paaf,
585: hr_soft_coding_keyflex hsck,
586: pay_element_entries_f pee,
587: pay_element_entry_values_f peev,
588: pay_input_values_f piv1,
589: pay_input_values_f piv2,

Line 624: hr_soft_coding_keyflex hsck,

620: minus
621:
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