DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PER_PERIODS_OF_SERVICE

Line 364: per_periods_of_service serv,

360: cursor csr_asg is
361: select /*+ ordered index(ASG PER_ASSIGNMENTS_F_N12) */ asg.assignment_id
362: from per_all_people_f pap,
363: per_assignments_f asg,
364: per_periods_of_service serv,
365: pay_all_payrolls_f pay,
366: hr_soft_coding_keyflex sck
367: where pap.person_id between stperson and endperson
368: and pap.current_employee_flag = 'Y'

Line 1104: per_periods_of_service serv

1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,
1104: per_periods_of_service serv
1105: where act.assignment_action_id = p_assactid
1106: and act.assignment_id = paa.assignment_id
1107: and paa.person_id = pap.person_id
1108: and paa.period_of_service_id = serv.period_of_service_id