DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_PERIODS_OF_SERVICE

Line 128: per_periods_of_service serv,

124: decode(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
125: pap.person_id
126: from per_all_people_f pap,
127: per_assignments_f asg,
128: per_periods_of_service serv,
129: pay_all_payrolls_f pay,
130: per_assignment_extra_info aei,
131: hr_soft_coding_keyflex sck
132: where pap.person_id between stperson and endperson

Line 275: per_periods_of_service serv,

271: select /*+ ORDERED */
272: asg.assignment_id assignment_id
273: from per_all_people_f pap,
274: per_assignments_f asg,
275: per_periods_of_service serv,
276: pay_all_payrolls_f pay,
277: per_assignment_extra_info aei,
278: hr_soft_coding_keyflex sck
279: where pap.person_id = l_person_id