APPS.PAY_LIVEARCHIVE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 812: FROM hr_organization_units

808: *************************************************************/
809:
810: CURSOR c_gre_name
811: IS SELECT name
812: FROM hr_organization_units
813: WHERE organization_id = p_tax_unit_id;
814:
815: /*************************************************************
816: Cursor to get Employee Number

Line 846: lvc_gre_name hr_organization_units.name%type;

842: lvc_label1 VARCHAR2(32000);
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);