DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PER_TIME_PERIODS

Line 964: -- from per_time_periods

960: -- CURSOR csr_get_time_periods is
961: -- select start_date,
962: -- end_date,
963: -- period_num
964: -- from per_time_periods
965: -- where to_char(end_date,'YYYY') =
966: -- to_char(p_first_p_end_date,'YYYY')
967: -- and end_date <= p_accrual_calc_p_end_date
968: -- and period_num >= p_first_calc_P_number

Line 976: from per_time_periods

972: CURSOR csr_get_time_periods is
973: select start_date,
974: end_date,
975: period_num
976: from per_time_periods
977: where to_char(end_date,'YYYY') =
978: to_char(p_accrual_calc_p_end_date,'YYYY')
979: and end_date <= p_accrual_calc_p_end_date
980: and period_num >=