APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 91: FROM hr_organization_units

87:
88: /*Cursor for fetching Employer Name*/
89: CURSOR csr_employer_name IS
90: SELECT name
91: FROM hr_organization_units
92: WHERE organization_id = p_employer_id;
93:
94: /*Cursor for fetching defined balance id*/
95: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 160: from hr_organization_units

156:
157: /* Cursor for fetching Employer's location_id */
158: CURSOR csr_get_loc_id IS
159: select location_id
160: from hr_organization_units
161: where organization_id = p_employer_id
162: and business_group_id = p_business_group_id;
163:
164: /* Cursor for fetching Employer's Address */

Line 226: l_employer_name hr_organization_units.name%TYPE;

222: t_store_assact t_assact_table;
223:
224:
225: l_postal_code varchar2(100);
226: l_employer_name hr_organization_units.name%TYPE;
227: l_employer_ssn NUMBER;
228: l_employer_civilid NUMBER; -- Oct 2012
229: l_basic_social_id NUMBER;
230: l_supplementary_social_id NUMBER;

Line 717: FROM hr_organization_units

713:
714: /*Cursor for fetching Employer Name*/
715: CURSOR csr_employer_name IS
716: SELECT name
717: FROM hr_organization_units
718: WHERE organization_id = p_employer_id;
719:
720: /*Cursor for fetching defined balance id*/
721: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS

Line 1377: FROM hr_organization_units

1373:
1374: /*Cursor for fetching Employer Name*/
1375: CURSOR csr_employer_name IS
1376: SELECT name
1377: FROM hr_organization_units
1378: WHERE organization_id = p_employer_id;
1379:
1380: /*Cursor for fetching defined balance id*/
1381: CURSOR csr_get_def_bal_id(p_user_name VARCHAR2) IS