APPS.IBY_PAYINSTR_PUB dependencies on IBY_ACCT_PMT_PROFILES_B

Line 716: || 'IBY_ACCT_PMT_PROFILES_B appf, '

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 '
720: || 'WHERE '

Line 2751: l_payment_profile_code IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;

2747: )
2748: IS
2749:
2750: l_grouping_mode varchar2(40);
2751: l_payment_profile_code IBY_ACCT_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
2752: select_clause VARCHAR(4000);
2753: into_clause VARCHAR(4000);
2754: from_clause VARCHAR(4000);
2755: where_clause VARCHAR(4000);

Line 2844: , IBY_ACCT_PMT_PROFILES_B actprf

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:
2848: print_debuginfo(l_module_name, 'Instruction: '