DBA Data[Home] [Help]

APPS.PAY_SEED_UTL dependencies on PAY_PAYMENT_TYPES

Line 294: from pay_payment_types

290: -- Cursor to retrieve payment_type_id given name
291: CURSOR c_payment_name_id(p_payment_type_name VARCHAR2,
292: p_legislation_code VARCHAR2) IS
293: select payment_type_id
294: from pay_payment_types
295: where payment_type_name = p_payment_type_name
296: and (territory_code = p_legislation_code or
297: ( territory_code is null and p_legislation_code is null ));
298: