APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on HR_ASSIGNMENT_SETS

Line 123: hr_assignment_sets has,

119: and peev_ed.screen_entry_value <= v_end_date
120: and exists( select /*+ no_unnest */
121: 1
122: from per_all_assignments_f paa,
123: hr_assignment_sets has,
124: hr_assignment_set_amendments hasa
125: where paa.assignment_id = pee.assignment_id
126: and paa.business_group_id = v_bus_grp_id
127: and ( has.assignment_set_id = v_assignment_set_id

Line 2327: from HR_ASSIGNMENT_SETS_V

2323: where CONSOLIDATION_SET_ID = l_consolidation_set_id;
2324:
2325: cursor csr_assignment_set is
2326: select ASSIGNMENT_SET_NAME
2327: from HR_ASSIGNMENT_SETS_V
2328: where ASSIGNMENT_SET_ID =l_assignment_set_id;
2329:
2330: l_effective_date date;
2331: begin

Line 2940: l_from := l_from || ',hr_assignment_sets has

2936: end if;
2937:
2938: if l_assignment_set_id is not null
2939: then
2940: l_from := l_from || ',hr_assignment_sets has
2941: ,hr_assignment_set_amendments hasa ';
2942: l_where := l_where ||
2943: ' and has.assignment_set_id = ' || l_assignment_set_id ||
2944: ' and has.assignment_set_id = hasa.assignment_set_id(+)