APPS.BEN_BATCH_UTILS dependencies on PER_ASSIGNMENTS_F

Line 1493: From per_assignments_f paf

1489: ,p_input1_value in varchar2 default null
1490: ) return char is
1491: Cursor c1 is
1492: Select assignment_id
1493: From per_assignments_f paf
1494: Where paf.person_id = p_person_id
1495: and paf.assignment_type <> 'C'
1496: And paf.primary_flag = 'Y'
1497: And paf.business_group_id = p_business_group_id

Line 1519: -- Get assignment ID form per_assignments_f table.

1515: l_actn varchar2(80);
1516: Begin
1517: hr_utility.set_location ('Entering '||l_proc,10);
1518: --
1519: -- Get assignment ID form per_assignments_f table.
1520: --
1521: l_actn := 'Opening Assignment cursor...';
1522: -- Perf changes
1523: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'

Line 2382: From per_assignments_f paf

2378: ,p_err_message in out nocopy varchar2 ) as
2379:
2380: Cursor c1 is
2381: Select assignment_id
2382: From per_assignments_f paf
2383: Where paf.person_id = p_person_id
2384: and paf.assignment_type <> 'C'
2385: And paf.primary_flag = 'Y'
2386: And paf.business_group_id = p_business_group_id

Line 2407: -- Get assignment ID form per_assignments_f table.

2403: value_exception exception ;
2404: Begin
2405: hr_utility.set_location ('Entering '||l_proc,10);
2406: --
2407: -- Get assignment ID form per_assignments_f table.
2408: --
2409: l_actn := 'Opening Assignment cursor...';
2410: --
2411: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'