APPS.PYZAEXC dependencies on DUAL

Line 180: from dual;

176: hr_utility.set_location('l_tax_start_day: '||to_char(l_tax_start_day),10);
177: --
178: select to_char(p_owner_effective_date,'YYYY')
179: into l_tax_year
180: from dual;
181: hr_utility.set_location('l_tax_year: '||to_char(l_tax_year),20);
182:
183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')

Line 186: FROM dual;

182:
183: --
184: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
185: INTO l_tax_year_start_date
186: FROM dual;
187: hr_utility.set_location('l_tax_year_start_date: '||to_char(l_tax_year_start_date),30);
188: --
189: SELECT (add_months(l_tax_year_start_date,
190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)

Line 192: from dual;

188: --
189: SELECT (add_months(l_tax_year_start_date,
190: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 12) + 1) * 12) -1)
191: INTO p_expiry_information
192: from dual;
193:
194: hr_utility.set_location('p_expiry_information: '||to_char(p_expiry_information),40);
195: --hr_utility.trace_off;
196: --

Line 331: from dual;

327: is
328: begin
329: SELECT (trunc(add_months(p_owner_effective_date,12),'Y')-1)
330: INTO p_expiry_information
331: from dual;
332: END ASG_CAL_YTD_EC;
333: --
334: --------------------------------- ASG_TAX_QTD_EC --------------------------------------
335: -- NAME

Line 483: from dual;

479: and rule_type = 'L';
480: --
481: select to_char(p_owner_effective_date,'YYYY')
482: into l_tax_year
483: from dual;
484: --
485: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
486: INTO l_tax_year_start_date
487: FROM dual;

Line 487: FROM dual;

483: from dual;
484: --
485: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
486: INTO l_tax_year_start_date
487: FROM dual;
488: --
489: SELECT (add_months(l_tax_year_start_date,
490: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 3) + 1) * 3) -1 )
491: INTO p_expiry_information

Line 492: FROM dual;

488: --
489: SELECT (add_months(l_tax_year_start_date,
490: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 3) + 1) * 3) -1 )
491: INTO p_expiry_information
492: FROM dual;
493: --
494: end ASG_TAX_QTD_EC;
495: --
496: --------------------------------- ASG_MTD_EC --------------------------------------

Line 631: FROM dual;

627: begin
628: --
629: SELECT ((trunc(add_months(p_owner_effective_date,1),'MM'))-1)
630: INTO p_expiry_information
631: FROM dual;
632: --
633: end ASG_MTD_EC;
634: --
635: --------------------------------- ASG_PTD_EC --------------------------------------