APPS.PAYUSUNB_PKG dependencies on PAY_US_STATES

Line 747: FUNCTION fnc_get_tax_limit_rate(IN_state_code IN pay_us_states.state_code%TYPE,

743: parameters:
744: return:
745: specs:
746: **************************************************************************/
747: FUNCTION fnc_get_tax_limit_rate(IN_state_code IN pay_us_states.state_code%TYPE,
748: IN_start_date IN DATE,
749: IN_as_of_date IN DATE,
750: IN_tax_type IN VARCHAR2,
751: IN_ee_or_er IN VARCHAR2,

Line 900: FROM pay_us_states

896: AND org_information_context = 'State Tax Rules';
897:
898: CURSOR c_get_state_code (IN_sui_state_code IN VARCHAR2) Is
899: SELECT state_abbrev
900: FROM pay_us_states
901: WHERE state_code = IN_sui_state_code;
902:
903: l_flag VARCHAR2(2) := 'F' ;
904: l_count NUMBER := 0;

Line 970: FROM hr_organization_information org, pay_us_states pus

966: L_return_val NUMBER;
967:
968: CURSOR c_get_sui_sdi_overide_rt (IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
969: SELECT pus.state_code,org_information6/100, org_information7/100 , org_information14/100
970: FROM hr_organization_information org, pay_us_states pus
971: WHERE org.org_information1 = pus.state_abbrev
972: AND pus.state_code between 00 and 99
973: AND org.organization_id = IN_tax_unit_id
974: AND org.org_information_context = 'State Tax Rules';

Line 1191: FUNCTION fnc_sit_exists(IN_state_code IN pay_us_states.state_code%TYPE,

1187: IN_as_of_date -
1188: return: TRUE/FALSE
1189: specs:
1190: **************************************************************************/
1191: FUNCTION fnc_sit_exists(IN_state_code IN pay_us_states.state_code%TYPE,
1192: IN_as_of_date IN DATE) RETURN BOOLEAN IS
1193:
1194: /********************* 3005756 START ************************************/
1195:

Line 1375: pay_us_states pus

1371: pus.state_code state_code,
1372: pus.state_abbrev
1373: FROM pay_run_balances prb,
1374: per_assignments_f paf,
1375: pay_us_states pus
1376: WHERE paf.person_id = IN_person_id
1377: AND prb.effective_date BETWEEN IN_start_date and IN_as_of_date
1378: AND prb.effective_date BETWEEN paf.effective_start_date
1379: AND paf.effective_end_date

Line 1396: pay_us_states pus,

1392: prb.jurisdiction_code||'-0000' jurisdiction_code,
1393: puc.county_name||','||pus.state_abbrev jurisdiction_name
1394: FROM pay_run_balances prb,
1395: per_assignments_f paf,
1396: pay_us_states pus,
1397: pay_us_counties puc
1398: WHERE paf.person_id = IN_person_id
1399: AND paf.effective_start_date <= IN_as_of_date
1400: AND paf.effective_end_date >= IN_start_date

Line 1422: pay_us_states pus,

1418: prb.jurisdiction_code,
1419: pun.city_name||','||pus.state_abbrev jurisdiction_name
1420: FROM pay_run_balances prb,
1421: per_assignments_f paf,
1422: pay_us_states pus,
1423: pay_us_city_names pun
1424: WHERE paf.person_id = IN_person_id
1425: AND paf.effective_start_date <= IN_as_of_date
1426: AND paf.effective_end_date >= IN_start_date

Line 1454: pay_us_states pus,

1450: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1451: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1452: FROM pay_run_balances prb,
1453: per_assignments_f paf,
1454: pay_us_states pus,
1455: pay_us_city_school_dsts psd
1456: WHERE paf.person_id = IN_person_id
1457: AND paf.effective_start_date <= IN_as_of_date
1458: AND paf.effective_end_date >= IN_start_date

Line 1477: pay_us_states pus,

1473: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1474: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1475: FROM per_assignments_f paf,
1476: pay_run_balances prb,
1477: pay_us_states pus,
1478: pay_us_county_school_dsts psd
1479: WHERE paf.person_id = IN_person_id
1480: AND paf.effective_start_date <= IN_as_of_date
1481: AND paf.effective_end_date >= IN_start_date

Line 1509: pay_us_states pus

1505: pes.state_code,
1506: pus.state_abbrev
1507: FROM pay_us_emp_state_tax_rules_f pes,
1508: per_assignments_f paf,
1509: pay_us_states pus
1510: WHERE pes.assignment_id = paf.assignment_id
1511: AND pes.state_code = pus.state_code
1512: AND paf.effective_start_date BETWEEN pes.effective_start_date
1513: AND pes.effective_end_date

Line 1551: pay_us_states pus,

1547: SELECT DISTINCT pes.jurisdiction_code,
1548: puc.county_name||','||pus.state_abbrev jurisdiction_name
1549: FROM pay_us_emp_county_tax_rules_f pes,
1550: per_assignments_f paf,
1551: pay_us_states pus,
1552: pay_us_counties puc
1553: WHERE pes.assignment_id = paf.assignment_id
1554: AND pes.state_code = pus.state_code
1555: AND pes.county_code = puc.county_code

Line 1596: pay_us_states pus,

1592: pes.jurisdiction_code,
1593: pun.city_name||','||pus.state_abbrev jurisdiction_name
1594: FROM pay_us_emp_city_tax_rules_f pes,
1595: per_assignments_f paf,
1596: pay_us_states pus,
1597: pay_us_city_names pun
1598: WHERE pes.assignment_id = paf.assignment_id
1599: AND pes.state_code = pus.state_code
1600: AND pes.state_code = pun.state_code

Line 1645: pay_us_states pus,

1641: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1642: pes.jurisdiction_code reg_jurisdiction_cd
1643: FROM pay_us_emp_city_tax_rules_f pes,
1644: per_assignments_f paf,
1645: pay_us_states pus,
1646: pay_us_city_school_dsts psd
1647: WHERE pes.assignment_id = paf.assignment_id
1648: AND pes.school_district_code IS NOT NULL
1649: AND pes.state_code = pus.state_code

Line 1688: pay_us_states pus,

1684: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1685: pes.jurisdiction_code reg_jurisdiction_cd
1686: FROM pay_us_emp_county_tax_rules_f pes,
1687: per_assignments_f paf,
1688: pay_us_states pus,
1689: pay_us_county_school_dsts psd
1690: WHERE pes.assignment_id = paf.assignment_id
1691: AND pes.school_district_code IS NOT NULL
1692: AND pes.state_code = pus.state_code