APPS.IBY_PAYGROUP_PUB dependencies on AP_WEB_DB_EXPLINE_PKG

Line 24639: 'IE', NVL(ap_web_db_expline_pkg.

24635: (DECODE(
24636: per_addr_prov.style,
24637: 'US', NVL(per_addr_prov.region_1, ''),
24638: 'US_GLB', NVL(per_addr_prov.region_1, ''),
24639: 'IE', NVL(ap_web_db_expline_pkg.
24640: getcountyprovince(
24641: per_addr_prov.style,
24642: per_addr_prov.region_1),
24643: ''),

Line 24644: 'IE_GLB', NVL(ap_web_db_expline_pkg.

24640: getcountyprovince(
24641: per_addr_prov.style,
24642: per_addr_prov.region_1),
24643: ''),
24644: 'IE_GLB', NVL(ap_web_db_expline_pkg.
24645: getcountyprovince(
24646: per_addr_prov.style,
24647: per_addr_prov.region_1),
24648: ''),

Line 24649: 'GB', NVL(ap_web_db_expline_pkg.

24645: getcountyprovince(
24646: per_addr_prov.style,
24647: per_addr_prov.region_1),
24648: ''),
24649: 'GB', NVL(ap_web_db_expline_pkg.
24650: getcountyprovince(
24651: per_addr_prov.style,
24652: per_addr_prov.region_1),
24653: ''),

Line 24666: NVL(ap_web_db_expline_pkg.

24662: 'GB', '',
24663: 'CA', NVL(per_addr_prov.region_1, ''),
24664: 'CA_GLB', NVL(per_addr_prov.region_1, ''),
24665: 'JP', NVL(per_addr_prov.region_1, ''),
24666: NVL(ap_web_db_expline_pkg.
24667: getcountyprovince(
24668: per_addr_prov.style,
24669: per_addr_prov.region_1),
24670: '')

Line 24732: 'IE', NVL(ap_web_db_expline_pkg.

24728: DECODE(
24729: per_loc.style,
24730: 'US', NVL(per_loc.region_1, ''),
24731: 'US_GLB', NVL(per_loc.region_1, ''),
24732: 'IE', NVL(ap_web_db_expline_pkg.
24733: getcountyprovince(
24734: per_loc.style,
24735: per_loc.region_1),
24736: ''),

Line 24737: 'IE_GLB', NVL(ap_web_db_expline_pkg.

24733: getcountyprovince(
24734: per_loc.style,
24735: per_loc.region_1),
24736: ''),
24737: 'IE_GLB', NVL(ap_web_db_expline_pkg.
24738: getcountyprovince(
24739: per_loc.style,
24740: per_loc.region_1),
24741: ''),

Line 24742: 'GB', NVL(ap_web_db_expline_pkg.

24738: getcountyprovince(
24739: per_loc.style,
24740: per_loc.region_1),
24741: ''),
24742: 'GB', NVL(ap_web_db_expline_pkg.
24743: getcountyprovince(
24744: per_loc.style,
24745: per_loc.region_1),
24746: ''),

Line 24758: NVL(ap_web_db_expline_pkg.

24754: 'GB', '',
24755: 'CA', NVL(per_loc.region_1, ''),
24756: 'CA_GLB', NVL(per_loc.region_1, ''),
24757: 'JP', NVL(per_loc.region_1, ''),
24758: NVL(ap_web_db_expline_pkg.
24759: getcountyprovince(
24760: per_loc.style,
24761: per_loc.region_1),
24762: '')

Line 24828: 'IE', NVL(ap_web_db_expline_pkg.

24824: DECODE(
24825: per_addr.style,
24826: 'US', NVL(per_addr.region_1, ''),
24827: 'US_GLB', NVL(per_addr.region_1, ''),
24828: 'IE', NVL(ap_web_db_expline_pkg.
24829: getcountyprovince(
24830: per_addr.style,
24831: per_addr.region_1),
24832: ''),

Line 24833: 'IE_GLB', NVL(ap_web_db_expline_pkg.

24829: getcountyprovince(
24830: per_addr.style,
24831: per_addr.region_1),
24832: ''),
24833: 'IE_GLB', NVL(ap_web_db_expline_pkg.
24834: getcountyprovince(
24835: per_addr.style,
24836: per_addr.region_1),
24837: ''),

Line 24838: 'GB', NVL(ap_web_db_expline_pkg.

24834: getcountyprovince(
24835: per_addr.style,
24836: per_addr.region_1),
24837: ''),
24838: 'GB', NVL(ap_web_db_expline_pkg.
24839: getcountyprovince(
24840: per_addr.style,
24841: per_addr.region_1),
24842: ''),

Line 24855: NVL(ap_web_db_expline_pkg.

24851: 'GB', '',
24852: 'CA', NVL(per_addr.region_1, ''),
24853: 'CA_GLB', NVL(per_addr.region_1, ''),
24854: 'JP', NVL(per_addr.region_1, ''),
24855: NVL(ap_web_db_expline_pkg.
24856: getcountyprovince(
24857: per_addr.style,
24858: per_addr.region_1),
24859: '')

Line 24946: 'IE', NVL(ap_web_db_expline_pkg.

24942: NULL,DECODE(
24943: per_loc.style,
24944: 'US', NVL(per_loc.region_1, ''),
24945: 'US_GLB', NVL(per_loc.region_1, ''),
24946: 'IE', NVL(ap_web_db_expline_pkg.
24947: getcountyprovince(
24948: per_loc.style,
24949: per_loc.region_1),
24950: ''),

Line 24951: 'IE_GLB', NVL(ap_web_db_expline_pkg.

24947: getcountyprovince(
24948: per_loc.style,
24949: per_loc.region_1),
24950: ''),
24951: 'IE_GLB', NVL(ap_web_db_expline_pkg.
24952: getcountyprovince(
24953: per_loc.style,
24954: per_loc.region_1),
24955: ''),

Line 24956: 'GB', NVL(ap_web_db_expline_pkg.

24952: getcountyprovince(
24953: per_loc.style,
24954: per_loc.region_1),
24955: ''),
24956: 'GB', NVL(ap_web_db_expline_pkg.
24957: getcountyprovince(
24958: per_loc.style,
24959: per_loc.region_1),
24960: ''),

Line 24966: 'IE', NVL(ap_web_db_expline_pkg.

24962: DECODE(
24963: per_addr.style,
24964: 'US', NVL(per_addr.region_1, ''),
24965: 'US_GLB', NVL(per_addr.region_1, ''),
24966: 'IE', NVL(ap_web_db_expline_pkg.
24967: getcountyprovince(
24968: per_addr.style,
24969: per_addr.region_1),
24970: ''),

Line 24971: 'IE_GLB', NVL(ap_web_db_expline_pkg.

24967: getcountyprovince(
24968: per_addr.style,
24969: per_addr.region_1),
24970: ''),
24971: 'IE_GLB', NVL(ap_web_db_expline_pkg.
24972: getcountyprovince(
24973: per_addr.style,
24974: per_addr.region_1),
24975: ''),

Line 24976: 'GB', NVL(ap_web_db_expline_pkg.

24972: getcountyprovince(
24973: per_addr.style,
24974: per_addr.region_1),
24975: ''),
24976: 'GB', NVL(ap_web_db_expline_pkg.
24977: getcountyprovince(
24978: per_addr.style,
24979: per_addr.region_1),
24980: ''),

Line 24998: NVL(ap_web_db_expline_pkg.

24994: 'GB', '',
24995: 'CA', NVL(per_loc.region_1, ''),
24996: 'CA_GLB', NVL(per_loc.region_1, ''),
24997: 'JP', NVL(per_loc.region_1, ''),
24998: NVL(ap_web_db_expline_pkg.
24999: getcountyprovince(
25000: per_loc.style,
25001: per_loc.region_1),
25002: '')

Line 25013: NVL(ap_web_db_expline_pkg.

25009: 'GB', '',
25010: 'CA', NVL(per_addr.region_1, ''),
25011: 'CA_GLB', NVL(per_addr.region_1, ''),
25012: 'JP', NVL(per_addr.region_1, ''),
25013: NVL(ap_web_db_expline_pkg.
25014: getcountyprovince(
25015: per_addr.style,
25016: per_addr.region_1),
25017: '')