DBA Data[Home] [Help]

APPS.PAY_ADVANCE_PAY_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 64: from pay_element_entries_f peef,

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

Line 155: from pay_element_entries_f peef,

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

Line 701: pay_element_entries_f peef

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