DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on HR_TAX_UNITS_V

Line 411: cursor c6 is SELECT name from hr_tax_units_v

407: where trunc(sysdate) <=
408: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
409: and location_id = p_val;
410:
411: cursor c6 is SELECT name from hr_tax_units_v
412: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
413: = nvl(p_business_group_id,-1)
414: and trunc(sysdate)
415: between nvl(date_from,trunc(sysdate))

Line 1176: cursor c6 is SELECT tax_unit_id from hr_tax_units_v

1172: where trunc(sysdate) <=
1173: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
1174: and location_code = p_meaning ;
1175:
1176: cursor c6 is SELECT tax_unit_id from hr_tax_units_v
1177: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
1178: = nvl(p_business_group_id,-1)
1179: and trunc(sysdate)
1180: between nvl(date_from,trunc(sysdate))