APPS.PQP_US_STUDENT_EARNINGS dependencies on PER_ASSIGNMENTS_F

Line 84: per_assignments_f paf

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
88: and per.effective_end_date

Line 134: l_assignment_id per_assignments_f.assignment_id%type;

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;
138: l_payroll_id pay_payroll_actions.payroll_id%type;

Line 367: per_assignments_f paf

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
371: and ppa.date_earned between per.effective_start_date

Line 428: per_assignments_f paf

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
432: and ppa.date_earned between per.effective_start_date

Line 475: per_assignments_f paf

471: and prr.element_type_id = :4
472: and exists
473: (select 1
474: from per_people_extra_info pei,
475: per_assignments_f paf
476: where pei.person_id = paf.person_id
477: and pei.information_type = ''PQP_OSS_PERSON_DETAILS''
478: and paf.assignment_id = paa.assignment_id)';
479:

Line 528: per_assignments_f paf

524: )
525: and exists
526: (select 1
527: from per_people_extra_info pei,
528: per_assignments_f paf
529: where pei.person_id = paf.person_id
530: and pei.information_type = ''PQP_OSS_PERSON_DETAILS''
531: and paf.assignment_id = paa.assignment_id)';
532: open pri_cur for l_selcrs

Line 570: per_assignments_f paf

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
574: and ppa.date_earned between per.effective_start_date

Line 635: per_assignments_f paf

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
639: and ppa.date_earned between per.effective_start_date