APPS.PQP_US_STUDENT_BEE dependencies on PER_PEOPLE_F

Line 453: from per_people_f per,

449: ,c_business_group_id in number
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'

Line 510: l_person_id per_people_f.person_id%type;

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;
513: l_proc_name constant varchar2(150) :=
514: 'PQP_US_Student_BEE.Create_Student_Batch_Entry';

Line 511: l_ssn per_people_f.national_identifier%type;

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;
513: l_proc_name constant varchar2(150) :=
514: 'PQP_US_Student_BEE.Create_Student_Batch_Entry';
515:

Line 512: l_party_id per_people_f.party_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;
513: l_proc_name constant varchar2(150) :=
514: 'PQP_US_Student_BEE.Create_Student_Batch_Entry';
515:
516: -- =========================================================================

Line 519: -- as per_people_f person_id instead these belong to student system.

515:
516: -- =========================================================================
517: -- Function to dynamically generate the the sql to get the person ids for
518: -- the given person group id. Please note that these person ids are not same
519: -- as per_people_f person_id instead these belong to student system.
520: -- =========================================================================
521: function Get_Person_ID
522: (p_group_id in number
523: ) return varchar2 is

Line 616: per_people_f per

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''
620: and :1 between paf.effective_start_date

Line 663: per_people_f per

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
667: and :2 between per.effective_start_date

Line 692: from per_people_f per,

688: 'select per.national_identifier,
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