APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on HR_ORGANIZATION_UNITS

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

1336: return l_tax_unit_id;
1337: END IF;
1338: END;
1339:
1340: function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
1341: return VARCHAR2 IS
1342: CURSOR c_tax_unit_name is
1343: select HOU_GRE.NAME
1344: from HR_ORGANIZATION_UNITS HOU_GRE

Line 1344: from HR_ORGANIZATION_UNITS HOU_GRE

1340: function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
1341: return VARCHAR2 IS
1342: CURSOR c_tax_unit_name is
1343: select HOU_GRE.NAME
1344: from HR_ORGANIZATION_UNITS HOU_GRE
1345: where HOU_GRE.ORGANIZATION_ID = p_tax_unit_id;
1346: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;
1347: BEGIN
1348: IF p_tax_unit_id IS NULL THEN

Line 1346: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;

1342: CURSOR c_tax_unit_name is
1343: select HOU_GRE.NAME
1344: from HR_ORGANIZATION_UNITS HOU_GRE
1345: where HOU_GRE.ORGANIZATION_ID = p_tax_unit_id;
1346: L_TAX_UNIT_NAME hr_organization_units.NAME%TYPE;
1347: BEGIN
1348: IF p_tax_unit_id IS NULL THEN
1349: return NULL;
1350: END IF;