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 332: from dual; */

328: begin
329: /* Commented for Bug 8624178
330: SELECT (trunc(add_months(p_owner_effective_date,12),'Y')-1)
331: INTO p_expiry_information
332: from dual; */
333:
334: SELECT max(ptpp.pay_advice_date)
335: INTO p_expiry_information
336: FROM pay_payroll_actions ppa

Line 495: from dual;

491: and rule_type = 'L';
492: --
493: select to_char(p_owner_effective_date,'YYYY')
494: into l_tax_year
495: from dual;
496: --
497: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
498: INTO l_tax_year_start_date
499: FROM dual;

Line 499: FROM dual;

495: from dual;
496: --
497: SELECT to_date(l_tax_start_day||'-'||l_tax_year,'DD/MM/YYYY')
498: INTO l_tax_year_start_date
499: FROM dual;
500: --
501: SELECT (add_months(l_tax_year_start_date,
502: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 3) + 1) * 3) -1 )
503: INTO p_expiry_information

Line 504: FROM dual;

500: --
501: SELECT (add_months(l_tax_year_start_date,
502: (floor(months_between(p_owner_effective_date, l_tax_year_start_date) / 3) + 1) * 3) -1 )
503: INTO p_expiry_information
504: FROM dual;
505: --
506: end ASG_TAX_QTD_EC;
507: --
508: --------------------------------- ASG_MTD_EC --------------------------------------

Line 644: FROM dual;

640: --
641: /* Commented for Bug 8624178
642: SELECT ((trunc(add_months(p_owner_effective_date,1),'MM'))-1)
643: INTO p_expiry_information
644: FROM dual;
645: */
646:
647: SELECT ptp.pay_advice_date
648: INTO p_expiry_information