APPS.PAY_US_ER_REARCH dependencies on HR_ORGANIZATION_UNITS

Line 147: FROM hr_organization_units

143:
144:
145: CURSOR c_gre_name is
146: SELECT NAME
147: FROM hr_organization_units
148: where organization_id = p_tax_unit_id;
149:
150: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
151: l_eff_date Date;

Line 265: FROM hr_organization_units

261: WHERE user_entity_id = p_user_entity_id;
262:
263: CURSOR c_gre_name(c_tax_unit_id VARCHAR2) is
264: SELECT NAME
265: FROM hr_organization_units
266: where organization_id = to_number(c_tax_unit_id);
267:
268: CURSOR c_per_name(c_person_id VARCHAR2) is
269: SELECT FULL_NAME