eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_UNITS

Line 1416: FROM hr_organization_units hou

1412: AND p_org_information5 = bank.org_information_id ;
1413:
1414: CURSOR chk_unique_challan(p_bsr_code VARCHAR2) IS
1415: SELECT 'X'
1416: FROM hr_organization_units hou
1417: ,hr_organization_information hoi
1418: WHERE hoi.organization_id = hou.organization_id
1419: AND hou.business_group_id = (SELECT business_group_id
1420: FROM hr_organization_units org

Line 1420: FROM hr_organization_units org

1416: FROM hr_organization_units hou
1417: ,hr_organization_information hoi
1418: WHERE hoi.organization_id = hou.organization_id
1419: AND hou.business_group_id = (SELECT business_group_id
1420: FROM hr_organization_units org
1421: WHERE org.organization_id = p_organization_id)
1422: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1423: AND hoi.org_information3 = p_org_information3
1424: AND hoi.org_information2= p_org_information2

Line 1427: FROM hr_organization_units hou

1423: AND hoi.org_information3 = p_org_information3
1424: AND hoi.org_information2= p_org_information2
1425: and ((p_org_information5 is not null and
1426: p_bsr_code in (SELECT bank.org_information4
1427: FROM hr_organization_units hou
1428: ,hr_organization_information bank
1429: WHERE hoi.organization_id = hou.organization_id
1430: AND hou.business_group_id = (SELECT business_group_id
1431: FROM hr_organization_units org

Line 1431: FROM hr_organization_units org

1427: FROM hr_organization_units hou
1428: ,hr_organization_information bank
1429: WHERE hoi.organization_id = hou.organization_id
1430: AND hou.business_group_id = (SELECT business_group_id
1431: FROM hr_organization_units org
1432: WHERE org.organization_id = p_organization_id)
1433: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1434: AND bank.org_information_context = 'PER_IN_CHALLAN_BANK'
1435: AND bank.organization_id = hoi.organization_id

Line 1899: FROM hr_organization_units hou

1895: CURSOR chk_unique_challan(p_challan_number VARCHAR2
1896: ,p_organization_id NUMBER
1897: ,p_bsr_code VARCHAR2) IS
1898: SELECT 'X'
1899: FROM hr_organization_units hou
1900: ,hr_organization_information hoi
1901: WHERE hoi.organization_id = hou.organization_id
1902: AND hou.business_group_id = (SELECT business_group_id
1903: FROM hr_organization_units org

Line 1903: FROM hr_organization_units org

1899: FROM hr_organization_units hou
1900: ,hr_organization_information hoi
1901: WHERE hoi.organization_id = hou.organization_id
1902: AND hou.business_group_id = (SELECT business_group_id
1903: FROM hr_organization_units org
1904: WHERE org.organization_id = p_organization_id)
1905: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1906: and ((p_org_information5 is not null and
1907: p_bsr_code in (SELECT bank.org_information4

Line 1908: FROM hr_organization_units hou

1904: WHERE org.organization_id = p_organization_id)
1905: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1906: and ((p_org_information5 is not null and
1907: p_bsr_code in (SELECT bank.org_information4
1908: FROM hr_organization_units hou
1909: ,hr_organization_information bank
1910: WHERE hoi.organization_id = hou.organization_id
1911: AND hou.business_group_id = (SELECT business_group_id
1912: FROM hr_organization_units org

Line 1912: FROM hr_organization_units org

1908: FROM hr_organization_units hou
1909: ,hr_organization_information bank
1910: WHERE hoi.organization_id = hou.organization_id
1911: AND hou.business_group_id = (SELECT business_group_id
1912: FROM hr_organization_units org
1913: WHERE org.organization_id = p_organization_id)
1914: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1915: AND bank.org_information_context = 'PER_IN_CHALLAN_BANK'
1916: AND bank.organization_id = hoi.organization_id

Line 2855: FROM hr_organization_units

2851: ,name
2852: ,date_from
2853: ,date_to
2854: ,location_id
2855: FROM hr_organization_units
2856: WHERE organization_id = p_organization_id;
2857:
2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;

Line 2858: l_organization_id hr_organization_units.organization_id%TYPE;

2854: ,location_id
2855: FROM hr_organization_units
2856: WHERE organization_id = p_organization_id;
2857:
2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;
2860: l_date_from hr_organization_units.date_from%TYPE;
2861: l_date_to hr_organization_units.date_to%TYPE;
2862: l_location_id hr_organization_units.location_id%TYPE;

Line 2859: l_name hr_organization_units.name%TYPE;

2855: FROM hr_organization_units
2856: WHERE organization_id = p_organization_id;
2857:
2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;
2860: l_date_from hr_organization_units.date_from%TYPE;
2861: l_date_to hr_organization_units.date_to%TYPE;
2862: l_location_id hr_organization_units.location_id%TYPE;
2863:

Line 2860: l_date_from hr_organization_units.date_from%TYPE;

2856: WHERE organization_id = p_organization_id;
2857:
2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;
2860: l_date_from hr_organization_units.date_from%TYPE;
2861: l_date_to hr_organization_units.date_to%TYPE;
2862: l_location_id hr_organization_units.location_id%TYPE;
2863:
2864: l_procedure VARCHAR2(100);

Line 2861: l_date_to hr_organization_units.date_to%TYPE;

2857:
2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;
2860: l_date_from hr_organization_units.date_from%TYPE;
2861: l_date_to hr_organization_units.date_to%TYPE;
2862: l_location_id hr_organization_units.location_id%TYPE;
2863:
2864: l_procedure VARCHAR2(100);
2865: l_message VARCHAR2(300);

Line 2862: l_location_id hr_organization_units.location_id%TYPE;

2858: l_organization_id hr_organization_units.organization_id%TYPE;
2859: l_name hr_organization_units.name%TYPE;
2860: l_date_from hr_organization_units.date_from%TYPE;
2861: l_date_to hr_organization_units.date_to%TYPE;
2862: l_location_id hr_organization_units.location_id%TYPE;
2863:
2864: l_procedure VARCHAR2(100);
2865: l_message VARCHAR2(300);
2866: