APPS.BEN_BATCH_UTILS dependencies on PER_ASSIGNMENTS_F

Line 1497: From per_assignments_f paf

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

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

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

Line 2392: From per_assignments_f paf

2388: ,p_err_message in out nocopy varchar2 ) as
2389:
2390: Cursor c1 is
2391: Select assignment_id
2392: From per_assignments_f paf
2393: Where paf.person_id = p_person_id
2394: and paf.assignment_type <> 'C'
2395: And paf.primary_flag = 'Y'
2396: And paf.business_group_id = p_business_group_id

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

2415: Begin
2416: hr_utility.set_location ('Entering '||l_proc,10);
2417: l_flag := true;
2418: --
2419: -- Get assignment ID form per_assignments_f table.
2420: --
2421: l_actn := 'Opening Assignment cursor...';
2422: --
2423: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'