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_NO_PAYPROC dependencies on PER_ADDRESSES

Line 198: FROM per_addresses pad

194: AND opm.pmeth_information_category <> 'NO_THIRD_PARTY_PAYMENT'
195: AND ppt.payment_type_id= opm.payment_type_id
196: AND ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
197: AND (ppt.category not in ('MT') and not exists ( select '1'
198: FROM per_addresses pad
199: WHERE pad.person_id = asg.person_id
200: and pad.PRIMARY_FLAG ='Y')
201: )
202: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL

Line 333: -- per_addresses pad,

329: pay_payroll_actions ppa,
330: pay_pre_payments ppp,
331: pay_org_payment_methods_f pop,
332: per_all_people_f pef,
333: -- per_addresses pad,
334: pay_external_accounts pea,
335: -- hr_soft_coding_keyflex hsk,
336: pay_payment_types ppt
337:

Line 347: from per_addresses pad

343: and pop.org_payment_method_id = ppp.org_payment_method_id
344: AND pop.pmeth_information_category <> 'NO_THIRD_PARTY_PAYMENT'
345: and ppt.payment_type_id= pop.payment_type_id
346: and ((ppt.payment_type_name like 'NO Money Order' and exists( select '1'
347: from per_addresses pad
348: where pad.person_id = pef.person_id
349: and pad.PRIMARY_FLAG ='Y'))
350: or ppt.category in ('MT'))
351: