APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1405: function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)

1401: return l_tax_unit_id;
1402: END IF;
1403: END;
1404:
1405: function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
1406: return VARCHAR2 IS
1407: CURSOR c_tax_unit_name is
1408: select HOU_GRE.NAME
1409: from HR_ORGANIZATION_UNITS HOU_GRE

Line 1409: from HR_ORGANIZATION_UNITS HOU_GRE

1405: function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
1406: return VARCHAR2 IS
1407: CURSOR c_tax_unit_name is
1408: select HOU_GRE.NAME
1409: from HR_ORGANIZATION_UNITS HOU_GRE
1410: where HOU_GRE.ORGANIZATION_ID = p_tax_unit_id;
1411: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;
1412: BEGIN
1413: IF p_tax_unit_id IS NULL THEN

Line 1411: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;

1407: CURSOR c_tax_unit_name is
1408: select HOU_GRE.NAME
1409: from HR_ORGANIZATION_UNITS HOU_GRE
1410: where HOU_GRE.ORGANIZATION_ID = p_tax_unit_id;
1411: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;
1412: BEGIN
1413: IF p_tax_unit_id IS NULL THEN
1414: return NULL;
1415: END IF;