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 255: FROM hr_organization_units

251: WHERE user_entity_id = p_user_entity_id;
252:
253: CURSOR c_gre_name(c_tax_unit_id VARCHAR2) is
254: SELECT NAME
255: FROM hr_organization_units
256: where organization_id = to_number(c_tax_unit_id);
257:
258: CURSOR c_per_name(c_person_id VARCHAR2) is
259: SELECT FULL_NAME