DBA Data[Home] [Help]

APPS.PYUSEXC dependencies on PER_TIME_PERIODS

Line 75: from per_time_periods TP,

71: l_return_val := NULL;
72:
73: select TP.end_date + 1
74: into l_return_val
75: from per_time_periods TP,
76: pay_payroll_actions PACT
77: where PACT.payroll_action_id = p_pactid
78: and PACT.payroll_id = TP.payroll_id
79: and p_date between TP.start_date and TP.end_date;

Line 489: from per_time_periods ptp

485:
486: cursor c_td_start_date(cp_time_definition_id number
487: ,cp_date_earned date) is
488: select ptp.start_date
489: from per_time_periods ptp
490: where ptp.time_definition_id = cp_time_definition_id
491: and cp_date_earned between ptp.start_date
492: and ptp.end_date;
493: