APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 11: FROM hr_organization_information

7: (p_business_group_id IN NUMBER) IS
8: /* Cursor to retrieve Currency */
9: CURSOR csr_currency IS
10: SELECT org_information10
11: FROM hr_organization_information
12: WHERE organization_id = p_business_group_id
13: AND org_information_context = 'Business Group Information';
14: l_currency VARCHAR2(40);
15: BEGIN

Line 43: FROM hr_organization_information

39:
40: /*Cursor for fetching Employer SSN*/
41: CURSOR csr_employer_ssn IS
42: SELECT LPAD(org_information4,9,'0')
43: FROM hr_organization_information
44: WHERE organization_id = p_employer_id
45: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
46:
47: /*Cursor for fetching Employer Name*/

Line 170: FROM hr_organization_information

166: l_local_nationality := NULL;
167: BEGIN
168: SELECT org_information1
169: INTO l_local_nationality
170: FROM hr_organization_information
171: WHERE org_information_context = 'KW_BG_DETAILS'
172: AND organization_id = p_business_group_id;
173: EXCEPTION
174: WHEN OTHERS THEN

Line 723: FROM hr_organization_information

719:
720: /*Cursor for fetching Employer SSN*/
721: CURSOR csr_employer_ssn IS
722: SELECT LPAD(org_information4,9,'0')
723: FROM hr_organization_information
724: WHERE organization_id = p_employer_id
725: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
726:
727: /*Cursor for fetching Employer Name*/

Line 857: FROM hr_organization_information

853: l_local_nationality := NULL;
854: BEGIN
855: SELECT org_information1
856: INTO l_local_nationality
857: FROM hr_organization_information
858: WHERE org_information_context = 'KW_BG_DETAILS'
859: AND organization_id = p_business_group_id;
860: EXCEPTION
861: WHEN OTHERS THEN

Line 1132: FROM hr_organization_information

1128:
1129: /*Cursor for fetching Employer SSN*/
1130: CURSOR csr_employer_ssn IS
1131: SELECT LPAD(org_information4,9,'0')
1132: FROM hr_organization_information
1133: WHERE organization_id = p_employer_id
1134: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
1135:
1136: /*Cursor for fetching Employer Name*/

Line 1362: FROM hr_organization_information

1358: l_local_nationality := NULL;
1359: BEGIN
1360: SELECT org_information1
1361: INTO l_local_nationality
1362: FROM hr_organization_information
1363: WHERE org_information_context = 'KW_BG_DETAILS'
1364: AND organization_id = p_business_group_id;
1365: EXCEPTION
1366: WHEN OTHERS THEN

Line 1773: FROM hr_organization_information

1769:
1770: /*Cursor for fetching Employer SSN*/
1771: CURSOR csr_employer_ssn IS
1772: SELECT LPAD(org_information4,9,'0')
1773: FROM hr_organization_information
1774: WHERE organization_id = p_employer_id
1775: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
1776:
1777: /*Cursor for fetching Employer Name*/

Line 1921: FROM HR_ORGANIZATION_INFORMATION

1917:
1918: /* Cursor for fetching Defined balance ids from Org EIT for Social Allowance Oct 2012*/
1919: CURSOR csr_get_def_bal_ids (l_emp_id number) IS
1920: SELECT ORG_INFORMATION1
1921: FROM HR_ORGANIZATION_INFORMATION
1922: WHERE Organization_id = l_emp_id
1923: AND org_information_context = 'KW_SI_DETAILS';
1924:
1925:

Line 2019: FROM hr_organization_information

2015: l_local_nationality := NULL;
2016: BEGIN
2017: SELECT org_information1
2018: INTO l_local_nationality
2019: FROM hr_organization_information
2020: WHERE org_information_context = 'KW_BG_DETAILS'
2021: AND organization_id = p_business_group_id;
2022: EXCEPTION
2023: WHEN OTHERS THEN