DBA Data[Home] [Help]

APPS.PAY_SA_CHEQUE_REPORT dependencies on PAY_PAYMENT_TYPES

Line 173: pay_payment_types pt,pay_assignment_actions paa1

169: WHERE pv2.business_group_id+0 = p_business_group_id
170: AND pv2.assignment_action_id = l_assact_id
171: AND pv2.pre_payment_id in (select ppp.pre_payment_id
172: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
173: pay_payment_types pt,pay_assignment_actions paa1
174: where lck.locking_action_id = l_assact_id
175: and lck.locked_action_id = ppp.assignment_action_id
176: and paa1.assignment_action_id = lck.locking_action_id
177: and paa1.pre_payment_id = ppp.pre_payment_id