DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PER_ASSIGNMENTS_F

Line 122: per_assignments_f asg,

118: asg.assignment_id assignment_id,
119: decode(pap.per_information10,'Y','Y',NULL) agg_paye_flag,
120: pap.person_id
121: from per_all_people_f pap,
122: per_assignments_f asg,
123: per_periods_of_service serv,
124: pay_all_payrolls_f pay,
125: per_assignment_extra_info aei,
126: hr_soft_coding_keyflex sck

Line 269: per_assignments_f asg,

265: cursor asg_act is
266: select /*+ ORDERED */
267: asg.assignment_id assignment_id
268: from per_all_people_f pap,
269: per_assignments_f asg,
270: per_periods_of_service serv,
271: pay_all_payrolls_f pay,
272: per_assignment_extra_info aei,
273: hr_soft_coding_keyflex sck

Line 347: per_assignments_f paa,

343: paa.ASSIGNMENT_NUMBER,
344: pap.national_identifier,
345: paa.assignment_id
346: from pay_assignment_actions pact,
347: per_assignments_f paa,
348: per_people_f pap
349: where pact.assignment_action_id = p_assactid
350: and pact.assignment_id = paa.assignment_id
351: and paa.person_id = pap.person_id