APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 91: from per_all_assignments_f paa

87: and peev_ed.input_value_id = v_ben_end_date_id
88: and peev_ed.screen_entry_value <= v_end_date
89: and exists( select /*+ no_unnest */
90: 1
91: from per_all_assignments_f paa
92: where paa.assignment_id = pee.assignment_id
93: and paa.business_group_id = v_bus_grp_id);
94:
95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,

Line 122: from per_all_assignments_f paa,

118: and peev_ed.input_value_id = v_ben_end_date_id
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

Line 2407: per_all_assignments_f paf,

2403: use_index(pai_person,pay_action_information_n2)
2404: use_index(pai,pay_action_information_n2) */
2405: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2406: l_from := 'from pay_assignment_actions paa,
2407: per_all_assignments_f paf,
2408: pay_action_information emp,
2409: pay_action_information pai_payroll ';
2410: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2411: and paa.action_status = ''C''

Line 5535: per_all_assignments_f paf

5531: from per_addresses
5532: where person_id = (
5533: select distinct person_id
5534: from pay_assignment_actions paa,
5535: per_all_assignments_f paf
5536: where paa.assignment_action_id = p_assignment_action_id
5537: and paf.assignment_id = paa.assignment_id)
5538: and primary_flag = 'Y'
5539: and sysdate between date_from and nvl(date_to, hr_general.end_of_time);