DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on PER_TIME_PERIODS

Line 109: from per_time_periods

105: fnd_date.date_to_displaydate (start_date)||
106: ' - '||
107: fnd_date.date_to_displaydate (end_date)||
108: ')' DISPLAY_PERIOD
109: from per_time_periods
110: where payroll_id = p_payroll_id
111: and p_effective_date between start_date and end_date;
112: --
113: begin

Line 308: per_time_periods PERIOD

304: select 'Y'
305: from pay_run_results RESULT,
306: pay_assignment_actions ASGT_ACTION,
307: pay_payroll_actions PAY_ACTION,
308: per_time_periods PERIOD
309: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
310: and result.status <> 'U'
311: and result.source_type = 'E'
312: and result.assignment_action_id = asgt_action.assignment_action_id

Line 333: per_time_periods period

329: from pay_element_entries_f oee,
330: pay_element_entries_f ree,
331: pay_assignment_actions paa,
332: pay_payroll_actions pac,
333: per_time_periods period
334: where oee.element_entry_id = p_element_entry_id
335: and p_effective_date between oee.effective_start_date
336: and oee.effective_end_date
337: and p_effective_date between period.start_date and period.end_date