DBA Data[Home] [Help]

APPS.PAY_US_EMP_PAYSLIP_ACCRUAL_WEB dependencies on PER_TIME_PERIOD_TYPES

Line 99: from per_time_period_types ptpt,

95: select start_date,
96: end_date,
97: period_num,
98: ptpt.number_per_fiscal_year
99: from per_time_period_types ptpt,
100: per_time_periods ptp
101: where ptpt.period_type = ptp.period_type
102: and ptp.payroll_id = cp_payroll_id
103: and cp_effective_date between ptp.start_date