APPS.GHR_BEN_VALIDATION dependencies on PAY_ELEMENT_ENTRIES_F

Line 71: FROM pay_element_entries_f ele

67: c_effective_date per_all_assignments_f.effective_start_date%type,
68: c_element_type_id pay_element_types_f.element_type_id%type)
69: IS
70: SELECT 1
71: FROM pay_element_entries_f ele
72: WHERE ele.assignment_id = c_assignment_id
73: AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
74: AND element_type_id = c_element_type_id;
75:

Line 565: c_effective_date pay_element_entries_f.effective_start_date%type,

561:
562:
563: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,
564: c_assignment_id per_all_assignments_f.assignment_id%type,
565: c_effective_date pay_element_entries_f.effective_start_date%type,
566: c_business_group_id pay_element_links_f.business_group_id%type
567: ) is
568: SELECT a.element_name element_name,
569: b.name ipv_name,

Line 580: pay_element_entries_f e,

576: f.element_entry_value_id element_entry_value_id,
577: f.screen_entry_value screen_entry_value
578: FROM pay_element_types_f a,
579: pay_input_values_f b,
580: pay_element_entries_f e,
581: pay_element_entry_values_f f,
582: pay_element_links_f g
583: WHERE a.element_type_id = b.element_type_id
584: AND e.element_type_id = a.element_type_id