APPS.PAY_US_GET_CUMU_PERIOD_NUM dependencies on PER_TIME_PERIOD_TYPES

Line 52: from per_time_period_types pty,

48: select ptp.period_num, ppa.payroll_id, ptp.start_date,
49: ptp.end_date,ppa.effective_date date_paid, ptp.period_type
50: into l_period_number,l_payroll_id, l_start_date,
51: l_end_date,l_date_paid, l_period_type
52: from per_time_period_types pty,
53: per_time_periods ptp,
54: pay_payroll_actions ppa
55: where ppa.payroll_action_id = p_pact_id
56: and ptp.time_period_id = ppa.time_period_id