APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on HR_OPERATING_UNITS

Line 126: hr_operating_units hou

122: CURSOR get_org_and_srp_id(p_person_id jtf_rs_salesreps.person_id%TYPE)
123: IS
124: SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
126: hr_operating_units hou
127: WHERE rre.source_id = p_person_id
128: AND rre.resource_id = rs.resource_id
129: AND rre.category = 'EMPLOYEE'
130: AND rs.org_id = hou.organization_id;

Line 180: l_temp_org_name hr_operating_units.name%TYPE;

176: l_from_currency gl_sets_of_books.currency_code%TYPE;
177: l_conversion_date DATE;
178: l_conversion_type gl_daily_conversion_types.conversion_type%TYPE;
179:
180: l_temp_org_name hr_operating_units.name%TYPE;
181: l_temp_start_date DATE;
182: l_temp_end_date DATE;
183:
184: l_new_start_date DATE;