APPS.HZ_DSS_UTIL_PUB dependencies on HZ_DSS_CRITERIA

Line 500: FROM hz_dss_criteria

496: CURSOR c_check_criteria (
497: p_dss_group_code VARCHAR2
498: ) IS
499: SELECT 1
500: FROM hz_dss_criteria
501: WHERE dss_group_code = p_dss_group_code
502: AND status = 'A'
503: AND ROWNUM = 1;
504:

Line 509: FROM hz_dss_criteria

505: CURSOR c_check_created_by_module (
506: p_dss_group_code VARCHAR2
507: ) IS
508: SELECT 1
509: FROM hz_dss_criteria
510: WHERE dss_group_code = p_dss_group_code
511: AND owner_table_name = 'AR_LOOKUPS'
512: AND owner_table_id1 = 'HZ_CREATED_BY_MODULES'
513: AND status = 'A'

Line 520: FROM hz_dss_criteria

516: CURSOR c_check_classification (
517: p_dss_group_code VARCHAR2
518: ) IS
519: SELECT 1
520: FROM hz_dss_criteria
521: WHERE dss_group_code = p_dss_group_code
522: AND owner_table_name = 'FND_LOOKUP_VALUES'
523: AND status = 'A'
524: AND ROWNUM = 1;

Line 530: FROM hz_dss_criteria

526: CURSOR c_check_relationship_type (
527: p_dss_group_code VARCHAR2
528: ) IS
529: SELECT 1
530: FROM hz_dss_criteria
531: WHERE dss_group_code = p_dss_group_code
532: AND owner_table_name = 'HZ_RELATIONSHIP_TYPES'
533: AND status = 'A'
534: AND ROWNUM = 1;

Line 1541: FROM hz_parties p, hz_dss_criteria dc

1537: p_party_id NUMBER,
1538: p_dss_group_code VARCHAR2
1539: ) IS
1540: SELECT 1
1541: FROM hz_parties p, hz_dss_criteria dc
1542: WHERE p.party_id = p_party_id
1543: AND p.created_by_module IN (
1544: SELECT owner_table_id2
1545: FROM hz_dss_criteria

Line 1545: FROM hz_dss_criteria

1541: FROM hz_parties p, hz_dss_criteria dc
1542: WHERE p.party_id = p_party_id
1543: AND p.created_by_module IN (
1544: SELECT owner_table_id2
1545: FROM hz_dss_criteria
1546: WHERE dss_group_code = p_dss_group_code
1547: AND owner_table_name = 'AR_LOOKUPS'
1548: AND owner_table_id1 = 'HZ_CREATED_BY_MODULES'
1549: AND status = 'A');

Line 1645: FROM hz_dss_criteria dsc

1641: CURSOR c_class_codes_for_dsg (
1642: p_dss_group_code VARCHAR2
1643: ) IS
1644: SELECT dsc.owner_table_id1 , dsc.owner_table_id2
1645: FROM hz_dss_criteria dsc
1646: WHERE dsc.dss_group_code = p_dss_group_code
1647: AND owner_table_name = 'FND_LOOKUP_VALUES'
1648: AND status = 'A';
1649:

Line 1877: FROM hz_dss_criteria dsc

1873: CURSOR c_dss_relationship_types (
1874: p_dss_group_code VARCHAR2
1875: ) IS
1876: SELECT owner_table_id1
1877: FROM hz_dss_criteria dsc
1878: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1879: AND dsc.dss_group_code = p_dss_group_code
1880: AND dsc.status = 'A';
1881:

Line 2006: FROM hz_relationship_types rt, hz_dss_criteria dsc

2002: AND rel.relationship_id = p_object_pk1 --(Bug 5687869)
2003: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2004: SELECT relationship_type, forward_rel_code,
2005: subject_type, object_type
2006: FROM hz_relationship_types rt, hz_dss_criteria dsc
2007: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2008: AND dsc.dss_group_code = p_dss_group_code
2009: AND dsc.owner_table_id1 = rt.relationship_type_id
2010: AND dsc.status = 'A' )

Line 2032: FROM hz_relationship_types rt, hz_dss_criteria dsc

2028: AND rel.directional_flag = 'F'
2029: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2030: SELECT relationship_type, forward_rel_code,
2031: subject_type, object_type
2032: FROM hz_relationship_types rt, hz_dss_criteria dsc
2033: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2034: AND dsc.dss_group_code = p_dss_group_code
2035: AND dsc.owner_table_id1 = rt.relationship_type_id
2036: AND dsc.status = 'A')

Line 2051: FROM hz_relationship_types rt, hz_dss_criteria dsc

2047: AND rel.directional_flag = 'F'
2048: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
2049: SELECT relationship_type, forward_rel_code,
2050: subject_type, object_type
2051: FROM hz_relationship_types rt, hz_dss_criteria dsc
2052: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
2053: AND dsc.dss_group_code = p_dss_group_code
2054: AND dsc.owner_table_id1 = rt.relationship_type_id
2055: AND dsc.status = 'A')