DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_PAYMENT_TYPES

Line 85: pay_payment_types ppt

81: pay_pre_payments ppp,
82: pay_org_payment_methods_f OPM,
83: per_all_people_f pap,
84: hr_soft_coding_keyflex hsk,
85: pay_payment_types ppt
86:
87: WHERE pa1.payroll_action_id = p_payroll_action_id
88: AND pa2.payroll_id = NVL(p_payroll_id,pa2.payroll_id)
89: AND pa2.effective_date <= pa1.effective_date

Line 239: pay_payment_types ppt,

235:
236: cursor c_get_enterprise_number is
237: select pop.pmeth_information1
238: from pay_org_payment_methods_f pop,
239: pay_payment_types ppt,
240: pay_org_pay_method_usages_f ppu,
241: pay_payroll_actions ppa
242:
243: where ppt.payment_type_id=pop.payment_type_id

Line 821: pay_payment_types ppt,

817:
818: select pop.ORG_PAYMENT_METHOD_ID
819: into l_org_pay_method_id
820: from pay_org_payment_methods_f pop,
821: pay_payment_types ppt,
822: pay_org_pay_method_usages_f ppu
823:
824: where ppt.payment_type_id=pop.payment_type_id
825: and ppt.category in ('MT')