DBA Data[Home] [Help]

APPS.PYUSEXC dependencies on PER_TIME_PERIODS

Line 72: from per_time_periods TP,

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

Line 429: from per_time_periods ptp

425:
426: cursor c_td_start_date(cp_time_definition_id number
427: ,cp_date_earned date) is
428: select ptp.start_date
429: from per_time_periods ptp
430: where ptp.time_definition_id = cp_time_definition_id
431: and cp_date_earned between ptp.start_date
432: and ptp.end_date;
433: