APPS.HZ_IMP_LOAD_PARTIES_PKG dependencies on STANDARD

Line 2460: decode(adi.accept_standardized_flag, ''Y'',

2456: nvl2(gender_l.lookup_code, ''Y'', null) gender_l,
2457: nvl2(person_iden_type_l.lookup_code, ''Y'', null) person_iden_type_l,
2458: ads.error_flag ads_err_flag, -- added for bug 6164407
2459: nvl2(createdby_l.lookup_code, ''Y'', null) createdby_l,
2460: decode(adi.accept_standardized_flag, ''Y'',
2461: adi.address1_std,
2462: nullif(adi.address1, :16)) address1,
2463: decode(adi.accept_standardized_flag, ''Y'',
2464: adi.address2_std,

Line 2463: decode(adi.accept_standardized_flag, ''Y'',

2459: nvl2(createdby_l.lookup_code, ''Y'', null) createdby_l,
2460: decode(adi.accept_standardized_flag, ''Y'',
2461: adi.address1_std,
2462: nullif(adi.address1, :16)) address1,
2463: decode(adi.accept_standardized_flag, ''Y'',
2464: adi.address2_std,
2465: nullif(adi.address2, :16)) address2,
2466: decode(adi.accept_standardized_flag, ''Y'',
2467: adi.address3_std,

Line 2466: decode(adi.accept_standardized_flag, ''Y'',

2462: nullif(adi.address1, :16)) address1,
2463: decode(adi.accept_standardized_flag, ''Y'',
2464: adi.address2_std,
2465: nullif(adi.address2, :16)) address2,
2466: decode(adi.accept_standardized_flag, ''Y'',
2467: adi.address3_std,
2468: nullif(adi.address3, :16)) address3,
2469: decode(adi.accept_standardized_flag, ''Y'',
2470: adi.address4_std,

Line 2469: decode(adi.accept_standardized_flag, ''Y'',

2465: nullif(adi.address2, :16)) address2,
2466: decode(adi.accept_standardized_flag, ''Y'',
2467: adi.address3_std,
2468: nullif(adi.address3, :16)) address3,
2469: decode(adi.accept_standardized_flag, ''Y'',
2470: adi.address4_std,
2471: nullif(adi.address4, :16)) address4,
2472: decode(adi.accept_standardized_flag, ''Y'',
2473: adi.city_std,

Line 2472: decode(adi.accept_standardized_flag, ''Y'',

2468: nullif(adi.address3, :16)) address3,
2469: decode(adi.accept_standardized_flag, ''Y'',
2470: adi.address4_std,
2471: nullif(adi.address4, :16)) address4,
2472: decode(adi.accept_standardized_flag, ''Y'',
2473: adi.city_std,
2474: nullif(adi.city, :16)) city,
2475: decode(adi.accept_standardized_flag, ''Y'',
2476: adi.country_std,

Line 2475: decode(adi.accept_standardized_flag, ''Y'',

2471: nullif(adi.address4, :16)) address4,
2472: decode(adi.accept_standardized_flag, ''Y'',
2473: adi.city_std,
2474: nullif(adi.city, :16)) city,
2475: decode(adi.accept_standardized_flag, ''Y'',
2476: adi.country_std,
2477: nullif(adi.country, :16)) country,
2478: decode(adi.accept_standardized_flag, ''Y'',
2479: adi.county_std,

Line 2478: decode(adi.accept_standardized_flag, ''Y'',

2474: nullif(adi.city, :16)) city,
2475: decode(adi.accept_standardized_flag, ''Y'',
2476: adi.country_std,
2477: nullif(adi.country, :16)) country,
2478: decode(adi.accept_standardized_flag, ''Y'',
2479: adi.county_std,
2480: nullif(adi.county, :16)) county,
2481: decode(adi.accept_standardized_flag, ''Y'',
2482: adi.postal_code_std,

Line 2481: decode(adi.accept_standardized_flag, ''Y'',

2477: nullif(adi.country, :16)) country,
2478: decode(adi.accept_standardized_flag, ''Y'',
2479: adi.county_std,
2480: nullif(adi.county, :16)) county,
2481: decode(adi.accept_standardized_flag, ''Y'',
2482: adi.postal_code_std,
2483: nullif(adi.postal_code, :16)) postal_code,
2484: decode(adi.accept_standardized_flag, ''Y'',
2485: nvl2(adi.province, adi.prov_state_admin_code_std, null),

Line 2484: decode(adi.accept_standardized_flag, ''Y'',

2480: nullif(adi.county, :16)) county,
2481: decode(adi.accept_standardized_flag, ''Y'',
2482: adi.postal_code_std,
2483: nullif(adi.postal_code, :16)) postal_code,
2484: decode(adi.accept_standardized_flag, ''Y'',
2485: nvl2(adi.province, adi.prov_state_admin_code_std, null),
2486: nullif(adi.province, :16)) province,
2487: decode(adi.accept_standardized_flag, ''Y'',
2488: nvl2(adi.state, adi.prov_state_admin_code_std, null),

Line 2487: decode(adi.accept_standardized_flag, ''Y'',

2483: nullif(adi.postal_code, :16)) postal_code,
2484: decode(adi.accept_standardized_flag, ''Y'',
2485: nvl2(adi.province, adi.prov_state_admin_code_std, null),
2486: nullif(adi.province, :16)) province,
2487: decode(adi.accept_standardized_flag, ''Y'',
2488: nvl2(adi.state, adi.prov_state_admin_code_std, null),
2489: nullif(adi.state, :16)) state,
2490: substrb(nullif(emaili.email_address, :16),1,320) email_address,
2491: nullif(webi.url, :16) url,