DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 76: pay_element_entry_values_f peev_sd,

72: select /*+ ordered */
73: pee.element_entry_id, pee.object_version_number, pee.effective_start_date
74: from pay_element_links_f pel,
75: pay_element_entries_f pee,
76: pay_element_entry_values_f peev_sd,
77: pay_element_entry_values_f peev_ed
78: where pel.element_type_id = v_element_type_id
79: and pee.element_link_id = pel.element_link_id
80: and pee.effective_start_date between pel.effective_start_date and pel.effective_end_date

Line 77: pay_element_entry_values_f peev_ed

73: pee.element_entry_id, pee.object_version_number, pee.effective_start_date
74: from pay_element_links_f pel,
75: pay_element_entries_f pee,
76: pay_element_entry_values_f peev_sd,
77: pay_element_entry_values_f peev_ed
78: where pel.element_type_id = v_element_type_id
79: and pee.element_link_id = pel.element_link_id
80: and pee.effective_start_date between pel.effective_start_date and pel.effective_end_date
81: and pee.effective_end_date between pel.effective_start_date and pel.effective_end_date

Line 107: pay_element_entry_values_f peev_sd,

103: select /*+ ordered */
104: pee.element_entry_id, pee.object_version_number, pee.effective_start_date
105: from pay_element_links_f pel,
106: pay_element_entries_f pee,
107: pay_element_entry_values_f peev_sd,
108: pay_element_entry_values_f peev_ed
109: where pel.element_type_id = v_element_type_id
110: and pee.element_link_id = pel.element_link_id
111: and pee.effective_start_date between pel.effective_start_date and pel.effective_end_date

Line 108: pay_element_entry_values_f peev_ed

104: pee.element_entry_id, pee.object_version_number, pee.effective_start_date
105: from pay_element_links_f pel,
106: pay_element_entries_f pee,
107: pay_element_entry_values_f peev_sd,
108: pay_element_entry_values_f peev_ed
109: where pel.element_type_id = v_element_type_id
110: and pee.element_link_id = pel.element_link_id
111: and pee.effective_start_date between pel.effective_start_date and pel.effective_end_date
112: and pee.effective_end_date between pel.effective_start_date and pel.effective_end_date