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_BUILD_UTILS_PKG dependencies on IBY_APPLICABLE_PMT_PROFS

Line 993: IBY_APPLICABLE_PMT_PROFS app1,

989: SELECT
990: 'Y'
991: INTO p_valid_flag
992: FROM
993: IBY_APPLICABLE_PMT_PROFS app1,
994: IBY_APPLICABLE_PMT_PROFS app2,
995: IBY_APPLICABLE_PMT_PROFS app3,
996: IBY_APPLICABLE_PMT_PROFS app4,
997: IBY_SYS_PMT_PROFILES_B sys_prof,

Line 994: IBY_APPLICABLE_PMT_PROFS app2,

990: 'Y'
991: INTO p_valid_flag
992: FROM
993: IBY_APPLICABLE_PMT_PROFS app1,
994: IBY_APPLICABLE_PMT_PROFS app2,
995: IBY_APPLICABLE_PMT_PROFS app3,
996: IBY_APPLICABLE_PMT_PROFS app4,
997: IBY_SYS_PMT_PROFILES_B sys_prof,
998: IBY_ACCT_PMT_PROFILES_B acct_prof

Line 995: IBY_APPLICABLE_PMT_PROFS app3,

991: INTO p_valid_flag
992: FROM
993: IBY_APPLICABLE_PMT_PROFS app1,
994: IBY_APPLICABLE_PMT_PROFS app2,
995: IBY_APPLICABLE_PMT_PROFS app3,
996: IBY_APPLICABLE_PMT_PROFS app4,
997: IBY_SYS_PMT_PROFILES_B sys_prof,
998: IBY_ACCT_PMT_PROFILES_B acct_prof
999: WHERE

Line 996: IBY_APPLICABLE_PMT_PROFS app4,

992: FROM
993: IBY_APPLICABLE_PMT_PROFS app1,
994: IBY_APPLICABLE_PMT_PROFS app2,
995: IBY_APPLICABLE_PMT_PROFS app3,
996: IBY_APPLICABLE_PMT_PROFS app4,
997: IBY_SYS_PMT_PROFILES_B sys_prof,
998: IBY_ACCT_PMT_PROFILES_B acct_prof
999: WHERE
1000: /*

Line 1078: IBY_APPLICABLE_PMT_PROFS app1,

1074: SELECT
1075: acct_prof.payment_profile_id, 'Y'
1076: INTO p_profile_id, p_valid_flag
1077: FROM
1078: IBY_APPLICABLE_PMT_PROFS app1,
1079: IBY_APPLICABLE_PMT_PROFS app2,
1080: IBY_APPLICABLE_PMT_PROFS app3,
1081: IBY_APPLICABLE_PMT_PROFS app4,
1082: IBY_SYS_PMT_PROFILES_B sys_prof,

Line 1079: IBY_APPLICABLE_PMT_PROFS app2,

1075: acct_prof.payment_profile_id, 'Y'
1076: INTO p_profile_id, p_valid_flag
1077: FROM
1078: IBY_APPLICABLE_PMT_PROFS app1,
1079: IBY_APPLICABLE_PMT_PROFS app2,
1080: IBY_APPLICABLE_PMT_PROFS app3,
1081: IBY_APPLICABLE_PMT_PROFS app4,
1082: IBY_SYS_PMT_PROFILES_B sys_prof,
1083: IBY_ACCT_PMT_PROFILES_B acct_prof

Line 1080: IBY_APPLICABLE_PMT_PROFS app3,

1076: INTO p_profile_id, p_valid_flag
1077: FROM
1078: IBY_APPLICABLE_PMT_PROFS app1,
1079: IBY_APPLICABLE_PMT_PROFS app2,
1080: IBY_APPLICABLE_PMT_PROFS app3,
1081: IBY_APPLICABLE_PMT_PROFS app4,
1082: IBY_SYS_PMT_PROFILES_B sys_prof,
1083: IBY_ACCT_PMT_PROFILES_B acct_prof
1084: WHERE

Line 1081: IBY_APPLICABLE_PMT_PROFS app4,

1077: FROM
1078: IBY_APPLICABLE_PMT_PROFS app1,
1079: IBY_APPLICABLE_PMT_PROFS app2,
1080: IBY_APPLICABLE_PMT_PROFS app3,
1081: IBY_APPLICABLE_PMT_PROFS app4,
1082: IBY_SYS_PMT_PROFILES_B sys_prof,
1083: IBY_ACCT_PMT_PROFILES_B acct_prof
1084: WHERE
1085: /*

Line 1236: * Therefore, we need to join with the IBY_APPLICABLE_PMT_PROFS

1232: * a given org) and (profiles applicable to given payment
1233: * currency) and (profiles applicable to given internal
1234: * bank account) as shown in the graphic.
1235: *
1236: * Therefore, we need to join with the IBY_APPLICABLE_PMT_PROFS
1237: * four times - once to get the profiles for the method, once to get
1238: * the profiles for the org, and once to get the profiles for the
1239: * currency etc. If we are able to get a non-null intersect for these
1240: * five queries, it means that there is a profile that matches the

Line 1267: IBY_APPLICABLE_PMT_PROFS app1,

1263: IS
1264: SELECT
1265: acct_prof.payment_profile_id
1266: FROM
1267: IBY_APPLICABLE_PMT_PROFS app1,
1268: IBY_APPLICABLE_PMT_PROFS app2,
1269: IBY_APPLICABLE_PMT_PROFS app3,
1270: IBY_APPLICABLE_PMT_PROFS app4,
1271: IBY_SYS_PMT_PROFILES_B sys_prof,

Line 1268: IBY_APPLICABLE_PMT_PROFS app2,

1264: SELECT
1265: acct_prof.payment_profile_id
1266: FROM
1267: IBY_APPLICABLE_PMT_PROFS app1,
1268: IBY_APPLICABLE_PMT_PROFS app2,
1269: IBY_APPLICABLE_PMT_PROFS app3,
1270: IBY_APPLICABLE_PMT_PROFS app4,
1271: IBY_SYS_PMT_PROFILES_B sys_prof,
1272: IBY_ACCT_PMT_PROFILES_B acct_prof

Line 1269: IBY_APPLICABLE_PMT_PROFS app3,

1265: acct_prof.payment_profile_id
1266: FROM
1267: IBY_APPLICABLE_PMT_PROFS app1,
1268: IBY_APPLICABLE_PMT_PROFS app2,
1269: IBY_APPLICABLE_PMT_PROFS app3,
1270: IBY_APPLICABLE_PMT_PROFS app4,
1271: IBY_SYS_PMT_PROFILES_B sys_prof,
1272: IBY_ACCT_PMT_PROFILES_B acct_prof
1273: WHERE

Line 1270: IBY_APPLICABLE_PMT_PROFS app4,

1266: FROM
1267: IBY_APPLICABLE_PMT_PROFS app1,
1268: IBY_APPLICABLE_PMT_PROFS app2,
1269: IBY_APPLICABLE_PMT_PROFS app3,
1270: IBY_APPLICABLE_PMT_PROFS app4,
1271: IBY_SYS_PMT_PROFILES_B sys_prof,
1272: IBY_ACCT_PMT_PROFILES_B acct_prof
1273: WHERE
1274: /*