[Home] [Help]
6: (p_business_group_id IN NUMBER) IS
7: /* Cursor to retrieve Currency */
8: CURSOR csr_currency IS
9: SELECT org_information10
10: FROM hr_organization_information
11: WHERE organization_id = p_business_group_id
12: AND org_information_context = 'Business Group Information';
13: l_currency VARCHAR2(40);
14: BEGIN
51:
52: /*Cursor for fetching Local nationality for the BG */
53: CURSOR csr_get_loc_nat IS
54: SELECT org_information1
55: FROM hr_organization_information
56: WHERE organization_id = p_business_group_id
57: AND org_information_context = 'KW_BG_DETAILS';
58:
59: /* Cursor for fetching Defined balance ids from Org EIT */
58:
59: /* Cursor for fetching Defined balance ids from Org EIT */
60: CURSOR csr_get_def_bal_ids (l_emp_id number) IS
61: SELECT ORG_INFORMATION1
62: FROM HR_ORGANIZATION_INFORMATION
63: WHERE Organization_id = l_emp_id
64: AND org_information_context = 'KW_SI_DETAILS';
65:
66: /* Cursor for fetching Defined balance ids from Org EIT for Bonus which is stored in org_information2 Oct 2012 */
65:
66: /* Cursor for fetching Defined balance ids from Org EIT for Bonus which is stored in org_information2 Oct 2012 */
67: CURSOR csr_get_def_bal_ids_b (l_emp_id number) IS
68: SELECT ORG_INFORMATION2
69: FROM HR_ORGANIZATION_INFORMATION
70: WHERE Organization_id = l_emp_id
71: AND org_information_context = 'KW_SI_DETAILS';
72:
73: /*Cursor for fetching Employer SSN*/
72:
73: /*Cursor for fetching Employer SSN*/
74: CURSOR csr_employer_ssn IS
75: SELECT LPAD(org_information4,9,'0')
76: FROM hr_organization_information
77: WHERE organization_id = p_employer_id
78: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
79:
80: /*Cursor for fetching Employer Civil Identifier - added Oct 2012*/
79:
80: /*Cursor for fetching Employer Civil Identifier - added Oct 2012*/
81: CURSOR csr_employer_civilid IS
82: SELECT LPAD(org_information6,8,'0')
83: FROM hr_organization_information
84: WHERE organization_id = p_employer_id
85: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
86:
87:
139:
140: /* Cursor to fetch phone and fax information of the employer */
141: CURSOR csr_get_det_employer (l_type varchar2) IS
142: select org_information3
143: from hr_organization_information
144: where org_information_context = 'ORG_CONTACT_DETAILS'
145: and organization_id = p_employer_id
146: and org_information1 = l_type;
147:
699:
700: /*Cursor for fetching Local nationality for the BG */
701: CURSOR csr_get_loc_nat IS
702: SELECT org_information1
703: FROM hr_organization_information
704: WHERE organization_id = p_business_group_id
705: AND org_information_context = 'KW_BG_DETAILS';
706:
707: /*Cursor for fetching Employer SSN*/
706:
707: /*Cursor for fetching Employer SSN*/
708: CURSOR csr_employer_ssn IS
709: SELECT LPAD(org_information4,9,'0')
710: FROM hr_organization_information
711: WHERE organization_id = p_employer_id
712: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
713:
714: /*Cursor for fetching Employer Name*/
1352:
1353: /*Cursor for fetching Local nationality for the BG */
1354: CURSOR csr_get_loc_nat IS
1355: SELECT org_information1
1356: FROM hr_organization_information
1357: WHERE organization_id = p_business_group_id
1358: AND org_information_context = 'KW_BG_DETAILS';
1359:
1360: /* Cursor for fetching Defined balance ids from Org EIT */
1359:
1360: /* Cursor for fetching Defined balance ids from Org EIT */
1361: CURSOR csr_get_def_bal_ids (l_emp_id number) IS
1362: SELECT ORG_INFORMATION1
1363: FROM HR_ORGANIZATION_INFORMATION
1364: WHERE Organization_id = l_emp_id
1365: AND org_information_context = 'KW_SI_DETAILS';
1366:
1367: /*Cursor for fetching Employer SSN*/
1366:
1367: /*Cursor for fetching Employer SSN*/
1368: CURSOR csr_employer_ssn IS
1369: SELECT LPAD(org_information4,9,'0')
1370: FROM hr_organization_information
1371: WHERE organization_id = p_employer_id
1372: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
1373:
1374: /*Cursor for fetching Employer Name*/