DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_US_STATES

Line 789: FROM pay_us_states

785: *************************************************************/
786:
787: Cursor c_selected_state
788: IS SELECT state_abbrev
789: FROM pay_us_states
790: where state_code = p_state_code;
791:
792:
793: /*************************************************************

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

843: lvc_national_identifier VARCHAR2(100);
844: lvc_employee_number VARCHAR2(100);
845: lvn_person_id NUMBER;
846: lvc_gre_name hr_organization_units.name%type;
847: lvc_state_abbrev pay_us_states.state_abbrev%type := null;
848: lvc_jurisdiction varchar2(11) := '00-000-0000';
849: lvn_tax_unit_id number := -1;
850: lvc_tax_unit_id varchar2(15);
851: lvc_date_time varchar2(50);