DBA Data[Home] [Help]

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_RELATIONSHIPS

Line 2304: INTO HZ_RELATIONSHIPS

2300: sysdate,
2301: fnd_global.conc_login_id
2302: )
2303: WHEN (action_type = 'CREATE') THEN
2304: INTO HZ_RELATIONSHIPS
2305: (
2306: RELATIONSHIP_ID,
2307: SUBJECT_ID,
2308: SUBJECT_TYPE,

Line 2335: hz_relationships_s.nextval,

2331: ACTUAL_CONTENT_SOURCE
2332: )
2333: VALUES
2334: (
2335: hz_relationships_s.nextval,
2336: parent_geography_id,
2337: parent_geography_type,
2338: 'HZ_GEOGRAPHIES',
2339: geography_id,

Line 2362: INTO HZ_RELATIONSHIPS

2358: 'P',
2359: null,
2360: p_tax_content_source
2361: )
2362: INTO HZ_RELATIONSHIPS
2363: (
2364: RELATIONSHIP_ID,
2365: SUBJECT_ID,
2366: SUBJECT_TYPE,

Line 2393: hz_relationships_s.nextval,

2389: ACTUAL_CONTENT_SOURCE
2390: )
2391: VALUES
2392: (
2393: hz_relationships_s.nextval,
2394: geography_id,
2395: geography_type,
2396: 'HZ_GEOGRAPHIES',
2397: parent_geography_id,

Line 2459: hz_relationships_s.nextval,

2455: '',
2456: start_date,
2457: end_date,
2458: 'A',
2459: hz_relationships_s.nextval,
2460: fnd_global.user_id,
2461: sysdate,
2462: fnd_global.user_id,
2463: sysdate,

Line 3013: INTO HZ_RELATIONSHIPS

3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.conc_login_id
3012: )
3013: INTO HZ_RELATIONSHIPS
3014: (
3015: RELATIONSHIP_ID,
3016: SUBJECT_ID,
3017: SUBJECT_TYPE,

Line 3044: hz_relationships_s.nextval,

3040: ACTUAL_CONTENT_SOURCE
3041: )
3042: VALUES
3043: (
3044: hz_relationships_s.nextval,
3045: zone_geography_id,
3046: zone_geography_type,
3047: 'HZ_GEOGRAPHIES',
3048: geography_id,

Line 3071: INTO HZ_RELATIONSHIPS

3067: 'P',
3068: null,
3069: p_tax_content_source
3070: )
3071: INTO HZ_RELATIONSHIPS
3072: (
3073: RELATIONSHIP_ID,
3074: SUBJECT_ID,
3075: SUBJECT_TYPE,

Line 3102: hz_relationships_s.nextval,

3098: ACTUAL_CONTENT_SOURCE
3099: )
3100: VALUES
3101: (
3102: hz_relationships_s.nextval,
3103: geography_id,
3104: geography_type,
3105: 'HZ_GEOGRAPHIES',
3106: zone_geography_id,

Line 3558: hz_relationships hr,

3554: (SELECT SUBSTR(hg.geography_element2_code,1,2)||'-'||
3555: DECODE(hg.geography_element3,null,'',SUBSTR(hg.geography_element3,1,30)||'-')||
3556: DECODE(hg.geography_element4,null,'',SUBSTR(hg.geography_element4,1,30)||'-')
3557: FROM hz_geographies hg_zone,
3558: hz_relationships hr,
3559: hz_geographies hg
3560: WHERE hg_zone.GEOGRAPHY_ID = zjb.zone_geography_id
3561: AND hr.SUBJECT_ID = hg_zone.GEOGRAPHY_ID
3562: AND hr.SUBJECT_TYPE = hg_zone.GEOGRAPHY_TYPE

Line 3995: INTO HZ_RELATIONSHIPS

3991: fnd_global.user_id,
3992: sysdate,
3993: fnd_global.conc_login_id
3994: )
3995: INTO HZ_RELATIONSHIPS
3996: (
3997: RELATIONSHIP_ID,
3998: SUBJECT_ID,
3999: SUBJECT_TYPE,

Line 4026: hz_relationships_s.nextval,

4022: ACTUAL_CONTENT_SOURCE
4023: )
4024: VALUES
4025: (
4026: hz_relationships_s.nextval,
4027: parent_geography_id,
4028: parent_geography_type,
4029: 'HZ_GEOGRAPHIES',
4030: hz_geographies_s.nextval,

Line 4053: INTO HZ_RELATIONSHIPS

4049: 'P',
4050: null,
4051: p_tax_content_source
4052: )
4053: INTO HZ_RELATIONSHIPS
4054: (
4055: RELATIONSHIP_ID,
4056: SUBJECT_ID,
4057: SUBJECT_TYPE,

Line 4084: hz_relationships_s.nextval,

4080: ACTUAL_CONTENT_SOURCE
4081: )
4082: VALUES
4083: (
4084: hz_relationships_s.nextval,
4085: hz_geographies_s.nextval,
4086: geography_type,
4087: 'HZ_GEOGRAPHIES',
4088: parent_geography_id,

Line 4197: hz_relationships_s.nextval,

4193: '',
4194: start_date,
4195: end_date,
4196: 'A',
4197: hz_relationships_s.nextval,
4198: fnd_global.user_id,
4199: sysdate,
4200: fnd_global.user_id,
4201: sysdate,

Line 4412: hz_relationships rel

4408: WHERE v.geography_id = g.geography_id
4409: AND g.country_code = 'US'
4410: AND NOT EXISTS ( SELECT /*+ordered */'1'
4411: FROM hz_geographies g1,
4412: hz_relationships rel
4413: WHERE rel.subject_id = g.geography_id
4414: AND rel.subject_type = g.geography_type
4415: AND rel.subject_table_name = 'HZ_GEOGRAPHIES'
4416: AND rel.object_id = g1.geography_id