APPS.PAY_BF_EXPC dependencies on DUAL

Line 67: from dual;

63: + decode(sign( p_user_effective_date - to_date('06-04-'
64: || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
65: -1,-1,0)),'DD-MM-YYYY')
66: into l_tax_year_start
67: from dual;
68: */
69: Select to_date('06-04-' || to_char( to_number(
70: to_char( PTP.regular_payment_date,'YYYY'))
71: + decode(sign( PTP.regular_payment_date - to_date('06-04-'

Line 127: from dual;

123: + decode(sign( p_user_effective_date - to_date('06-04-'
124: || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
125: -1,-1,0)),'DD-MM-YYYY')
126: into l_tax_year_start
127: from dual;
128: */
129:
130: Select to_date('06-04-' || to_char( to_number(
131: to_char( PTP.regular_payment_date,'YYYY'))

Line 356: from dual;

352: + decode(sign( p_user_effective_date - to_date('06-04-'
353: || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
354: -1,-1,0)),'DD-MM-YYYY')
355: into l_tax_year_start
356: from dual;
357: if p_owner_effective_date >= l_tax_year_start then
358: p_expiry_information := 0;
359: else
360: p_expiry_information := 1;