APPS.HR_GBNIDIR dependencies on DUAL

Line 1133: from dual;

1129: + decode(sign( l_effective_date - to_date('06-04-'
1130: || to_char(l_effective_date,'YYYY'),'DD-MM-YYYY')),
1131: -1,-1,0)),'DD-MM-YYYY') finyear
1132: into l_tax_year_start
1133: from dual;
1134: --
1135: /* has this person been a director this financial year */
1136:
1137: select nvl(min(p.effective_start_date)

Line 1154: from dual;

1150: -- calculate number of weeks of directorship
1151: select 52 - greatest(0,least(52,trunc(( l_start_of_director_date
1152: - l_tax_year_start)/7)))
1153: into l_weeks
1154: from dual;
1155: --
1156: --
1157: RETURN l_weeks;
1158: --