APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_APPLICABLE_PMT_PROFS

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

945: * a given org) and (profiles applicable to given payment
946: * currency) and (profiles applicable to given internal
947: * bank account) as shown in the graphic.
948: *
949: * Therefore, we need to join with the IBY_APPLICABLE_PMT_PROFS
950: * four times - once to get the profiles for the method, once to get
951: * the profiles for the org, and once to get the profiles for the
952: * currency etc. If we are able to get a non-null intersect for these
953: * five queries, it means that there is a profile that matches the

Line 980: IBY_APPLICABLE_PMT_PROFS app1,

976: IS
977: SELECT
978: acct_prof.payment_profile_id
979: FROM
980: IBY_APPLICABLE_PMT_PROFS app1,
981: IBY_APPLICABLE_PMT_PROFS app2,
982: IBY_APPLICABLE_PMT_PROFS app3,
983: IBY_APPLICABLE_PMT_PROFS app4,
984: IBY_SYS_PMT_PROFILES_B sys_prof,

Line 981: IBY_APPLICABLE_PMT_PROFS app2,

977: SELECT
978: acct_prof.payment_profile_id
979: FROM
980: IBY_APPLICABLE_PMT_PROFS app1,
981: IBY_APPLICABLE_PMT_PROFS app2,
982: IBY_APPLICABLE_PMT_PROFS app3,
983: IBY_APPLICABLE_PMT_PROFS app4,
984: IBY_SYS_PMT_PROFILES_B sys_prof,
985: IBY_ACCT_PMT_PROFILES_B acct_prof

Line 982: IBY_APPLICABLE_PMT_PROFS app3,

978: acct_prof.payment_profile_id
979: FROM
980: IBY_APPLICABLE_PMT_PROFS app1,
981: IBY_APPLICABLE_PMT_PROFS app2,
982: IBY_APPLICABLE_PMT_PROFS app3,
983: IBY_APPLICABLE_PMT_PROFS app4,
984: IBY_SYS_PMT_PROFILES_B sys_prof,
985: IBY_ACCT_PMT_PROFILES_B acct_prof
986: WHERE

Line 983: IBY_APPLICABLE_PMT_PROFS app4,

979: FROM
980: IBY_APPLICABLE_PMT_PROFS app1,
981: IBY_APPLICABLE_PMT_PROFS app2,
982: IBY_APPLICABLE_PMT_PROFS app3,
983: IBY_APPLICABLE_PMT_PROFS app4,
984: IBY_SYS_PMT_PROFILES_B sys_prof,
985: IBY_ACCT_PMT_PROFILES_B acct_prof
986: WHERE
987: /*