APPS.IBY_VALIDATIONSETS_PUB dependencies on AP_WEB_DB_EXPLINE_PKG

Line 2050: 'IE', NVL(ap_web_db_expline_pkg.

2046: DECODE(
2047: per_addr.style,
2048: 'US', NVL(per_addr.region_1, ''),
2049: 'US_GLB', NVL(per_addr.region_1, ''),
2050: 'IE', NVL(ap_web_db_expline_pkg.
2051: getcountyprovince(
2052: per_addr.style,
2053: per_addr.region_1),
2054: ''),

Line 2055: 'IE_GLB', NVL(ap_web_db_expline_pkg.

2051: getcountyprovince(
2052: per_addr.style,
2053: per_addr.region_1),
2054: ''),
2055: 'IE_GLB', NVL(ap_web_db_expline_pkg.
2056: getcountyprovince(
2057: per_addr.style,
2058: per_addr.region_1),
2059: ''),

Line 2060: 'GB', NVL(ap_web_db_expline_pkg.

2056: getcountyprovince(
2057: per_addr.style,
2058: per_addr.region_1),
2059: ''),
2060: 'GB', NVL(ap_web_db_expline_pkg.
2061: getcountyprovince(
2062: per_addr.style,
2063: per_addr.region_1),
2064: ''),

Line 2073: 'IE', NVL(ap_web_db_expline_pkg.

2069: DECODE(
2070: per_loc.style,
2071: 'US', NVL(per_loc.region_1, ''),
2072: 'US_GLB', NVL(per_loc.region_1, ''),
2073: 'IE', NVL(ap_web_db_expline_pkg.
2074: getcountyprovince(
2075: per_loc.style,
2076: per_loc.region_1),
2077: ''),

Line 2078: 'IE_GLB', NVL(ap_web_db_expline_pkg.

2074: getcountyprovince(
2075: per_loc.style,
2076: per_loc.region_1),
2077: ''),
2078: 'IE_GLB', NVL(ap_web_db_expline_pkg.
2079: getcountyprovince(
2080: per_loc.style,
2081: per_loc.region_1),
2082: ''),

Line 2083: 'GB', NVL(ap_web_db_expline_pkg.

2079: getcountyprovince(
2080: per_loc.style,
2081: per_loc.region_1),
2082: ''),
2083: 'GB', NVL(ap_web_db_expline_pkg.
2084: getcountyprovince(
2085: per_loc.style,
2086: per_loc.region_1),
2087: ''),

Line 2097: 'IE', NVL(ap_web_db_expline_pkg.

2093: NULL,DECODE(
2094: per_loc.style,
2095: 'US', NVL(per_loc.region_1, ''),
2096: 'US_GLB', NVL(per_loc.region_1, ''),
2097: 'IE', NVL(ap_web_db_expline_pkg.
2098: getcountyprovince(
2099: per_loc.style,
2100: per_loc.region_1),
2101: ''),

Line 2102: 'IE_GLB', NVL(ap_web_db_expline_pkg.

2098: getcountyprovince(
2099: per_loc.style,
2100: per_loc.region_1),
2101: ''),
2102: 'IE_GLB', NVL(ap_web_db_expline_pkg.
2103: getcountyprovince(
2104: per_loc.style,
2105: per_loc.region_1),
2106: ''),

Line 2107: 'GB', NVL(ap_web_db_expline_pkg.

2103: getcountyprovince(
2104: per_loc.style,
2105: per_loc.region_1),
2106: ''),
2107: 'GB', NVL(ap_web_db_expline_pkg.
2108: getcountyprovince(
2109: per_loc.style,
2110: per_loc.region_1),
2111: ''),

Line 2117: 'IE', NVL(ap_web_db_expline_pkg.

2113: DECODE(
2114: per_addr.style,
2115: 'US', NVL(per_addr.region_1, ''),
2116: 'US_GLB', NVL(per_addr.region_1, ''),
2117: 'IE', NVL(ap_web_db_expline_pkg.
2118: getcountyprovince(
2119: per_addr.style,
2120: per_addr.region_1),
2121: ''),

Line 2122: 'IE_GLB', NVL(ap_web_db_expline_pkg.

2118: getcountyprovince(
2119: per_addr.style,
2120: per_addr.region_1),
2121: ''),
2122: 'IE_GLB', NVL(ap_web_db_expline_pkg.
2123: getcountyprovince(
2124: per_addr.style,
2125: per_addr.region_1),
2126: ''),

Line 2127: 'GB', NVL(ap_web_db_expline_pkg.

2123: getcountyprovince(
2124: per_addr.style,
2125: per_addr.region_1),
2126: ''),
2127: 'GB', NVL(ap_web_db_expline_pkg.
2128: getcountyprovince(
2129: per_addr.style,
2130: per_addr.region_1),
2131: ''),

Line 2161: NVL(ap_web_db_expline_pkg.

2157: 'GB', '',
2158: 'CA', NVL(per_addr.region_1, ''),
2159: 'CA_GLB', NVL(per_addr.region_1, ''),
2160: 'JP', NVL(per_addr.region_1, ''),
2161: NVL(ap_web_db_expline_pkg.
2162: getcountyprovince(
2163: per_addr.style,
2164: per_addr.region_1),
2165: '')

Line 2179: NVL(ap_web_db_expline_pkg.

2175: 'GB', '',
2176: 'CA', NVL(per_loc.region_1, ''),
2177: 'CA_GLB', NVL(per_loc.region_1, ''),
2178: 'JP', NVL(per_loc.region_1, ''),
2179: NVL(ap_web_db_expline_pkg.
2180: getcountyprovince(
2181: per_loc.style,
2182: per_loc.region_1),
2183: '')

Line 2197: NVL(ap_web_db_expline_pkg.

2193: 'GB', '',
2194: 'CA', NVL(per_loc.region_1, ''),
2195: 'CA_GLB', NVL(per_loc.region_1, ''),
2196: 'JP', NVL(per_loc.region_1, ''),
2197: NVL(ap_web_db_expline_pkg.
2198: getcountyprovince(
2199: per_loc.style,
2200: per_loc.region_1),
2201: '')

Line 2212: NVL(ap_web_db_expline_pkg.

2208: 'GB', '',
2209: 'CA', NVL(per_addr.region_1, ''),
2210: 'CA_GLB', NVL(per_addr.region_1, ''),
2211: 'JP', NVL(per_addr.region_1, ''),
2212: NVL(ap_web_db_expline_pkg.
2213: getcountyprovince(
2214: per_addr.style,
2215: per_addr.region_1),
2216: '')