APPS.HRFRBSOC dependencies on HR_FR_ESTABLISHMENTS_V

Line 20: /* Bug 2217457 Changed to use hr_fr_establishments_v */

16: l_est_string VARCHAR2(4000):=NULL;
17: l_select_string VARCHAR2(4000):=NULL;
18: l_dummy number;
19: --
20: /* Bug 2217457 Changed to use hr_fr_establishments_v */
21: CURSOR csr_get_est IS
22: SELECT organization_id organization_id
23: FROM hr_fr_establishments_v
24: WHERE company_org_id = to_char(p_company_id)

Line 23: FROM hr_fr_establishments_v

19: --
20: /* Bug 2217457 Changed to use hr_fr_establishments_v */
21: CURSOR csr_get_est IS
22: SELECT organization_id organization_id
23: FROM hr_fr_establishments_v
24: WHERE company_org_id = to_char(p_company_id)
25: OR organization_id = p_company_id;
26: --
27: BEGIN

Line 34: l_select_string := '(SELECT organization_id establishment_id FROM hr_fr_establishments_v WHERE company_org_id = ';

30: l_select_string := '(select '||p_establishment_id||' establishment_id from dual) v';
31: l_est_string := '('||p_establishment_id||')';
32: ELSE
33: /* Bug 2217457 - Changed to use views instead of union select from dual */
34: l_select_string := '(SELECT organization_id establishment_id FROM hr_fr_establishments_v WHERE company_org_id = ';
35: l_select_string := l_select_string || to_char(p_company_id) || ' OR organization_id = ';
36: l_select_string := l_select_string || to_char(p_company_id) || ') v ';
37: FOR l_rec IN csr_get_est LOOP
38: IF csr_get_est%ROWCOUNT=1 THEN