APPS.GHR_BEN_VALIDATION dependencies on PAY_ELEMENT_ENTRIES_F

Line 104: FROM pay_element_entries_f ele

100: c_effective_date per_all_assignments_f.effective_start_date%type,
101: c_element_type_id pay_element_types_f.element_type_id%type)
102: IS
103: SELECT 1
104: FROM pay_element_entries_f ele
105: WHERE ele.assignment_id = c_assignment_id
106: AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
107: AND element_type_id = c_element_type_id;
108:

Line 769: c_effective_date pay_element_entries_f.effective_start_date%type,

765:
766: --Bug #12553476 Modified c_element cursor to map the effective date comparison
767: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,
768: c_assignment_id per_all_assignments_f.assignment_id%type,
769: c_effective_date pay_element_entries_f.effective_start_date%type,
770: c_business_group_id pay_element_links_f.business_group_id%type
771: ) is
772: SELECT a.element_name element_name,
773: b.name ipv_name,

Line 784: pay_element_entries_f e,

780: f.element_entry_value_id element_entry_value_id,
781: f.screen_entry_value screen_entry_value
782: FROM pay_element_types_f a,
783: pay_input_values_f b,
784: pay_element_entries_f e,
785: pay_element_entry_values_f f,
786: pay_element_links_f g
787: WHERE a.element_type_id = b.element_type_id
788: AND e.element_type_id = a.element_type_id

Line 856: pay_element_entries_f ele

852: select ele.element_entry_id,
853: ele.object_version_number
854: from pay_element_types_f elt,
855: pay_element_links_f eli,
856: pay_element_entries_f ele
857: where ele.assignment_id = p_assignment_id
858: and upper(elt.element_name) = upper('TSP Roth 401K')
859: and elt.element_type_id = eli.element_type_id + 0
860: and elt.element_type_id = ele.element_type_id + 0