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 403: IBY_APPLICABLE_PMT_PROFS apf,

399: SELECT f.format_name,
400: f.format_code
401: FROM IBY_PAYMENT_PROFILES p,
402: IBY_FORMATS_VL f,
403: IBY_APPLICABLE_PMT_PROFS apf,
404: IBY_APPLICABLE_PMT_PROFS apm,
405: IBY_PAYMENT_METHODS_B m
406: WHERE f.format_code = p.payment_format_code
407: AND apf.system_profile_code = p.system_profile_code

Line 404: IBY_APPLICABLE_PMT_PROFS apm,

400: f.format_code
401: FROM IBY_PAYMENT_PROFILES p,
402: IBY_FORMATS_VL f,
403: IBY_APPLICABLE_PMT_PROFS apf,
404: IBY_APPLICABLE_PMT_PROFS apm,
405: IBY_PAYMENT_METHODS_B m
406: WHERE f.format_code = p.payment_format_code
407: AND apf.system_profile_code = p.system_profile_code
408: AND (apf.applicable_type_code = APL_TYPE_PMT_FORMAT AND

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

986: * format) and (profiles applicable to given payment
987: * currency) and (profiles applicable to given internal
988: * bank account) as shown in the graphic.
989: *
990: * Therefore, we need to join with the IBY_APPLICABLE_PMT_PROFS
991: * five times - once to get the profiles for the method, once to get
992: * the profiles for the org, and once to get the profiles for the
993: * format etc. If we are able to get a non-null intersect for these
994: * five queries, it means that there is a profile that matches the

Line 1021: IBY_APPLICABLE_PMT_PROFS app1,

1017: prof.payment_profile_id,
1018: prof.payment_profile_name,
1019: prof.processing_type
1020: FROM
1021: IBY_APPLICABLE_PMT_PROFS app1,
1022: IBY_APPLICABLE_PMT_PROFS app2,
1023: IBY_APPLICABLE_PMT_PROFS app3,
1024: IBY_APPLICABLE_PMT_PROFS app4,
1025: IBY_PAYMENT_PROFILES prof

Line 1022: IBY_APPLICABLE_PMT_PROFS app2,

1018: prof.payment_profile_name,
1019: prof.processing_type
1020: FROM
1021: IBY_APPLICABLE_PMT_PROFS app1,
1022: IBY_APPLICABLE_PMT_PROFS app2,
1023: IBY_APPLICABLE_PMT_PROFS app3,
1024: IBY_APPLICABLE_PMT_PROFS app4,
1025: IBY_PAYMENT_PROFILES prof
1026: WHERE

Line 1023: IBY_APPLICABLE_PMT_PROFS app3,

1019: prof.processing_type
1020: FROM
1021: IBY_APPLICABLE_PMT_PROFS app1,
1022: IBY_APPLICABLE_PMT_PROFS app2,
1023: IBY_APPLICABLE_PMT_PROFS app3,
1024: IBY_APPLICABLE_PMT_PROFS app4,
1025: IBY_PAYMENT_PROFILES prof
1026: WHERE
1027: (app1.applicable_type_code=APL_TYPE_PAYER_ORG AND

Line 1024: IBY_APPLICABLE_PMT_PROFS app4,

1020: FROM
1021: IBY_APPLICABLE_PMT_PROFS app1,
1022: IBY_APPLICABLE_PMT_PROFS app2,
1023: IBY_APPLICABLE_PMT_PROFS app3,
1024: IBY_APPLICABLE_PMT_PROFS app4,
1025: IBY_PAYMENT_PROFILES prof
1026: WHERE
1027: (app1.applicable_type_code=APL_TYPE_PAYER_ORG AND
1028: ((app1.applicable_value_to=TO_CHAR(p_org_id) AND