DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 124: hr_assignment_set_amendments hasa

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
128: and nvl(has.payroll_id, paa.payroll_id) = paa.payroll_id

Line 2941: ,hr_assignment_set_amendments hasa ';

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(+)
2945: and (( has.payroll_id is null