DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on HR_H2PI_PAYMENT_METHODS

Line 329: elsif upper(csr_rec.table_name) = 'HR_H2PI_PAYMENT_METHODS' then

325: null;
326: WHEN OTHERS THEN
327: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
328: END;
329: elsif upper(csr_rec.table_name) = 'HR_H2PI_PAYMENT_METHODS' then
330: BEGIN
331: SELECT asg.assignment_number,
332: opm.org_payment_method_name
333: INTO l_assignment_number,

Line 335: FROM hr_h2pi_payment_methods ppm,

331: SELECT asg.assignment_number,
332: opm.org_payment_method_name
333: INTO l_assignment_number,
334: l_pay_method_name
335: FROM hr_h2pi_payment_methods ppm,
336: hr_h2pi_org_payment_methods opm,
337: hr_h2pi_assignments_v asg,
338: hr_h2pi_id_mapping map
339: WHERE personal_payment_method_id = csr_rec.from_id