APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_UNITS

Line 1400: ,hr_organization_units hou

1396:
1397: CURSOR chk_unique_challan IS
1398: SELECT 'X'
1399: FROM hr_organization_information hoi
1400: ,hr_organization_units hou
1401: WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1402: AND hoi.org_information3 = p_org_information3
1403: AND hou.organization_id = hoi.organization_id
1404: AND hou.business_group_id = (SELECT business_group_id

Line 1405: FROM hr_organization_units org

1401: WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1402: AND hoi.org_information3 = p_org_information3
1403: AND hou.organization_id = hoi.organization_id
1404: AND hou.business_group_id = (SELECT business_group_id
1405: FROM hr_organization_units org
1406: WHERE org.organization_id = p_organization_id);
1407:
1408:
1409:

Line 1686: ,hr_organization_units hou

1682: CURSOR chk_unique_challan(p_challan_number VARCHAR2
1683: ,p_organization_id NUMBER) IS
1684: SELECT 'X'
1685: FROM hr_organization_information hoi
1686: ,hr_organization_units hou
1687: WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1688: AND hoi.org_information3 = p_challan_number
1689: AND hoi.org_information_id <> p_org_information_id
1690: AND hou.organization_id = hoi.organization_id

Line 1692: FROM hr_organization_units org

1688: AND hoi.org_information3 = p_challan_number
1689: AND hoi.org_information_id <> p_org_information_id
1690: AND hou.organization_id = hoi.organization_id
1691: AND hou.business_group_id = (SELECT business_group_id
1692: FROM hr_organization_units org
1693: WHERE org.organization_id = p_organization_id) ;
1694:
1695:
1696:

Line 2465: FROM hr_organization_units

2461: ,name
2462: ,date_from
2463: ,date_to
2464: ,location_id
2465: FROM hr_organization_units
2466: WHERE organization_id = p_organization_id;
2467:
2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;

Line 2468: l_organization_id hr_organization_units.organization_id%TYPE;

2464: ,location_id
2465: FROM hr_organization_units
2466: WHERE organization_id = p_organization_id;
2467:
2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;
2470: l_date_from hr_organization_units.date_from%TYPE;
2471: l_date_to hr_organization_units.date_to%TYPE;
2472: l_location_id hr_organization_units.location_id%TYPE;

Line 2469: l_name hr_organization_units.name%TYPE;

2465: FROM hr_organization_units
2466: WHERE organization_id = p_organization_id;
2467:
2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;
2470: l_date_from hr_organization_units.date_from%TYPE;
2471: l_date_to hr_organization_units.date_to%TYPE;
2472: l_location_id hr_organization_units.location_id%TYPE;
2473:

Line 2470: l_date_from hr_organization_units.date_from%TYPE;

2466: WHERE organization_id = p_organization_id;
2467:
2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;
2470: l_date_from hr_organization_units.date_from%TYPE;
2471: l_date_to hr_organization_units.date_to%TYPE;
2472: l_location_id hr_organization_units.location_id%TYPE;
2473:
2474: l_procedure VARCHAR2(100);

Line 2471: l_date_to hr_organization_units.date_to%TYPE;

2467:
2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;
2470: l_date_from hr_organization_units.date_from%TYPE;
2471: l_date_to hr_organization_units.date_to%TYPE;
2472: l_location_id hr_organization_units.location_id%TYPE;
2473:
2474: l_procedure VARCHAR2(100);
2475: l_message VARCHAR2(300);

Line 2472: l_location_id hr_organization_units.location_id%TYPE;

2468: l_organization_id hr_organization_units.organization_id%TYPE;
2469: l_name hr_organization_units.name%TYPE;
2470: l_date_from hr_organization_units.date_from%TYPE;
2471: l_date_to hr_organization_units.date_to%TYPE;
2472: l_location_id hr_organization_units.location_id%TYPE;
2473:
2474: l_procedure VARCHAR2(100);
2475: l_message VARCHAR2(300);
2476: