APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATES

Line 616: ls_state_name pay_us_states.state_name%TYPE := NULL;

612: end load_alien_earnings;
613:
614: FUNCTION get_state_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
615: RETURN VARCHAR2 IS
616: ls_state_name pay_us_states.state_name%TYPE := NULL;
617: BEGIN
618: hr_utility.trace('GET_STATE_NAME called');
619: hr_utility.trace('p_tax_type_code : ' || p_tax_type_code || ' p_jurisdiction_code : ' || p_jurisdiction_code);
620: SELECT state_abbrev INTO ls_state_name

Line 621: FROM pay_us_states

617: BEGIN
618: hr_utility.trace('GET_STATE_NAME called');
619: hr_utility.trace('p_tax_type_code : ' || p_tax_type_code || ' p_jurisdiction_code : ' || p_jurisdiction_code);
620: SELECT state_abbrev INTO ls_state_name
621: FROM pay_us_states
622: WHERE state_code = substr(p_jurisdiction_code,1,2);
623:
624: hr_utility.trace('GET_STATE_NAME returns ' || ls_state_name);
625: RETURN ls_state_name;

Line 834: ,pay_us_states st

830: cursor csr_sd_name(p_state_code varchar2, p_sd_code varchar2)
831: is
832: select STATE_ABBREV||'-'||SCHOOL_DST_NAME
833: from pay_us_school_dsts DS
834: ,pay_us_states st
835: where DS.STATE_CODE = p_state_code
836: and DS.SCHOOL_DST_CODE = p_sd_code
837: and ST.state_code = DS.state_code;
838: BEGIN

Line 2262: pay_us_states pst,

2258: pay_element_classifications pec,
2259: pay_assignment_actions paa,
2260: per_all_assignments_f paf,
2261: pay_us_emp_fed_tax_rules_F pftr,
2262: pay_us_states pst,
2263: pay_run_balances prb,
2264: pay_balance_dimensions pbd,
2265: pay_defined_balances pdb
2266: where pec.classification_name ='Employer Taxes'

Line 2311: pay_us_states pst,

2307: pay_element_classifications pec,
2308: pay_assignment_actions paa,
2309: per_all_assignments_f paf,
2310: pay_us_emp_fed_tax_rules_F pftr,
2311: pay_us_states pst,
2312: pay_run_results prr
2313: where pec.classification_name ='Employer Taxes'
2314: and pec.legislation_code ='US'
2315: and pet.classification_id = pec.classification_id

Line 2359: pay_us_states pst,'

2355: pay_element_classifications pec,
2356: pay_assignment_actions paa,
2357: per_all_assignments_f paf,
2358: pay_us_emp_fed_tax_rules_F pftr,
2359: pay_us_states pst,'
2360: ||l_wc_er_liab_from||
2361: ' where pec.classification_name ='||'''Employer Taxes'''
2362: ||' and pec.legislation_code ='||'''US'''
2363: ||' and pet.classification_id = pec.classification_id