APPS.PAY_ZA_EOY_VAL dependencies on DUAL

Line 46: -- if the result is greater than 9, add the individual digits to get

42: end if;
43:
44: -- otherwise do not replace the first digit
45: -- Multiply the first number and thereafter every second number by 2
46: -- if the result is greater than 9, add the individual digits to get
47: -- the final answer
48:
49: n1 := 2 * substr(tax_no,1,1);
50: if n1 > 9 then

Line 146: -- if the result is greater than 9, add the individual digits to get

142: end if;
143:
144: -- otherwise do not replace the first digit
145: -- Multiply the first number and thereafter every second number by 2
146: -- if the result is greater than 9, add the individual digits to get
147: -- the final answer
148:
149: n1 := 2 * substr(tax_no,1,1);
150: if n1 > 9 then

Line 3284: from dual;

3280:
3281:
3282: select last_day(decode(P_PERIOD_RECON, '02', to_date(P_TAX_YEAR||'-02-01','yyyy-mm-dd'), '08', to_date(P_TAX_YEAR-1 ||'-08-01','yyyy-mm-dd')))
3283: into l_period_recon_last_date
3284: from dual;
3285:
3286: open csr_employee for l_sql using p_payroll_id, p_business_group_id,p_legal_entity, p_legal_entity,
3287: p_cert_type,p_cert_type,p_tax_year,p_period_recon,l_period_recon_last_date,p_tax_year_end,p_tax_year_end,p_tax_year_end,
3288: p_person_id;