DBA Data[Home] [Help]

APPS.PAY_YREND_REPORTS_PKG dependencies on PAY_US_STATES

Line 229: l_state_code pay_us_states.state_code%type;

225: CURSOR c_state_context (p_context_name varchar2) is
226: select context_id from ff_contexts
227: where context_name = p_context_name;
228:
229: l_state_code pay_us_states.state_code%type;
230: l_locality_code varchar2(20);
231:
232: TYPE RefCurType is REF CURSOR;
233: c_actions_with_state RefCurType;

Line 599: l_state_code pay_us_states.state_code%type;

595: l_org_id per_assignments_f.organization_id%type;
596: l_loc_id per_assignments_f.location_id%type;
597: l_per_id per_assignments_f.person_id%type;
598: l_ssn per_people_f.national_identifier%type;
599: l_state_code pay_us_states.state_code%type;
600: l_sort1 varchar2(60);
601: l_sort2 varchar2(60);
602: l_sort3 varchar2(60);
603: l_year_start date;