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

Line 471: IBY_APPLICABLE_PMT_PROFS apf,

467: SELECT f.format_name,
468: f.format_code
469: FROM IBY_PAYMENT_PROFILES p,
470: IBY_FORMATS_VL f,
471: IBY_APPLICABLE_PMT_PROFS apf,
472: IBY_APPLICABLE_PMT_PROFS apm,
473: IBY_PAYMENT_METHODS_B m
474: WHERE f.format_code = p.payment_format_code
475: AND apf.system_profile_code = p.system_profile_code

Line 472: IBY_APPLICABLE_PMT_PROFS apm,

468: f.format_code
469: FROM IBY_PAYMENT_PROFILES p,
470: IBY_FORMATS_VL f,
471: IBY_APPLICABLE_PMT_PROFS apf,
472: IBY_APPLICABLE_PMT_PROFS apm,
473: IBY_PAYMENT_METHODS_B m
474: WHERE f.format_code = p.payment_format_code
475: AND apf.system_profile_code = p.system_profile_code
476: AND (apf.applicable_type_code = APL_TYPE_PMT_FORMAT AND

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

1115: * format) and (profiles applicable to given payment
1116: * currency) and (profiles applicable to given internal
1117: * bank account) as shown in the graphic.
1118: *
1119: * Therefore, we need to join with the IBY_APPLICABLE_PMT_PROFS
1120: * five times - once to get the profiles for the method, once to get
1121: * the profiles for the org, and once to get the profiles for the
1122: * format etc. If we are able to get a non-null intersect for these
1123: * five queries, it means that there is a profile that matches the

Line 1150: IBY_APPLICABLE_PMT_PROFS app1,

1146: prof.payment_profile_id,
1147: prof.payment_profile_name,
1148: prof.processing_type
1149: FROM
1150: IBY_APPLICABLE_PMT_PROFS app1,
1151: IBY_APPLICABLE_PMT_PROFS app2,
1152: IBY_APPLICABLE_PMT_PROFS app3,
1153: IBY_APPLICABLE_PMT_PROFS app4,
1154: IBY_PAYMENT_PROFILES prof

Line 1151: IBY_APPLICABLE_PMT_PROFS app2,

1147: prof.payment_profile_name,
1148: prof.processing_type
1149: FROM
1150: IBY_APPLICABLE_PMT_PROFS app1,
1151: IBY_APPLICABLE_PMT_PROFS app2,
1152: IBY_APPLICABLE_PMT_PROFS app3,
1153: IBY_APPLICABLE_PMT_PROFS app4,
1154: IBY_PAYMENT_PROFILES prof
1155: WHERE

Line 1152: IBY_APPLICABLE_PMT_PROFS app3,

1148: prof.processing_type
1149: FROM
1150: IBY_APPLICABLE_PMT_PROFS app1,
1151: IBY_APPLICABLE_PMT_PROFS app2,
1152: IBY_APPLICABLE_PMT_PROFS app3,
1153: IBY_APPLICABLE_PMT_PROFS app4,
1154: IBY_PAYMENT_PROFILES prof
1155: WHERE
1156: (app1.applicable_type_code=APL_TYPE_PAYER_ORG AND

Line 1153: IBY_APPLICABLE_PMT_PROFS app4,

1149: FROM
1150: IBY_APPLICABLE_PMT_PROFS app1,
1151: IBY_APPLICABLE_PMT_PROFS app2,
1152: IBY_APPLICABLE_PMT_PROFS app3,
1153: IBY_APPLICABLE_PMT_PROFS app4,
1154: IBY_PAYMENT_PROFILES prof
1155: WHERE
1156: (app1.applicable_type_code=APL_TYPE_PAYER_ORG AND
1157: ((app1.applicable_value_to=TO_CHAR(p_org_id) AND