APPS.PQP_US_STUDENT_EARNINGS dependencies on PER_PEOPLE_F

Line 83: from per_people_f per,

79: -- To Get the party id of the person as of the date or award earnings
80: cursor c_party_id (c_asssignment_id in number
81: ,c_effective_date in date) Is
82: select per.party_id
83: from per_people_f per,
84: per_assignments_f paf
85: where per.person_id = paf.person_id
86: and paf.assignment_id = c_asssignment_id
87: and c_effective_date between per.effective_start_date

Line 131: l_grp_party_id per_people_f.party_id%type := null;

127: l_st_date date;
128: l_end_date date;
129: l_date_earned date;
130: -- Type declarations variables
131: l_grp_party_id per_people_f.party_id%type := null;
132: l_chk_grp_party_id per_people_f.party_id%type := null;
133: l_ssn per_people_f.national_identifier%type := null;
134: l_assignment_id per_assignments_f.assignment_id%type;
135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 132: l_chk_grp_party_id per_people_f.party_id%type := null;

128: l_end_date date;
129: l_date_earned date;
130: -- Type declarations variables
131: l_grp_party_id per_people_f.party_id%type := null;
132: l_chk_grp_party_id per_people_f.party_id%type := null;
133: l_ssn per_people_f.national_identifier%type := null;
134: l_assignment_id per_assignments_f.assignment_id%type;
135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
136: l_element_type_id pay_element_types_f.element_type_id%type;

Line 133: l_ssn per_people_f.national_identifier%type := null;

129: l_date_earned date;
130: -- Type declarations variables
131: l_grp_party_id per_people_f.party_id%type := null;
132: l_chk_grp_party_id per_people_f.party_id%type := null;
133: l_ssn per_people_f.national_identifier%type := null;
134: l_assignment_id per_assignments_f.assignment_id%type;
135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
136: l_element_type_id pay_element_types_f.element_type_id%type;
137: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

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

141:
142: -- =======================================================================
143: -- Function to dynamically generate the the sql to get the person ids for
144: -- the given person group id. Please note that these person ids are not
145: -- same as per_people_f person_id instead these belong to student system.
146: -- =======================================================================
147: function get_person_id
148: (p_group_id in number) return varchar2 is
149: plsql_block varchar2(2000);

Line 366: per_people_f per ,

362: and prr.element_type_id = '|| p_element_type_id ||'
363: and exists
364: (select 1
365: from per_people_extra_info pei,
366: per_people_f per ,
367: per_assignments_f paf
368: where pei.person_id = per.person_id
369: and paf.person_id = per.person_id
370: and paf.assignment_id = paa.assignment_id

Line 427: per_people_f per ,

423: )
424: and exists
425: (select 1
426: from per_people_extra_info pei,
427: per_people_f per ,
428: per_assignments_f paf
429: where pei.person_id = per.person_id
430: and paf.person_id = per.person_id
431: and paf.assignment_id = paa.assignment_id

Line 569: per_people_f per ,

565: and prr.element_type_id = :4
566: and exists
567: (select 1
568: from per_people_extra_info pei,
569: per_people_f per ,
570: per_assignments_f paf
571: where pei.person_id = per.person_id
572: and paf.person_id = per.person_id
573: and paf.assignment_id = paa.assignment_id

Line 634: per_people_f per ,

630: )
631: and exists
632: (select 1
633: from per_people_extra_info pei,
634: per_people_f per ,
635: per_assignments_f paf
636: where pei.person_id = per.person_id
637: and paf.person_id = per.person_id
638: and paf.assignment_id = paa.assignment_id