APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 66: from pay_element_entries_f peef,

62: l_advance_amount varchar2(60);
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

Line 157: from pay_element_entries_f peef,

153: l_processed_flag varchar2(30);
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

Line 703: pay_element_entries_f peef

699: from
700: pay_legislation_rules plr,
701: pay_element_types_f petf,
702: pay_element_links_f pelf,
703: pay_element_entries_f peef
704: where
705: -- entry belongs to this assignment
706: peef.assignment_id = p_assignment_id and
707: -- entry is of Advance Indicator type