eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYINSTR_PUB dependencies on IBY_PMT_LOGICAL_GRP_RULES

Line 3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;

3088: iby_payments_all.org_id%TYPE
3089: INDEX BY BINARY_INTEGER;
3090: t_org_id type_org_id;
3091:
3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;

Line 3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;

3089: INDEX BY BINARY_INTEGER;
3090: t_org_id type_org_id;
3091:
3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:

Line 3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;

3090: t_org_id type_org_id;
3091:
3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */

Line 3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;

3091:
3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */
3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;

Line 3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;

3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
3093: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
3094: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */
3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;
3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;

Line 3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;

3095: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */
3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;
3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;
3101: l_group_by_payment_function iby_pmt_logical_grp_rules.group_by_payment_function%TYPE;
3102:
3103: /* Added as part of SEPA Changes v5.5 Bug 12801608*/

Line 3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;

3096: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */
3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;
3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;
3101: l_group_by_payment_function iby_pmt_logical_grp_rules.group_by_payment_function%TYPE;
3102:
3103: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3104: l_group_by_delivery_channel iby_pmt_logical_grp_rules.group_by_delivery_channel%type;

Line 3101: l_group_by_payment_function iby_pmt_logical_grp_rules.group_by_payment_function%TYPE;

3097:
3098: /*Added as part of SEPA Changes Bug 9437357 */
3099: l_group_by_payment_currency iby_pmt_logical_grp_rules.group_by_payment_currency%TYPE;
3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;
3101: l_group_by_payment_function iby_pmt_logical_grp_rules.group_by_payment_function%TYPE;
3102:
3103: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3104: l_group_by_delivery_channel iby_pmt_logical_grp_rules.group_by_delivery_channel%type;
3105: /* End of SEPA Changes v5.5 Bug 12801608*/

Line 3104: l_group_by_delivery_channel iby_pmt_logical_grp_rules.group_by_delivery_channel%type;

3100: l_group_by_settlement_priority iby_pmt_logical_grp_rules.group_by_settlement_priority%TYPE;
3101: l_group_by_payment_function iby_pmt_logical_grp_rules.group_by_payment_function%TYPE;
3102:
3103: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3104: l_group_by_delivery_channel iby_pmt_logical_grp_rules.group_by_delivery_channel%type;
3105: /* End of SEPA Changes v5.5 Bug 12801608*/
3106:
3107: l_first_group_by VARCHAR2(1);
3108:

Line 3231: FROM IBY_PMT_LOGICAL_GRP_RULES

3227: l_group_by_payment_currency,
3228: l_group_by_settlement_priority,
3229: l_group_by_payment_function,
3230: l_group_by_delivery_channel
3231: FROM IBY_PMT_LOGICAL_GRP_RULES
3232: WHERE SYSTEM_PROFILE_CODE = l_payment_profile_code;
3233:
3234: from_clause :=' FROM IBY_PAYMENTS_ALL';
3235: order_clause := ' ORDER BY ';