APPS.PAY_PAYUSRRS_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS
Line 29: from hr_organization_units
25:
26: if p_tax_unit_id IS NOT NULL then
27:
28: Select name into cp_gre_name 29: from hr_organization_units 30: where organization_id = p_tax_unit_id;
31: end if;
32:
33: if p_person_id IS NOT NULL then
Line 100: FROM hr_organization_units
96: FUNCTION GET_BUSINESS_GROUP_NAME(fp_business_group_id IN NUMBER) RETURN VARCHAR2 IS
97:
98: CURSOR bg_cur IS
99: SELECT name 100: FROM hr_organization_units 101: WHERE organization_id = fp_business_group_id;
102: bgc bg_cur%ROWTYPE;
103:
104: BEGIN