APPS.PAY_IN_EOY_ARCHIVE dependencies on DUAL

Line 208: FROM dual;

204: g_end_date := ADD_MONTHS(g_end_date,-12);
205:
206: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
207: INTO g_bg_id
208: FROM dual;
209:
210: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
211: --
212: EXCEPTION

Line 482: FROM dual;

478: WHERE session_id = USERENV('sessionid');
479:
480: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
481: INTO g_bg_id
482: FROM dual;
483:
484: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
485: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
486:

Line 510: FROM dual;

506: IF (l_flag = TRUE) THEN
507: pay_in_utils.set_location(g_debug,l_procedure, 50);
508: SELECT pay_assignment_actions_s.NEXTVAL
509: INTO l_action_id
510: FROM dual;
511:
512: hr_nonrun_asact.insact(lockingactid => l_action_id
513: ,assignid => csr_rec.assignment_id
514: ,pactid => p_payroll_action_id