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 39: FROM hr_organization_information

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

Line 143: FROM hr_organization_information

139: l_local_nationality := NULL;
140: BEGIN
141: SELECT org_information1
142: INTO l_local_nationality
143: FROM hr_organization_information
144: WHERE org_information_context = 'KW_BG_DETAILS'
145: AND organization_id = p_business_group_id;
146: EXCEPTION
147: WHEN OTHERS THEN

Line 572: FROM hr_organization_information

568:
569: /*Cursor for fetching Employer SSN*/
570: CURSOR csr_employer_ssn IS
571: SELECT LPAD(org_information4,9,'0')
572: FROM hr_organization_information
573: WHERE organization_id = p_employer_id
574: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
575:
576: /*Cursor for fetching Employer Name*/

Line 706: FROM hr_organization_information

702: l_local_nationality := NULL;
703: BEGIN
704: SELECT org_information1
705: INTO l_local_nationality
706: FROM hr_organization_information
707: WHERE org_information_context = 'KW_BG_DETAILS'
708: AND organization_id = p_business_group_id;
709: EXCEPTION
710: WHEN OTHERS THEN

Line 981: FROM hr_organization_information

977:
978: /*Cursor for fetching Employer SSN*/
979: CURSOR csr_employer_ssn IS
980: SELECT LPAD(org_information4,9,'0')
981: FROM hr_organization_information
982: WHERE organization_id = p_employer_id
983: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
984:
985: /*Cursor for fetching Employer Name*/

Line 1211: FROM hr_organization_information

1207: l_local_nationality := NULL;
1208: BEGIN
1209: SELECT org_information1
1210: INTO l_local_nationality
1211: FROM hr_organization_information
1212: WHERE org_information_context = 'KW_BG_DETAILS'
1213: AND organization_id = p_business_group_id;
1214: EXCEPTION
1215: WHEN OTHERS THEN

Line 1615: FROM hr_organization_information

1611:
1612: /*Cursor for fetching Employer SSN*/
1613: CURSOR csr_employer_ssn IS
1614: SELECT LPAD(org_information4,9,'0')
1615: FROM hr_organization_information
1616: WHERE organization_id = p_employer_id
1617: AND org_information_context = 'KW_LEGAL_EMPLOYER_DETAILS';
1618:
1619: /*Cursor for fetching Employer Name*/

Line 1801: FROM hr_organization_information

1797: l_local_nationality := NULL;
1798: BEGIN
1799: SELECT org_information1
1800: INTO l_local_nationality
1801: FROM hr_organization_information
1802: WHERE org_information_context = 'KW_BG_DETAILS'
1803: AND organization_id = p_business_group_id;
1804: EXCEPTION
1805: WHEN OTHERS THEN