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 1875: from HR_ASSIGNMENT_SETS_V

1871: where CONSOLIDATION_SET_ID = l_consolidation_set_id;
1872:
1873: cursor csr_assignment_set is
1874: select ASSIGNMENT_SET_NAME
1875: from HR_ASSIGNMENT_SETS_V
1876: where ASSIGNMENT_SET_ID =l_assignment_set_id;
1877:
1878: l_effective_date date;
1879: begin

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

2450: end if;
2451:
2452: if l_assignment_set_id is not null
2453: then
2454: l_from := l_from || ',hr_assignment_sets has
2455: ,hr_assignment_set_amendments hasa ';
2456: l_where := l_where ||
2457: ' and has.assignment_set_id = ' || l_assignment_set_id ||
2458: ' and has.assignment_set_id = hasa.assignment_set_id(+)