[Home] [Help]
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;
535:
536: CURSOR c_get_dss_groups (
1822: AND rel.relationship_id = p_relationship_id -- added for Bug 5687869
1823: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1824: SELECT relationship_type, forward_rel_code,
1825: subject_type, object_type
1826: FROM hz_relationship_types rt
1827: WHERE rt.relationship_type_id = p_relationship_type_id)
1828: AND SYSDATE BETWEEN
1829: NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE)
1830: AND status = 'A'
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:
1842: l_falling_into_the_group VARCHAR2(2);
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' )
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' )
1942: AND SYSDATE BETWEEN