DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PER_TIME_PERIODS

Line 918: -- from per_time_periods

914: -- CURSOR csr_get_time_periods is
915: -- select start_date,
916: -- end_date,
917: -- period_num
918: -- from per_time_periods
919: -- where to_char(end_date,'YYYY') =
920: -- to_char(p_first_p_end_date,'YYYY')
921: -- and end_date <= p_accrual_calc_p_end_date
922: -- and period_num >= p_first_calc_P_number

Line 930: from per_time_periods

926: CURSOR csr_get_time_periods is
927: select start_date,
928: end_date,
929: period_num
930: from per_time_periods
931: where to_char(end_date,'YYYY') =
932: to_char(p_accrual_calc_p_end_date,'YYYY')
933: and end_date <= p_accrual_calc_p_end_date
934: and period_num >=