APPS.PAY_AE_SI_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 98: FROM hr_organization_units

94:
95: /*Cursor for fetching Employer Name*/
96: CURSOR csr_employer_name IS
97: SELECT name
98: FROM hr_organization_units
99: WHERE organization_id = p_employer_id;
100:
101: /* Cursor for fetching current employer type */
102: CURSOR csr_cur_employer_type IS

Line 1238: FROM hr_organization_units

1234:
1235: /*Cursor for fetching Employer Name*/
1236: CURSOR csr_employer_name IS
1237: SELECT name
1238: FROM hr_organization_units
1239: WHERE organization_id = p_employer_id;
1240:
1241: /* Cursor for fetching organization phone types */
1242: CURSOR csr_get_org_phone_types (l_bg_id number) IS

Line 2097: FROM hr_organization_units

2093:
2094: /*Cursor for fetching Employer Name*/
2095: CURSOR csr_employer_name IS
2096: SELECT name
2097: FROM hr_organization_units
2098: WHERE organization_id = p_employer_id;
2099:
2100: /*Cursor for fetching employees*/
2101: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS

Line 2622: FROM hr_organization_units

2618:
2619: /*Cursor for fetching Employer Name*/
2620: CURSOR csr_employer_name IS
2621: SELECT name
2622: FROM hr_organization_units
2623: WHERE organization_id = p_employer_id;
2624:
2625: /*Cursor for fetching list of new employees*/
2626: CURSOR csr_get_new_emp (l_effective_date date, l_nat_cd varchar2) IS

Line 3800: FROM hr_organization_units

3796:
3797: /*Cursor for fetching Employer Name*/
3798: CURSOR csr_employer_name IS
3799: SELECT name
3800: FROM hr_organization_units
3801: WHERE organization_id = p_employer_id;
3802:
3803: /*Cursor for fetching employees*/
3804: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS

Line 4570: FROM hr_organization_units

4566:
4567: /*Cursor for fetching Employer Name*/
4568: CURSOR csr_employer_name IS
4569: SELECT name
4570: FROM hr_organization_units
4571: WHERE organization_id = p_employer_id;
4572:
4573: /*Cursor for fetching employees*/
4574: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS