DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PER_PERIODS_OF_SERVICE

Line 295: per_periods_of_service serv,

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
299: and pap.current_employee_flag = 'Y'

Line 909: per_periods_of_service serv

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
912: and paa.person_id = pap.person_id
913: and paa.period_of_service_id = serv.period_of_service_id