eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_MOVDED_EDI dependencies on PER_ALL_PEOPLE_F

Line 362: from per_all_people_f pap,

358:
359: -- Bug 8574855 : Added hint PER_ASSIGNMENTS_F_N12 for tuning the query.
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

Line 3233: per_all_people_f peo

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'
3237: and paf.assignment_id = paa.assignment_id

Line 3255: per_all_people_f peo

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'
3259: and paf.assignment_id = paa.assignment_id