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 2042: per_all_assignments_f paaf

2038: c_person_id number)is
2039: select paa.assignment_action_id
2040: from pay_action_information pai,
2041: pay_assignment_actions paa,
2042: per_all_assignments_f paaf
2043: where paa.payroll_action_id = c_pact_id
2044: and pai.action_context_id = paa.assignment_action_id
2045: and paa.assignment_action_id <> c_asg_act_id
2046: and paaf.person_id = c_person_id

Line 2893: per_all_assignments_f paf,

2889: use_index(pai_person,pay_action_information_n2)
2890: use_index(pai,pay_action_information_n2) */
2891: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2892: l_from := 'from pay_assignment_actions paa,
2893: per_all_assignments_f paf,
2894: pay_action_information emp,
2895: pay_action_information pai_payroll ';
2896: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2897: and paa.action_status = ''C''

Line 5133: per_all_assignments_f paaf

5129: select pai_a.action_information12 --Modified for the bug 9799823
5130: from pay_action_information pai,
5131: pay_assignment_actions paa,
5132: pay_action_information pai_a,
5133: per_all_assignments_f paaf
5134: where paa.payroll_action_id = c_pact_id
5135: and pai.action_context_id = paa.assignment_action_id
5136: and paa.assignment_action_id <> c_asg_act_id
5137: and paaf.person_id = c_person_id

Line 6355: per_all_assignments_f paf

6351: from per_addresses
6352: where person_id = (
6353: select distinct person_id
6354: from pay_assignment_actions paa,
6355: per_all_assignments_f paf
6356: where paa.assignment_action_id = p_assignment_action_id
6357: and paf.assignment_id = paa.assignment_id)
6358: and primary_flag = 'Y'
6359: and sysdate between date_from and nvl(date_to, hr_general.end_of_time);