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 1536: FROM hz_parties p, hz_dss_criteria dc

1532: p_party_id NUMBER,
1533: p_dss_group_code VARCHAR2
1534: ) IS
1535: SELECT 1
1536: FROM hz_parties p, hz_dss_criteria dc
1537: WHERE p.party_id = p_party_id
1538: AND p.created_by_module IN (
1539: SELECT owner_table_id2
1540: FROM hz_dss_criteria

Line 1540: FROM hz_dss_criteria

1536: FROM hz_parties p, hz_dss_criteria dc
1537: WHERE p.party_id = p_party_id
1538: AND p.created_by_module IN (
1539: SELECT owner_table_id2
1540: FROM hz_dss_criteria
1541: WHERE dss_group_code = p_dss_group_code
1542: AND owner_table_name = 'AR_LOOKUPS'
1543: AND owner_table_id1 = 'HZ_CREATED_BY_MODULES'
1544: AND status = 'A');

Line 1637: FROM hz_dss_criteria dsc

1633: CURSOR c_class_codes_for_dsg (
1634: p_dss_group_code VARCHAR2
1635: ) IS
1636: SELECT dsc.owner_table_id1 , dsc.owner_table_id2
1637: FROM hz_dss_criteria dsc
1638: WHERE dsc.dss_group_code = p_dss_group_code
1639: AND owner_table_name = 'FND_LOOKUP_VALUES'
1640: AND status = 'A';
1641:

Line 1837: FROM hz_dss_criteria dsc

1833: CURSOR c_dss_relationship_types (
1834: p_dss_group_code VARCHAR2
1835: ) IS
1836: SELECT owner_table_id1
1837: FROM hz_dss_criteria dsc
1838: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1839: AND dsc.dss_group_code = p_dss_group_code
1840: AND dsc.status = 'A';
1841:

Line 1937: FROM hz_relationship_types rt, hz_dss_criteria dsc

1933: AND rel.relationship_id = p_object_pk1 --(Bug 5687869)
1934: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1935: SELECT relationship_type, forward_rel_code,
1936: subject_type, object_type
1937: FROM hz_relationship_types rt, hz_dss_criteria dsc
1938: WHERE dsc.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1939: AND dsc.dss_group_code = p_dss_group_code
1940: AND dsc.owner_table_id1 = rt.relationship_type_id
1941: AND dsc.status = 'A' )