DBA Data[Home] [Help]

APPS.PAY_YREND_REPORTS_PKG dependencies on PAY_US_STATES

Line 200: l_state_code pay_us_states.state_code%type;

196: CURSOR c_state_context (p_context_name varchar2) is
197: select context_id from ff_contexts
198: where context_name = p_context_name;
199:
200: l_state_code pay_us_states.state_code%type;
201: l_locality_code varchar2(20);
202:
203: TYPE RefCurType is REF CURSOR;
204: c_actions_with_state RefCurType;

Line 561: l_state_code pay_us_states.state_code%type;

557: l_org_id per_assignments_f.organization_id%type;
558: l_loc_id per_assignments_f.location_id%type;
559: l_per_id per_assignments_f.person_id%type;
560: l_ssn per_people_f.national_identifier%type;
561: l_state_code pay_us_states.state_code%type;
562: l_sort1 varchar2(60);
563: l_sort2 varchar2(60);
564: l_sort3 varchar2(60);
565: l_year_start date;