DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_REP_YEAR_CAL_V

Line 3681: FROM pa_rep_year_cal_v,

3677: ( ((NEXT_DAY(TO_DATE('01/01/'||TO_CHAR(period_Year),'MM/DD/YYYY'),
3678: TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (seq_number-1) * 7) - 6 ) start_dt,
3679: ( (NEXT_DAY(TO_DATE('01/01/'||TO_CHAR(period_Year),'MM/DD/YYYY'),
3680: TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'))) -1 ) + (seq_number-1) * 7 ) end_dt
3681: FROM pa_rep_year_cal_v,
3682: pa_rep_seq_number
3683: WHERE seq_number BETWEEN 1 AND 53
3684: )
3685: WHERE p_completion_date BETWEEN start_dt AND end_dt;