DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_ASSIGNMENTS_F

Line 127: per_assignments_f asg,

123: asg.assignment_id assignment_id,
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

Line 274: per_assignments_f asg,

270: cursor asg_act is
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

Line 352: per_assignments_f paa,

348: paa.ASSIGNMENT_NUMBER,
349: pap.national_identifier,
350: paa.assignment_id
351: from pay_assignment_actions pact,
352: per_assignments_f paa,
353: per_people_f pap
354: where pact.assignment_action_id = p_assactid
355: and pact.assignment_id = paa.assignment_id
356: and paa.person_id = pap.person_id