APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 76: FROM hr_organization_units

72:
73: /*Cursor for fetching Employer Name*/
74: CURSOR csr_employer_name IS
75: SELECT name
76: FROM hr_organization_units
77: WHERE organization_id = p_employer_id;
78:
79: /*Cursor for fetching defined balance id*/
80: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 145: from hr_organization_units

141:
142: /* Cursor for fetching Employer's location_id */
143: CURSOR csr_get_loc_id IS
144: select location_id
145: from hr_organization_units
146: where organization_id = p_employer_id
147: and business_group_id = p_business_group_id;
148:
149: /* Cursor for fetching Employer's Address */

Line 211: l_employer_name hr_organization_units.name%TYPE;

207: t_store_assact t_assact_table;
208:
209:
210: l_postal_code varchar2(100);
211: l_employer_name hr_organization_units.name%TYPE;
212: l_employer_ssn NUMBER;
213: l_basic_social_id NUMBER;
214: l_supplementary_social_id NUMBER;
215: l_additional_social_id NUMBER;

Line 659: FROM hr_organization_units

655:
656: /*Cursor for fetching Employer Name*/
657: CURSOR csr_employer_name IS
658: SELECT name
659: FROM hr_organization_units
660: WHERE organization_id = p_employer_id;
661:
662: /*Cursor for fetching defined balance id*/
663: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 1319: FROM hr_organization_units

1315:
1316: /*Cursor for fetching Employer Name*/
1317: CURSOR csr_employer_name IS
1318: SELECT name
1319: FROM hr_organization_units
1320: WHERE organization_id = p_employer_id;
1321:
1322: /*Cursor for fetching defined balance id*/
1323: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS