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 2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;

2810: iby_payments_all.org_id%TYPE
2811: INDEX BY BINARY_INTEGER;
2812: t_org_id type_org_id;
2813:
2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;

Line 2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;

2811: INDEX BY BINARY_INTEGER;
2812: t_org_id type_org_id;
2813:
2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
2819:

Line 2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;

2812: t_org_id type_org_id;
2813:
2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
2819:
2820: l_first_group_by VARCHAR2(1);

Line 2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;

2813:
2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
2819:
2820: l_first_group_by VARCHAR2(1);
2821:

Line 2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;

2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;
2815: l_group_by_payment_method iby_pmt_logical_grp_rules.group_by_payment_method%TYPE;
2816: l_group_by_payment_date iby_pmt_logical_grp_rules.group_by_payment_date%TYPE;
2817: l_group_by_internal_bank_acct iby_pmt_logical_grp_rules.group_by_internal_bank_account%TYPE;
2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
2819:
2820: l_first_group_by VARCHAR2(1);
2821:
2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;

Line 2905: FROM IBY_PMT_LOGICAL_GRP_RULES

2901: INTO l_group_by_legal_entity,
2902: l_group_by_payment_method,
2903: l_group_by_payment_date,
2904: l_group_by_internal_bank_acct
2905: FROM IBY_PMT_LOGICAL_GRP_RULES
2906: WHERE SYSTEM_PROFILE_CODE = l_payment_profile_code;
2907:
2908: from_clause :=' FROM IBY_PAYMENTS_ALL';
2909: order_clause := ' ORDER BY ';