APPS.HR_GBNIDIR dependencies on DUAL

Line 1057: from dual;

1053: + decode(sign( l_effective_date - to_date('06-04-'
1054: || to_char(l_effective_date,'YYYY'),'DD-MM-YYYY')),
1055: -1,-1,0)),'DD-MM-YYYY') finyear
1056: into l_tax_year_start
1057: from dual;
1058: --
1059: /* has this person been a director this financial year */
1060:
1061: select nvl(min(p.effective_start_date)

Line 1078: from dual;

1074: -- calculate number of weeks of directorship
1075: select 52 - greatest(0,least(52,trunc(( l_start_of_director_date
1076: - l_tax_year_start)/7)))
1077: into l_weeks
1078: from dual;
1079: --
1080: --
1081: RETURN l_weeks;
1082: --