DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PER_ADDRESSES

Line 178: FROM per_addresses pad

174: AND ppp.org_payment_method_id = opm.org_payment_method_id
175: AND ppt.payment_type_id= opm.payment_type_id
176: AND ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
177: AND (ppt.category not in ('MT') and not exists ( select '1'
178: FROM per_addresses pad
179: WHERE pad.person_id = asg.person_id
180: and pad.PRIMARY_FLAG ='Y')
181: )
182: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL

Line 311: per_addresses pad,

307: pay_payroll_actions ppa,
308: pay_pre_payments ppp,
309: pay_org_payment_methods_f pop,
310: per_all_people_f pef,
311: per_addresses pad,
312: pay_external_accounts pea,
313: hr_soft_coding_keyflex hsk,
314: pay_payment_types ppt
315: