APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 65: pay_element_entry_values_f peevf

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

Line 156: pay_element_entry_values_f peevf

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

Line 689: from pay_element_entry_values_f peevf

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