DBA Data[Home] [Help]

APPS.IBY_ASSIGN_PUB dependencies on IBY_PAYMENT_PROFILES

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

1921: IS
1922: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
1923: '.getProfileFromPayeeFormat';
1924:
1925: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE := -1;
1926:
1927: BEGIN
1928:
1929: print_debuginfo(l_module_name, 'ENTER');

Line 1941: IBY_PAYMENT_PROFILES prof,

1937: NVL(prof.payment_profile_id, -1)
1938: INTO
1939: l_profile_id
1940: FROM
1941: IBY_PAYMENT_PROFILES prof,
1942: IBY_EXTERNAL_PAYEES_ALL payee
1943: WHERE
1944: payee.ext_payee_id = ext_payee_id AND
1945: prof.payment_format_code = payee.payment_format_code