APPS.PAY_CA_WF_PKG dependencies on DUAL

Line 164: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

160: --hr_utility.trace_on(null,'PYWF');
161:
162: gv_package := 'pay_ca_wf_pkg';
163:
164: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
165:
166: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
167: retcode := 0;
168:

Line 427: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;

423: --hr_utility.trace_on(null,'PYWF');
424:
425: gv_package := 'pay_ca_wf_pkg';
426:
427: select to_char(sysdate,'DDHH24MISS') into l_item_key from dual;
428:
429: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
430: retcode := 0;
431:

Line 1063: into lv_date_time from dual;

1059: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
1060: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
1061:
1062: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
1063: into lv_date_time from dual;
1064:
1065:
1066: hr_utility.trace('before create_process');
1067:

Line 1347: from dual;

1343:
1344: begin
1345: select to_char(sysdate, 'HHSSSS')
1346: into lv_exp_finder_pqp
1347: from dual;
1348:
1349: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
1350:
1351: exception when no_data_found then

Line 3192: into lv_date_time from dual;

3188: hr_utility.trace('In StartProcess Item Key is : '|| ItemKey);
3189: hr_utility.trace('Workflow process name is : '|| Workflowprocess);
3190:
3191: select to_char(sysdate,'DD-MON-YYYY') ||' '|| to_char(sysdate,'HH24:MI:SS')
3192: into lv_date_time from dual;
3193:
3194:
3195: hr_utility.trace('before create_process');
3196:

Line 3483: from dual;

3479:
3480: begin
3481: select to_char(sysdate, 'HHSSSS')
3482: into lv_exp_finder_pqp
3483: from dual;
3484:
3485: hr_utility.trace('lv_exp_finder_pqp = ' || lv_exp_finder_pqp);
3486:
3487: exception when no_data_found then