APPS.PQP_US_STUDENT_BEE dependencies on PER_ASSIGNMENTS_F

Line 454: per_assignments_f paf

450: ,c_effective_date in date) is
451: select paf.assignment_id,
452: paf.assignment_number
453: from per_people_f per,
454: per_assignments_f paf
455: where per.national_identifier = c_ssn
456: and paf.assignment_type = 'E'
457: and paf.primary_flag = 'Y'
458: and c_effective_date between per.effective_start_date

Line 507: l_assignment_id per_assignments_f.assignment_id%type;

503: l_end_date date;
504: l_effective_date date;
505:
506: -- Type casted variables
507: l_assignment_id per_assignments_f.assignment_id%type;
508: l_assignment_number per_assignments_f.assignment_number%type;
509: l_element_name pay_element_types_f.element_name%type;
510: l_person_id per_people_f.person_id%type;
511: l_ssn per_people_f.national_identifier%type;

Line 508: l_assignment_number per_assignments_f.assignment_number%type;

504: l_effective_date date;
505:
506: -- Type casted variables
507: l_assignment_id per_assignments_f.assignment_id%type;
508: l_assignment_number per_assignments_f.assignment_number%type;
509: l_element_name pay_element_types_f.element_name%type;
510: l_person_id per_people_f.person_id%type;
511: l_ssn per_people_f.national_identifier%type;
512: l_party_id per_people_f.party_id%type;

Line 615: from per_assignments_f paf,

611: 'select per.national_identifier,
612: paf.assignment_id,
613: paf.assignment_number,
614: per.party_id
615: from per_assignments_f paf,
616: per_people_f per
617: where paf.person_id = per.person_id
618: and paf.assignment_type =''E''
619: and paf.primary_flag=''Y''

Line 662: from per_assignments_f paf,

658: 'select per.national_identifier,
659: paf.assignment_id,
660: paf.assignment_number,
661: per.party_id
662: from per_assignments_f paf,
663: per_people_f per
664: where paf.person_id = per.person_id
665: and :1 between paf.effective_start_date
666: and paf.effective_end_date

Line 693: per_assignments_f paf

689: paf.assignment_id,
690: paf.assignment_number,
691: per.party_id
692: from per_people_f per,
693: per_assignments_f paf
694: where per.national_identifier = :1
695: and :2 between per.effective_start_date
696: and per.effective_end_date
697: and paf.person_id = per.person_id