DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on PER_TIME_PERIODS

Line 121: from per_time_periods

117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */
118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
119:
120: -- ')' DISPLAY_PERIOD
121: from per_time_periods
122: where payroll_id = p_payroll_id
123: and p_effective_date between start_date and end_date;
124:
125:

Line 325: per_time_periods PERIOD

321: select 'Y'
322: from pay_run_results RESULT,
323: pay_assignment_actions ASGT_ACTION,
324: pay_payroll_actions PAY_ACTION,
325: per_time_periods PERIOD
326: where result.source_id = nvl (p_original_entry_id, p_element_entry_id)
327: and result.status <> 'U'
328: and result.source_type = 'E'
329: and result.assignment_action_id = asgt_action.assignment_action_id

Line 351: per_time_periods period

347: from pay_element_entries_f oee,
348: pay_element_entries_f ree,
349: pay_assignment_actions paa,
350: pay_payroll_actions pac,
351: per_time_periods period
352: where oee.element_entry_id = p_element_entry_id
353: and p_effective_date between oee.effective_start_date
354: and oee.effective_end_date
355: and p_effective_date between period.start_date and period.end_date