APPS.PAY_LIVEARCHIVE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 901: FROM hr_organization_units

897: *************************************************************/
898:
899: CURSOR c_gre_name
900: IS SELECT name
901: FROM hr_organization_units
902: WHERE organization_id = p_tax_unit_id;
903:
904: /*************************************************************
905: Cursor to get Employee Number

Line 935: lvc_gre_name hr_organization_units.name%type;

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