APPS.PER_FR_VALIDATE_DELETE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 9: FROM HR_ORGANIZATION_INFORMATION

5: is
6:
7: cursor csr_estab_comp is
8: SELECT '1'
9: FROM HR_ORGANIZATION_INFORMATION
10: WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_INFO'
11: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
12:
13: cursor csr_estab_urssaf is

Line 16: FROM HR_ORGANIZATION_INFORMATION

12:
13: cursor csr_estab_urssaf is
14:
15: SELECT '1'
16: FROM HR_ORGANIZATION_INFORMATION
17: WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_URSSAF'
18: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
19:
20: cursor csr_estab_assedic is

Line 22: FROM HR_ORGANIZATION_INFORMATION

18: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
19:
20: cursor csr_estab_assedic is
21: SELECT '1'
22: FROM HR_ORGANIZATION_INFORMATION
23: WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_ASSEDIC'
24: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
25:
26: cursor csr_estab_pens is

Line 28: FROM HR_ORGANIZATION_INFORMATION

24: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
25:
26: cursor csr_estab_pens is
27: SELECT '1'
28: FROM HR_ORGANIZATION_INFORMATION
29: WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_PE_PRVS'
30: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
31:
32: cursor csr_estab_insu is

Line 34: FROM HR_ORGANIZATION_INFORMATION

30: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
31:
32: cursor csr_estab_insu is
33: SELECT '1'
34: FROM HR_ORGANIZATION_INFORMATION
35: WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_INS_PRV'
36: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
37:
38: cursor csr_comp_urssaf is

Line 40: FROM HR_ORGANIZATION_INFORMATION

36: AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;
37:
38: cursor csr_comp_urssaf is
39: SELECT '1'
40: FROM HR_ORGANIZATION_INFORMATION
41: WHERE ORG_INFORMATION_CONTEXT = 'FR_COMP_INFO'
42: AND x_organization_id = to_number(ORG_INFORMATION3);
43:
44: cursor csr_comp_dads_estab is

Line 46: from hr_organization_information oi, hr_all_organization_units ou

42: AND x_organization_id = to_number(ORG_INFORMATION3);
43:
44: cursor csr_comp_dads_estab is
45: select 1
46: from hr_organization_information oi, hr_all_organization_units ou
47: where oi.organization_id = ou.organization_id
48: and oi.organization_id = x_organization_id
49: and oi.org_information_context = 'FR_ESTAB_INFO'
50: and to_number (oi.org_information1) =

Line 52: from hr_all_organization_units ou, hr_organization_information oi

48: and oi.organization_id = x_organization_id
49: and oi.org_information_context = 'FR_ESTAB_INFO'
50: and to_number (oi.org_information1) =
51: (select ou.organization_id
52: from hr_all_organization_units ou, hr_organization_information oi
53: where to_number (oi.org_information4) = x_organization_id
54: and oi.organization_id = ou.organization_id
55: and oi.org_information_context = 'FR_COMP_INFO');
56:

Line 59: from hr_organization_information oi, hr_all_organization_units ou

55: and oi.org_information_context = 'FR_COMP_INFO');
56:
57: cursor csr_comp_heaq_estab is
58: select 1
59: from hr_organization_information oi, hr_all_organization_units ou
60: where oi.organization_id = ou.organization_id
61: and oi.organization_id = x_organization_id
62: and oi.org_information_context = 'FR_ESTAB_INFO'
63: and to_number (oi.org_information1) =

Line 65: from hr_all_organization_units ou, hr_organization_information oi

61: and oi.organization_id = x_organization_id
62: and oi.org_information_context = 'FR_ESTAB_INFO'
63: and to_number (oi.org_information1) =
64: (select ou.organization_id
65: from hr_all_organization_units ou, hr_organization_information oi
66: where to_number (oi.org_information5) = x_organization_id
67: and oi.organization_id = ou.organization_id
68: and oi.org_information_context = 'FR_COMP_INFO');
69:

Line 72: FROM HR_ORGANIZATION_INFORMATION

68: and oi.org_information_context = 'FR_COMP_INFO');
69:
70: cursor csr_comp_pens is
71: SELECT '1'
72: FROM HR_ORGANIZATION_INFORMATION
73: WHERE ORG_INFORMATION_CONTEXT (+) = 'FR_COMP_PE_PRVS'
74: AND x_organization_id = to_number(ORG_INFORMATION1);
75:
76: cursor csr_comp_insu is

Line 78: FROM HR_ORGANIZATION_INFORMATION

74: AND x_organization_id = to_number(ORG_INFORMATION1);
75:
76: cursor csr_comp_insu is
77: SELECT '1'
78: FROM HR_ORGANIZATION_INFORMATION
79: WHERE ORG_INFORMATION_CONTEXT (+) = 'FR_COMP_INS_PRVS'
80: AND x_organization_id = to_number(ORG_INFORMATION1);
81:
82: