APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATES

Line 700: ,pay_us_states st

696: cursor csr_sd_name(p_state_code varchar2, p_sd_code varchar2)
697: is
698: select STATE_ABBREV||'-'||SCHOOL_DST_NAME
699: from pay_us_school_dsts DS
700: ,pay_us_states st
701: where DS.STATE_CODE = p_state_code
702: and DS.SCHOOL_DST_CODE = p_sd_code
703: and ST.state_code = DS.state_code;
704: BEGIN

Line 2081: pay_us_states pst,

2077: pay_element_classifications pec,
2078: pay_assignment_actions paa,
2079: per_all_assignments_f paf,
2080: pay_us_emp_fed_tax_rules_F pftr,
2081: pay_us_states pst,
2082: pay_run_balances prb,
2083: pay_balance_dimensions pbd,
2084: pay_defined_balances pdb
2085: where pec.classification_name ='Employer Taxes'

Line 2128: pay_us_states pst,

2124: pay_element_classifications pec,
2125: pay_assignment_actions paa,
2126: per_all_assignments_f paf,
2127: pay_us_emp_fed_tax_rules_F pftr,
2128: pay_us_states pst,
2129: pay_run_results prr
2130: where pec.classification_name ='Employer Taxes'
2131: and pec.legislation_code ='US'
2132: and pet.classification_id = pec.classification_id

Line 2176: pay_us_states pst,'

2172: pay_element_classifications pec,
2173: pay_assignment_actions paa,
2174: per_all_assignments_f paf,
2175: pay_us_emp_fed_tax_rules_F pftr,
2176: pay_us_states pst,'
2177: ||l_wc_er_liab_from||
2178: ' where pec.classification_name ='||'''Employer Taxes'''
2179: ||' and pec.legislation_code ='||'''US'''
2180: ||' and pet.classification_id = pec.classification_id