APPS.GHR_TSP_PLAN_DESIGN dependencies on PER_ALL_ASSIGNMENTS_F

Line 321: from per_all_assignments_f

317: where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id;
318:
319: Cursor c_get_prev_asg_id is
320: select assignment_id
321: from per_all_assignments_f
322: where person_id = p_person_id
323: and trunc (p_effective_date - 1) between effective_start_date and effective_end_date
324: and assignment_type = 'E';
325:

Line 647: per_all_assignments_f g

643: pay_element_links_f c,
644: pay_link_input_values_f d,
645: pay_element_entries_f e,
646: pay_element_entry_values_f f,
647: per_all_assignments_f g
648: where a.element_type_id = b.element_type_id
649: and a.element_type_id = c.element_type_id
650: and c.element_link_id = d.element_link_id
651: and b.input_value_id = d.input_value_id