APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 67: pay_element_entry_values_f peevf

63:
64: cursor advance_amount is
65: select peevf.screen_entry_value
66: from pay_element_entries_f peef,
67: pay_element_entry_values_f peevf
68: where peef.assignment_id = p_assignment_id and
69: peef.target_entry_id = p_target_entry_id and
70: peef.effective_start_date < p_advance_pay_start_date and
71: peef.element_entry_id = peevf.element_entry_id and

Line 158: pay_element_entry_values_f peevf

154:
155: cursor processed_flag is
156: select 'Y'
157: from pay_element_entries_f peef,
158: pay_element_entry_values_f peevf
159: where peef.assignment_id = p_assignment_id and
160: peef.target_entry_id = p_target_entry_id and
161: peef.effective_start_date < p_advance_pay_start_date and
162: peef.element_entry_id = peevf.element_entry_id and

Line 691: from pay_element_entry_values_f peevf

687: -- min of two input values - advance pay period start date
688: min(fnd_date.canonical_to_date(peevf.screen_entry_value)),
689: -- max of two input values - advance pay period end date
690: max(fnd_date.canonical_to_date(peevf.screen_entry_value))
691: from pay_element_entry_values_f peevf
692: where peevf.element_entry_id = p_pai_element_entry_id;
693: --
694: cursor corresponding_ai_entries is
695: --returns element_entry_ids of all Advance Indicator entries that