DBA Data[Home] [Help]

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