APPS.IBY_VALIDATIONSETS_PUB dependencies on AP_WEB_DB_EXPLINE_PKG

Line 7162: 'IE', NVL(ap_web_db_expline_pkg.

7158: DECODE(
7159: per_addr.style,
7160: 'US', NVL(per_addr.region_1, ''),
7161: 'US_GLB', NVL(per_addr.region_1, ''),
7162: 'IE', NVL(ap_web_db_expline_pkg.
7163: getcountyprovince(
7164: per_addr.style,
7165: per_addr.region_1),
7166: ''),

Line 7167: 'IE_GLB', NVL(ap_web_db_expline_pkg.

7163: getcountyprovince(
7164: per_addr.style,
7165: per_addr.region_1),
7166: ''),
7167: 'IE_GLB', NVL(ap_web_db_expline_pkg.
7168: getcountyprovince(
7169: per_addr.style,
7170: per_addr.region_1),
7171: ''),

Line 7172: 'GB', NVL(ap_web_db_expline_pkg.

7168: getcountyprovince(
7169: per_addr.style,
7170: per_addr.region_1),
7171: ''),
7172: 'GB', NVL(ap_web_db_expline_pkg.
7173: getcountyprovince(
7174: per_addr.style,
7175: per_addr.region_1),
7176: ''),

Line 7185: 'IE', NVL(ap_web_db_expline_pkg.

7181: DECODE(
7182: per_loc.style,
7183: 'US', NVL(per_loc.region_1, ''),
7184: 'US_GLB', NVL(per_loc.region_1, ''),
7185: 'IE', NVL(ap_web_db_expline_pkg.
7186: getcountyprovince(
7187: per_loc.style,
7188: per_loc.region_1),
7189: ''),

Line 7190: 'IE_GLB', NVL(ap_web_db_expline_pkg.

7186: getcountyprovince(
7187: per_loc.style,
7188: per_loc.region_1),
7189: ''),
7190: 'IE_GLB', NVL(ap_web_db_expline_pkg.
7191: getcountyprovince(
7192: per_loc.style,
7193: per_loc.region_1),
7194: ''),

Line 7195: 'GB', NVL(ap_web_db_expline_pkg.

7191: getcountyprovince(
7192: per_loc.style,
7193: per_loc.region_1),
7194: ''),
7195: 'GB', NVL(ap_web_db_expline_pkg.
7196: getcountyprovince(
7197: per_loc.style,
7198: per_loc.region_1),
7199: ''),

Line 7208: 'IE', NVL(ap_web_db_expline_pkg.

7204: DECODE(
7205: per_addr_prov.style,
7206: 'US', NVL(per_addr_prov.region_1, ''),
7207: 'US_GLB', NVL(per_addr_prov.region_1, ''),
7208: 'IE', NVL(ap_web_db_expline_pkg.
7209: getcountyprovince(
7210: per_addr_prov.style,
7211: per_addr_prov.region_1),
7212: ''),

Line 7213: 'IE_GLB', NVL(ap_web_db_expline_pkg.

7209: getcountyprovince(
7210: per_addr_prov.style,
7211: per_addr_prov.region_1),
7212: ''),
7213: 'IE_GLB', NVL(ap_web_db_expline_pkg.
7214: getcountyprovince(
7215: per_addr_prov.style,
7216: per_addr_prov.region_1),
7217: ''),

Line 7218: 'GB', NVL(ap_web_db_expline_pkg.

7214: getcountyprovince(
7215: per_addr_prov.style,
7216: per_addr_prov.region_1),
7217: ''),
7218: 'GB', NVL(ap_web_db_expline_pkg.
7219: getcountyprovince(
7220: per_addr_prov.style,
7221: per_addr_prov.region_1),
7222: ''),

Line 7230: 'IE', NVL(ap_web_db_expline_pkg.

7226: NULL,DECODE(
7227: per_loc.style,
7228: 'US', NVL(per_loc.region_1, ''),
7229: 'US_GLB', NVL(per_loc.region_1, ''),
7230: 'IE', NVL(ap_web_db_expline_pkg.
7231: getcountyprovince(
7232: per_loc.style,
7233: per_loc.region_1),
7234: ''),

Line 7235: 'IE_GLB', NVL(ap_web_db_expline_pkg.

7231: getcountyprovince(
7232: per_loc.style,
7233: per_loc.region_1),
7234: ''),
7235: 'IE_GLB', NVL(ap_web_db_expline_pkg.
7236: getcountyprovince(
7237: per_loc.style,
7238: per_loc.region_1),
7239: ''),

Line 7240: 'GB', NVL(ap_web_db_expline_pkg.

7236: getcountyprovince(
7237: per_loc.style,
7238: per_loc.region_1),
7239: ''),
7240: 'GB', NVL(ap_web_db_expline_pkg.
7241: getcountyprovince(
7242: per_loc.style,
7243: per_loc.region_1),
7244: ''),

Line 7250: 'IE', NVL(ap_web_db_expline_pkg.

7246: DECODE(
7247: per_addr.style,
7248: 'US', NVL(per_addr.region_1, ''),
7249: 'US_GLB', NVL(per_addr.region_1, ''),
7250: 'IE', NVL(ap_web_db_expline_pkg.
7251: getcountyprovince(
7252: per_addr.style,
7253: per_addr.region_1),
7254: ''),

Line 7255: 'IE_GLB', NVL(ap_web_db_expline_pkg.

7251: getcountyprovince(
7252: per_addr.style,
7253: per_addr.region_1),
7254: ''),
7255: 'IE_GLB', NVL(ap_web_db_expline_pkg.
7256: getcountyprovince(
7257: per_addr.style,
7258: per_addr.region_1),
7259: ''),

Line 7260: 'GB', NVL(ap_web_db_expline_pkg.

7256: getcountyprovince(
7257: per_addr.style,
7258: per_addr.region_1),
7259: ''),
7260: 'GB', NVL(ap_web_db_expline_pkg.
7261: getcountyprovince(
7262: per_addr.style,
7263: per_addr.region_1),
7264: ''),

Line 7294: NVL(ap_web_db_expline_pkg.

7290: 'GB', '',
7291: 'CA', NVL(per_addr.region_1, ''),
7292: 'CA_GLB', NVL(per_addr.region_1, ''),
7293: 'JP', NVL(per_addr.region_1, ''),
7294: NVL(ap_web_db_expline_pkg.
7295: getcountyprovince(
7296: per_addr.style,
7297: per_addr.region_1),
7298: '')

Line 7312: NVL(ap_web_db_expline_pkg.

7308: 'GB', '',
7309: 'CA', NVL(per_loc.region_1, ''),
7310: 'CA_GLB', NVL(per_loc.region_1, ''),
7311: 'JP', NVL(per_loc.region_1, ''),
7312: NVL(ap_web_db_expline_pkg.
7313: getcountyprovince(
7314: per_loc.style,
7315: per_loc.region_1),
7316: '')

Line 7329: NVL(ap_web_db_expline_pkg.

7325: 'GB', '',
7326: 'CA', NVL(per_addr_prov.region_1, ''),
7327: 'CA_GLB', NVL(per_addr_prov.region_1, ''),
7328: 'JP', NVL(per_addr_prov.region_1, ''),
7329: NVL(ap_web_db_expline_pkg.
7330: getcountyprovince(
7331: per_addr_prov.style,
7332: per_addr_prov.region_1),
7333: '')

Line 7347: NVL(ap_web_db_expline_pkg.

7343: 'GB', '',
7344: 'CA', NVL(per_loc.region_1, ''),
7345: 'CA_GLB', NVL(per_loc.region_1, ''),
7346: 'JP', NVL(per_loc.region_1, ''),
7347: NVL(ap_web_db_expline_pkg.
7348: getcountyprovince(
7349: per_loc.style,
7350: per_loc.region_1),
7351: '')

Line 7362: NVL(ap_web_db_expline_pkg.

7358: 'GB', '',
7359: 'CA', NVL(per_addr.region_1, ''),
7360: 'CA_GLB', NVL(per_addr.region_1, ''),
7361: 'JP', NVL(per_addr.region_1, ''),
7362: NVL(ap_web_db_expline_pkg.
7363: getcountyprovince(
7364: per_addr.style,
7365: per_addr.region_1),
7366: '')