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 341: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;

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

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

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

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

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

Line 601: from dual;

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