475: PAY_BALANCE_PKG.SET_CONTEXT('BALANCE_DATE'
476: ,FND_DATE.DATE_TO_CANONICAL(L_END_DATE));
477: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED'
478: ,FND_DATE.DATE_TO_CANONICAL(L_END_DATE));
479: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_REPORT'
480: ,'TRUE');
481: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_SDATE'
482: ,L_START_DATE);
483: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_EDATE'
477: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED'
478: ,FND_DATE.DATE_TO_CANONICAL(L_END_DATE));
479: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_REPORT'
480: ,'TRUE');
481: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_SDATE'
482: ,L_START_DATE);
483: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_EDATE'
484: ,L_END_DATE);
485: END IF;
479: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_REPORT'
480: ,'TRUE');
481: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_SDATE'
482: ,L_START_DATE);
483: PAY_US_BALANCE_VIEW_PKG.SET_SESSION_VAR('GROUP_RB_EDATE'
484: ,L_END_DATE);
485: END IF;
486: CP_SELECT_COL1 := NULL;
487: CP_SELECT_COL2 := NULL;