694: End Get_si_cost_exp_item_date ;
695:
696:
697: FUNCTION Get_si_default_exp_org RETURN varchar2 is
698: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
699: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
700: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
701:
702: /* Bug 5555041 - Start */
695:
696:
697: FUNCTION Get_si_default_exp_org RETURN varchar2 is
698: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
699: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
700: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
701:
702: /* Bug 5555041 - Start */
703: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
696:
697: FUNCTION Get_si_default_exp_org RETURN varchar2 is
698: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
699: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
700: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
701:
702: /* Bug 5555041 - Start */
703: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
704: SELECT organization_id
699: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
700: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
701:
702: /* Bug 5555041 - Start */
703: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
704: SELECT organization_id
705: FROM hr_all_organization_units_tl
706: WHERE name = p_org_name;
707:
701:
702: /* Bug 5555041 - Start */
703: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
704: SELECT organization_id
705: FROM hr_all_organization_units_tl
706: WHERE name = p_org_name;
707:
708: CURSOR c_get_org_name(p_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
709: SELECT name
704: SELECT organization_id
705: FROM hr_all_organization_units_tl
706: WHERE name = p_org_name;
707:
708: CURSOR c_get_org_name(p_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
709: SELECT name
710: FROM per_organization_units
711: WHERE organization_id = p_organization_id;
712: /* Bug 5555041 - End */