APPS.PA_AP_INTEGRATION dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 628: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */

624: End Get_si_cost_exp_item_date ;
625:
626:
627: FUNCTION Get_si_default_exp_org RETURN varchar2 is
628: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
629: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
630: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
631:
632: /* Bug 5555041 - Start */

Line 629: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */

625:
626:
627: FUNCTION Get_si_default_exp_org RETURN varchar2 is
628: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
629: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
630: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
631:
632: /* Bug 5555041 - Start */
633: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS

Line 630: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */

626:
627: FUNCTION Get_si_default_exp_org RETURN varchar2 is
628: l_default_exp_org HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 5555041 */
629: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
630: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
631:
632: /* Bug 5555041 - Start */
633: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
634: SELECT organization_id

Line 633: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS

629: l_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE; /* Bug 5555041 */
630: l_default_exp_org1 HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE; /* Bug 7575377 */
631:
632: /* Bug 5555041 - Start */
633: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
634: SELECT organization_id
635: FROM hr_all_organization_units_tl
636: WHERE name = p_org_name;
637:

Line 635: FROM hr_all_organization_units_tl

631:
632: /* Bug 5555041 - Start */
633: CURSOR c_get_org_id(p_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE) IS
634: SELECT organization_id
635: FROM hr_all_organization_units_tl
636: WHERE name = p_org_name;
637:
638: CURSOR c_get_org_name(p_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
639: SELECT name

Line 638: CURSOR c_get_org_name(p_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

634: SELECT organization_id
635: FROM hr_all_organization_units_tl
636: WHERE name = p_org_name;
637:
638: CURSOR c_get_org_name(p_organization_id HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
639: SELECT name
640: FROM per_organization_units
641: WHERE organization_id = p_organization_id;
642: /* Bug 5555041 - End */