DBA Data[Home] [Help]

APPS.IBY_ASSIGN_PUB dependencies on IBY_PAYMENT_PROFILES

Line 2053: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE := -1;

2049: IS
2050: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
2051: '.getProfileFromPayeeFormat';
2052:
2053: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE := -1;
2054:
2055: BEGIN
2056:
2057: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN

Line 2071: IBY_PAYMENT_PROFILES prof,

2067: NVL(prof.payment_profile_id, -1)
2068: INTO
2069: l_profile_id
2070: FROM
2071: IBY_PAYMENT_PROFILES prof,
2072: IBY_EXTERNAL_PAYEES_ALL payee
2073: WHERE
2074: payee.ext_payee_id = ext_payee_id AND
2075: prof.payment_format_code = payee.payment_format_code