APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_US_STATES

Line 842: select state_code from pay_us_states

838: and to_date('2004/12/31', 'yyyy/mm/dd')
839: order by paa.action_sequence desc;
840:
841: cursor c_get_state_code(cp_state_abbrev varchar2) is
842: select state_code from pay_us_states
843: where state_Abbrev = cp_state_abbrev;
844:
845:
846: ld_adj_end_date DATE;

Line 1256: select state_code from pay_us_states

1252: lv_procedure_name VARCHAR2(100);
1253: ln_step NUMBER;
1254:
1255: cursor c_get_state_code(cp_state_abbrev varchar2) is
1256: select state_code from pay_us_states
1257: where state_Abbrev = cp_state_abbrev;
1258:
1259: cursor c_get_chunk_date(cp_payroll_action_id in number) is
1260: select min(paa.chunk_number)