APPS.AS_GAR_QOT_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 1790: FROM jtf_rs_Salesreps a , hr_organization_information b

1786: last_updated_by = FND_GLOBAL.USER_ID,
1787: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1788: (resource_id,resource_grp_id) =
1789: ( SELECT resource_id,org_information3
1790: FROM jtf_rs_Salesreps a , hr_organization_information b
1791: WHERE a.salesrep_number = b.org_information2
1792: AND a.org_id = b.organization_id
1793: AND b.org_information_context = 'ASO_ORG_INFO'
1794: AND b.organization_id = AQH.org_id)

Line 1839: from hr_organization_information

1835: 'Y',
1836: NULL,
1837: 'N',
1838: org_information4
1839: from hr_organization_information
1840: where org_information_context = 'ASO_ORG_INFO'
1841: and organization_id = l_org_id(i);
1842: COMMIT;
1843: l_attempts := 3;

Line 1890: from hr_organization_information

1886: 'Y',
1887: NULL,
1888: 'N',
1889: org_information4
1890: from hr_organization_information
1891: where org_information_context = 'ASO_ORG_INFO'
1892: and organization_id = l_org_id(i);
1893: EXCEPTION
1894: WHEN Others THEN

Line 1915: FROM jtf_rs_Salesreps a , hr_organization_information b

1911: last_updated_by = FND_GLOBAL.USER_ID,
1912: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
1913: (resource_id,resource_grp_id) =
1914: ( SELECT resource_id,org_information3
1915: FROM jtf_rs_Salesreps a , hr_organization_information b
1916: WHERE a.salesrep_number = b.org_information2
1917: AND a.org_id = b.organization_id
1918: AND b.org_information_context = 'ASO_ORG_INFO'
1919: AND b.organization_id = AQH.org_id)

Line 1963: from hr_organization_information

1959: 'Y',
1960: NULL,
1961: 'N',
1962: org_information4
1963: from hr_organization_information
1964: where org_information_context = 'ASO_ORG_INFO'
1965: and organization_id = l_org_id(i);
1966: EXCEPTION
1967: WHEN OTHERS THEN

Line 2022: from hr_organization_information

2018: 'Y',
2019: NULL,
2020: 'N',
2021: org_information4
2022: from hr_organization_information
2023: where org_information_context = 'ASO_ORG_INFO'
2024: and organization_id = l_org_id(i);
2025: END IF;
2026: EXCEPTION