APPS.BEN_CONC_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 557: From per_assignments_f paf

553: ,p_err_message in out nocopy varchar2 ) as
554:
555: Cursor c1 is
556: Select assignment_id
557: From per_assignments_f paf
558: Where paf.person_id = p_person_id
559: and paf.assignment_type <> 'C'
560: And paf.primary_flag = 'Y'
561: And paf.business_group_id = p_business_group_id

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

570: value_exception exception ;
571: Begin
572: hr_utility.set_location ('Entering '||l_proc,10);
573: --
574: -- Get assignment ID form per_assignments_f table.
575: --
576: l_actn := 'Opening C1 Assignment cursor...';
577: open c1;
578: fetch c1 into l_assignment_id;

Line 644: from per_assignments_f paf

640: ,p_effective_date in date
641: ) return char is
642: cursor c1 is
643: select assignment_id,organization_id
644: from per_assignments_f paf
645: where paf.person_id = p_person_id
646: and paf.assignment_type <> 'C'
647: and paf.primary_flag = 'Y'
648: and paf.business_group_id = p_business_group_id

Line 664: -- Get assignment ID,organization_id form per_assignments_f table.

660: begin
661: l_step := 10;
662: hr_utility.set_location ('Entering '||l_proc,10);
663: --
664: -- Get assignment ID,organization_id form per_assignments_f table.
665: --
666: open c1;
667: fetch c1 into l_assignment_id,l_organization_id;
668: if c1%notfound then

Line 955: from per_assignments_f asg

951: and ptu.person_type_id = g_parm.person_type_id))
952: /* person exists with specified assignment type */
953: and (g_parm.assgn_type is null
954: or exists (select null
955: from per_assignments_f asg
956: where asg.assignment_type = substr(g_parm.assgn_type,1,1)
957: and asg.person_id = pen.person_id
958: and asg.assignment_type <> 'C'
959: and asg.primary_flag = 'Y'

Line 966: from per_assignments_f asg

962: between asg.effective_start_date and asg.effective_end_date))
963: /* person exists with specified location */
964: and (g_parm.location_id is null
965: or exists (select null
966: from per_assignments_f asg
967: where asg.location_id = g_parm.location_id
968: and asg.person_id = pen.person_id
969: and asg.assignment_type <> 'C'
970: and asg.primary_flag = 'Y'

Line 1133: from per_assignments_f asg

1129: and ptu.person_type_id = g_parm.person_type_id))
1130: /* person exists with specified assignment type */
1131: and (g_parm.assgn_type is null
1132: or exists (select null
1133: from per_assignments_f asg
1134: where asg.assignment_type = substr(g_parm.assgn_type,1,1)
1135: and asg.person_id = pil.person_id
1136: and asg.assignment_type <> 'C'
1137: and asg.primary_flag = 'Y'