APPS.PAY_NO_PAYPROC dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 83: pay_org_payment_methods_f OPM,

79: per_all_assignments_f asg,
80: pay_payroll_actions pa2,
81: pay_payroll_actions pa1,
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:

Line 254: from pay_org_payment_methods_f pop,

250:
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:

Line 843: from pay_org_payment_methods_f pop,

839: l_seq_control := to_number(p_seq_control);
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'

Line 869: update pay_org_payment_methods_f

865: else
866: l_ah_seq := l_ah_seq + 1;
867: end if;
868:
869: update pay_org_payment_methods_f
870: set pmeth_information3=l_ah_seq , pmeth_information4=l_seq_control
871: where ORG_PAYMENT_METHOD_ID=l_org_pay_method_id;
872:
873: RETURN '1';