DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PER_ALL_ASSIGNMENTS_F

Line 3232: per_all_assignments_f paf,

3228: paf.assignment_number emp_no,
3229: peo.national_identifier ni_no
3230: from pay_payroll_actions pay,
3231: pay_assignment_actions paa,
3232: per_all_assignments_f paf,
3233: per_all_people_f peo
3234: where pay.payroll_action_id = pactid
3235: and paa.payroll_action_id = pay.payroll_action_id
3236: and paa.action_status = 'E'

Line 3254: per_all_assignments_f paf,

3250: upper(paf.assignment_number) emp_no,
3251: upper(peo.national_identifier) ni_no
3252: from pay_payroll_actions pay,
3253: pay_assignment_actions paa,
3254: per_all_assignments_f paf,
3255: per_all_people_f peo
3256: where pay.payroll_action_id = pactid
3257: and paa.payroll_action_id = pay.payroll_action_id
3258: and paa.action_status = 'C'