APPS.PA_TIME_CLIENT_EXTN dependencies on DUAL

Line 77: FROM dual;

73: /** Create the batch Name **/
74:
75: SELECT To_Char(p_expenditure_ending_date,'MMDDYY')
76: INTO l_date_string
77: FROM dual;
78:
79: /** Get the next value from sequence **/
80: SELECT mod(PA_EXPENDITURE_GROUPS_S.nextval,1000)
81: INTO l_sequence_no

Line 82: FROM DUAL;

78:
79: /** Get the next value from sequence **/
80: SELECT mod(PA_EXPENDITURE_GROUPS_S.nextval,1000)
81: INTO l_sequence_no
82: FROM DUAL;
83:
84: x_user_batch_name := l_date_string||'-'||to_char(l_sequence_no);
85:
86: ELSE