APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 10: FROM hr_organization_information

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

Line 55: FROM hr_organization_information

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 */

Line 62: FROM HR_ORGANIZATION_INFORMATION

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 Employer SSN*/

Line 69: FROM hr_organization_information

65:
66: /*Cursor for fetching Employer SSN*/
67: CURSOR csr_employer_ssn IS
68: SELECT LPAD(org_information4,9,'0')
69: FROM hr_organization_information
70: WHERE organization_id = p_employer_id
71: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
72:
73: /*Cursor for fetching Employer Name*/

Line 128: from hr_organization_information

124:
125: /* Cursor to fetch phone and fax information of the employer */
126: CURSOR csr_get_det_employer (l_type varchar2) IS
127: select org_information3
128: from hr_organization_information
129: where org_information_context = 'ORG_CONTACT_DETAILS'
130: and organization_id = p_employer_id
131: and org_information1 = l_type;
132:

Line 645: FROM hr_organization_information

641:
642: /*Cursor for fetching Local nationality for the BG */
643: CURSOR csr_get_loc_nat IS
644: SELECT org_information1
645: FROM hr_organization_information
646: WHERE organization_id = p_business_group_id
647: AND org_information_context = 'KW_BG_DETAILS';
648:
649: /*Cursor for fetching Employer SSN*/

Line 652: FROM hr_organization_information

648:
649: /*Cursor for fetching Employer SSN*/
650: CURSOR csr_employer_ssn IS
651: SELECT LPAD(org_information4,9,'0')
652: FROM hr_organization_information
653: WHERE organization_id = p_employer_id
654: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
655:
656: /*Cursor for fetching Employer Name*/

Line 1298: FROM hr_organization_information

1294:
1295: /*Cursor for fetching Local nationality for the BG */
1296: CURSOR csr_get_loc_nat IS
1297: SELECT org_information1
1298: FROM hr_organization_information
1299: WHERE organization_id = p_business_group_id
1300: AND org_information_context = 'KW_BG_DETAILS';
1301:
1302: /* Cursor for fetching Defined balance ids from Org EIT */

Line 1305: FROM HR_ORGANIZATION_INFORMATION

1301:
1302: /* Cursor for fetching Defined balance ids from Org EIT */
1303: CURSOR csr_get_def_bal_ids (l_emp_id number) IS
1304: SELECT ORG_INFORMATION1
1305: FROM HR_ORGANIZATION_INFORMATION
1306: WHERE Organization_id = l_emp_id
1307: AND org_information_context = 'KW_SI_DETAILS';
1308:
1309: /*Cursor for fetching Employer SSN*/

Line 1312: FROM hr_organization_information

1308:
1309: /*Cursor for fetching Employer SSN*/
1310: CURSOR csr_employer_ssn IS
1311: SELECT LPAD(org_information4,9,'0')
1312: FROM hr_organization_information
1313: WHERE organization_id = p_employer_id
1314: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
1315:
1316: /*Cursor for fetching Employer Name*/