DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 82: pay_org_payment_methods_f OPM,

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

Line 238: from pay_org_payment_methods_f pop,

234: ,p_new_password in varchar2) return varchar2 IS
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:

Line 820: from pay_org_payment_methods_f pop,

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

Line 845: update pay_org_payment_methods_f

841: else
842: l_ah_seq := l_ah_seq + 1;
843: end if;
844:
845: update pay_org_payment_methods_f
846: set pmeth_information3=l_ah_seq , pmeth_information4=l_seq_control
847: where ORG_PAYMENT_METHOD_ID=l_org_pay_method_id;
848:
849: RETURN '1';