APPS.PAY_GB_MOVDED_EDI dependencies on PER_ASSIGNMENTS_F

Line 294: per_assignments_f asg,

290:
291: cursor csr_asg is
292: select asg.assignment_id
293: from per_all_people_f pap,
294: per_assignments_f asg,
295: per_periods_of_service serv,
296: pay_all_payrolls_f pay,
297: hr_soft_coding_keyflex sck
298: where pap.person_id between stperson and endperson

Line 630: per_assignments_f asg

626: asg.assignment_id,
627: asg.effective_start_date,
628: asg.effective_end_date
629: from pay_assignment_actions paa,
630: per_assignments_f asg
631: where paa.assignment_action_id = p_assactid
632: and paa.assignment_id = asg.assignment_id
633: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
634:

Line 907: per_assignments_f paa,

903: pap.sex,
904: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
905: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
906: from pay_assignment_actions act,
907: per_assignments_f paa,
908: per_people_f pap,
909: per_periods_of_service serv
910: where act.assignment_action_id = p_assactid
911: and act.assignment_id = paa.assignment_id

Line 921: per_assignments_f paa,

917:
918: cursor csr_job is
919: select pay_get_job_segment_pkg.get_job_segment(paa.business_group_id,job.job_definition_id,act.payroll_action_id) job
920: from pay_assignment_actions act,
921: per_assignments_f paa,
922: per_jobs job
923: where act.assignment_action_id = p_assactid
924: and act.assignment_id = paa.assignment_id
925: and paa.job_id = job.job_id(+)