DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_US_STATES

Line 878: FROM pay_us_states

874: *************************************************************/
875:
876: Cursor c_selected_state
877: IS SELECT state_abbrev
878: FROM pay_us_states
879: where state_code = p_state_code;
880:
881:
882: /*************************************************************

Line 936: lvc_state_abbrev pay_us_states.state_abbrev%type := null;

932: lvc_national_identifier VARCHAR2(100);
933: lvc_employee_number VARCHAR2(100);
934: lvn_person_id NUMBER;
935: lvc_gre_name hr_organization_units.name%type;
936: lvc_state_abbrev pay_us_states.state_abbrev%type := null;
937: lvc_jurisdiction varchar2(11) := '00-000-0000';
938: lvn_tax_unit_id number := -1;
939: lvc_tax_unit_id varchar2(15);
940: lvc_date_time varchar2(50);