APPS.IBY_PAYINSTR_PUB dependencies on IBY_SYS_PMT_PROFILES_B

Line 830: || 'IBY_SYS_PMT_PROFILES_B sppf, '

826: || 'FROM '
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 '

Line 3022: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;

3018:
3019: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
3020: l_grp_cntr NUMBER;
3021: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
3022: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
3023:
3024: TYPE type_payment_id IS TABLE OF
3025: IBY_PAYMENTS_ALL.payment_id%TYPE
3026: INDEX BY BINARY_INTEGER;

Line 3149: FROM IBY_SYS_PMT_PROFILES_B sysprf

3145: SELECT sysprf.logical_grouping_mode
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: