DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on HR_TAX_UNITS_V

Line 358: cursor c6 is SELECT name from hr_tax_units_v

354: where trunc(sysdate) <=
355: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
356: and location_id = p_val;
357:
358: cursor c6 is SELECT name from hr_tax_units_v
359: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
360: = nvl(p_business_group_id,-1)
361: and trunc(sysdate)
362: between nvl(date_from,trunc(sysdate))

Line 1123: cursor c6 is SELECT tax_unit_id from hr_tax_units_v

1119: where trunc(sysdate) <=
1120: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
1121: and location_code = p_meaning ;
1122:
1123: cursor c6 is SELECT tax_unit_id from hr_tax_units_v
1124: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1125: = nvl(p_business_group_id,-1)
1126: and trunc(sysdate)
1127: between nvl(date_from,trunc(sysdate))