APPS.PAY_AC_ACTION_ARCH dependencies on DUAL

Line 2202: FROM DUAL;

2198: hr_utility.trace('Addl Ele DFF Info Configured.');
2199:
2200: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2201: INTO lv_curr_pymt_eff_date
2202: FROM DUAL;
2203: --bug no 6950970 starts here
2204: OPEN get_payroll_date_earned (ln_run_assignment_action_id);
2205: FETCH get_payroll_date_earned INTO l_date_earned;
2206: CLOSE get_payroll_date_earned;

Line 2348: from dual;

2344: AND ppa.payroll_action_id = paa.payroll_action_id
2345: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
2346: ))
2347: into lv_jurisdiction_flag
2348: from dual;
2349: END IF; -- Work At Home 'N'
2350:
2351: END IF; -- ln_addnl_ele_num > 0
2352: EXIT;

Line 4541: from dual;

4537: AND ppa.payroll_action_id = paa.payroll_action_id
4538: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
4539: ))
4540: into lv_jurisdiction_flag
4541: from dual;
4542: END IF; -- Work At Home 'N'
4543:
4544: -- populating temporary plsql table
4545: --

Line 5076: from dual;

5072: AND ppa.payroll_action_id = paa.payroll_action_id
5073: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
5074: ))
5075: into lv_jurisdiction_flag
5076: from dual;
5077: END IF; -- Work at Home 'N'
5078:
5079: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5080: lv_action_category := 'AC EARNINGS';