APPS.IBY_PAYINSTR_PUB dependencies on IBY_SYS_PMT_PROFILES_B

Line 715: || 'IBY_SYS_PMT_PROFILES_B sppf, '

711: || 'FROM '
712: || 'IBY_PAYMENTS_SEC_V pmts, '
713: || 'IBY_INSTR_CREATION_RULES icr, '
714: || 'IBY_PAY_SERVICE_REQUESTS prq, '
715: || 'IBY_SYS_PMT_PROFILES_B sppf, '
716: || 'IBY_ACCT_PMT_PROFILES_B appf, '
717: || 'HZ_PARTIES branch_party, '
718: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '
719: || 'CE_BANK_ACCOUNTS bank_accts '

Line 2762: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;

2758:
2759: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
2760: l_grp_cntr NUMBER;
2761: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
2762: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
2763:
2764: TYPE type_payment_id IS TABLE OF
2765: IBY_PAYMENTS_ALL.payment_id%TYPE
2766: INDEX BY BINARY_INTEGER;

Line 2843: FROM IBY_SYS_PMT_PROFILES_B sysprf

2839: SELECT sysprf.logical_grouping_mode
2840: , sysprf.system_profile_code
2841: INTO l_grouping_mode
2842: , l_payment_profile_code
2843: FROM IBY_SYS_PMT_PROFILES_B sysprf
2844: , IBY_ACCT_PMT_PROFILES_B actprf
2845: WHERE actprf.PAYMENT_PROFILE_ID = x_pmtInstrTab(i).payment_profile_id
2846: AND actprf.SYSTEM_PROFILE_CODE = sysprf.system_profile_code;
2847: