DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_PAYMENT_TYPES

Line 86: pay_payment_types ppt

82: pay_pre_payments ppp,
83: pay_org_payment_methods_f OPM,
84: per_all_people_f pap,
85: -- hr_soft_coding_keyflex hsk,
86: pay_payment_types ppt
87:
88: WHERE pa1.payroll_action_id = p_payroll_action_id
89: AND pa2.payroll_id = p_payroll_id
90: -- and asg.payroll_id = p_payroll_id

Line 255: pay_payment_types ppt,

251: /*
252: cursor c_get_enterprise_number is
253: select pop.pmeth_information1
254: from pay_org_payment_methods_f pop,
255: pay_payment_types ppt,
256: pay_org_pay_method_usages_f ppu,
257: pay_payroll_actions ppa
258:
259: where ppt.payment_type_id=pop.payment_type_id

Line 844: pay_payment_types ppt,

840:
841: select pop.ORG_PAYMENT_METHOD_ID
842: into l_org_pay_method_id
843: from pay_org_payment_methods_f pop,
844: pay_payment_types ppt,
845: pay_org_pay_method_usages_f ppu
846:
847: where pop.pmeth_information_category <> 'NO_THIRD_PARTY_PAYMENT'
848: and ppt.payment_type_id=pop.payment_type_id