DBA Data[Home] [Help]

APPS.PAY_ELEMENT_ENTRY_API dependencies on PER_TIME_PERIODS

Line 132: l_period_status per_time_periods.status%TYPE;

128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519
132: l_period_status per_time_periods.status%TYPE;
133: --
134: -- Enhancement 2793978
135: -- size of entry_value variables increased to deal with
136: -- screen format of entry values that use value sets

Line 188: FROM per_time_periods ptp,

184: and l_effective_date between ee.effective_start_date
185: and ee.effective_end_date;
186: CURSOR c_assignment_details IS
187: SELECT ptp.status
188: FROM per_time_periods ptp,
189: per_assignments_f pas
190: WHERE pas.assignment_id = p_assignment_id
191: AND pas.payroll_id = ptp.payroll_id
192: AND l_effective_date BETWEEN ptp.start_date