APPS.PAY_ZA_EMP201 dependencies on PER_ALL_ASSIGNMENTS_F

Line 420: , per_all_assignments_f paa

416: , p_payroll_id number) is
417: select ppf.person_id
418: , paa.assignment_id
419: from per_all_people_f ppf
420: , per_all_assignments_f paa
421: , pay_payroll_actions ppa
422: , per_periods_of_service pps
423: , per_assignment_extra_info aei
424: where ppf.person_id between p_stperson and p_endperson

Line 441: from per_all_assignments_f paa1 where paa1.assignment_id = paa.assignment_id

437: and ppf1.effective_start_date <= p_canonical_end_date
438: )
439: -- last assignment record before this month end
440: and paa.effective_start_date = ( select max(paa1.effective_start_date)
441: from per_all_assignments_f paa1 where paa1.assignment_id = paa.assignment_id
442: and paa1.effective_start_date <= p_canonical_end_date
443: )
444: and
445: (

Line 628: , per_all_assignments_f a

624: ,a.period_of_service_id
625: ,a.assignment_number
626: ,a.payroll_id
627: from per_all_people_f p
628: , per_all_assignments_f a
629: , pay_assignment_actions paa
630: where paa.assignment_action_id = p_assactid
631: and a.assignment_id = paa.assignment_id
632: and p.person_id = a.person_id

Line 705: from per_all_assignments_f ass

701: --else its considered the one set at organisation level
702: cursor get_sdl_exemption (p_assignment_id number
703: , p_effective_date date) is
704: select decode(hoi.org_information1,'Exempt','E',nvl(aei.aei_information9,'N')) "Exemption"
705: from per_all_assignments_f ass
706: , hr_organization_information hoi
707: , per_assignment_extra_info aei
708: where ass.assignment_id = p_assignment_id
709: and p_effective_date between ass.effective_start_date and ass.effective_end_date

Line 809: from per_all_assignments_f paa,

805: --Returns Y is assignment is terminated, else N
806: cursor csr_check_asg_termination (p_assignment_id number
807: , p_effective_date date) is
808: select decode (past.PER_SYSTEM_STATUS, 'TERM_ASSIGN','Y','N') asg_terminated
809: from per_all_assignments_f paa,
810: per_assignment_status_types past
811: where paa.assignment_id = p_assignment_id
812: and paa.assignment_status_type_id = past.assignment_status_type_id
813: and p_effective_date between paa.effective_start_date and paa.effective_end_date ;

Line 988: from per_all_assignments_f paf,

984: if csr_asg_details%NOTFOUND then
985: hr_utility.set_location('csr_asg_details not found',10);
986: select max(effective_end_date)
987: into l_asg_end_date
988: from per_all_assignments_f paf,
989: pay_assignment_actions paa
990: where effective_end_date <= l_month_end
991: and paa.assignment_id = paf.assignment_id
992: and paa.assignment_action_id = p_assactid;