APPS.IBY_PAYINSTR_PUB dependencies on IBY_ACCT_PMT_PROFILES_B

Line 831: || 'IBY_ACCT_PMT_PROFILES_B appf, '

827: || 'IBY_PAYMENTS_SEC_V pmts, '
828: || 'IBY_INSTR_CREATION_RULES icr, '
829: || 'IBY_PAY_SERVICE_REQUESTS prq, '
830: || 'IBY_SYS_PMT_PROFILES_B sppf, '
831: || 'IBY_ACCT_PMT_PROFILES_B appf, '
832: || 'HZ_PARTIES branch_party, '
833: || 'HZ_CODE_ASSIGNMENTS rfc_ca, '
834: || 'CE_BANK_ACCOUNTS bank_accts '
835: || 'WHERE '

Line 3011: l_payment_profile_code IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;

3007: )
3008: IS
3009:
3010: l_grouping_mode varchar2(40);
3011: l_payment_profile_code IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
3012: select_clause VARCHAR(4000);
3013: into_clause VARCHAR(4000);
3014: from_clause VARCHAR(4000);
3015: where_clause VARCHAR(4000);

Line 3150: , IBY_ACCT_PMT_PROFILES_B actprf

3146: , sysprf.system_profile_code
3147: INTO l_grouping_mode
3148: , l_payment_profile_code
3149: FROM IBY_SYS_PMT_PROFILES_B sysprf
3150: , IBY_ACCT_PMT_PROFILES_B actprf
3151: WHERE actprf.PAYMENT_PROFILE_ID = x_pmtInstrTab(i).payment_profile_id
3152: AND actprf.SYSTEM_PROFILE_CODE = sysprf.system_profile_code;
3153:
3154: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN