APPS.PAY_NO_TAX_LEVY dependencies on DUAL

Line 134: select to_char(l_effective_date,'RRRR') from dual;

130: and action_context_id = pactid;
131:
132: --cursor to get the bimonth year
133: cursor csr_bimonth_year is
134: select to_char(l_effective_date,'RRRR') from dual;
135:
136:
137: BEGIN
138: IF g_debug THEN

Line 340: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;

336: ORDER BY assact.assignment_id ;
337:
338: --to get the next action_id
339: cursor csr_actid is
340: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;
341: ---------------------------------------------------------------------------------------------------------------
342: l_count NUMBER := 0;
343: l_action_info_id NUMBER;
344: l_ovn NUMBER;

Line 379: ||to_char(l_effective_date,'YY'),'MONYY') into l_start_date from dual;

375:
376: -- get the period start and end dates
377:
378: select to_date(decode(l_bimonth_term,'01','JAN','02','MAR','03','MAY','04','JUL','05','SEP','06','NOV','00','JAN')
379: ||to_char(l_effective_date,'YY'),'MONYY') into l_start_date from dual;
380:
381: IF l_bimonth_term IS NOT NULL AND l_bimonth_term <> '00' THEN
382:
383: select last_day(to_date(decode(l_bimonth_term,'01','FEB','02','APR','03','JUN','04','AUG','05','OCT','06','DEC','DEC')

Line 384: ||to_char(l_effective_date,'YY'),'MONYY')) into l_end_date from dual;

380:
381: IF l_bimonth_term IS NOT NULL AND l_bimonth_term <> '00' THEN
382:
383: select last_day(to_date(decode(l_bimonth_term,'01','FEB','02','APR','03','JUN','04','AUG','05','OCT','06','DEC','DEC')
384: ||to_char(l_effective_date,'YY'),'MONYY')) into l_end_date from dual;
385: ELSE
386: l_end_date := l_effective_date;
387:
388: END IF;

Line 599: from dual;

595: cursor csr_tax_dedn_basis is
596: select
597: pay_balance_pkg.get_value(pay_no_emp_cont.get_defined_balance_id('Tax Deduction Basis','_ASG_PTD'),
598: l_main_asg_act_id)
599: from dual;
600:
601: -- Variable declaration
602:
603: l_action_info_id NUMBER;