[Home] [Help]
259: r.subject_table_name,
260: r.subject_type,
261: r.start_date,
262: r.end_date
263: FROM hz_relationships r,
264: hz_relationship_types t
265: WHERE r.object_id = p_child_id
266: AND r.object_table_name = p_child_table_name
267: AND r.object_type = p_child_type
496:
497: -- Bug 3651949: take care of copy in the same day as relationships created
498: --
499: select relationship_id
500: FROM hz_relationships r,
501: hz_relationship_types t
502: where r.relationship_type = p_source_rel_type
503: AND r.relationship_type = t.relationship_type
504: AND t.relationship_type = p_source_rel_type
838: -- in which the passed in party id is the parent
839: cursor c0
840: IS
841: select relationship_id
842: from hz_relationships
843: where subject_id = p_party_id
844: and relationship_type = p_source_rel_type
845: and direction_code = 'P'
846: and (end_date is null or end_date > p_rel_valid_date )
1564: r.start_date,
1565: r.end_date,
1566: r.relationship_code,
1567: t.backward_rel_code
1568: FROM hz_relationships r,
1569: hz_relationship_types t
1570: WHERE r.relationship_type = p_rel_type
1571: AND r.relationship_type = t.relationship_type
1572: AND t.relationship_type = p_rel_type
1723: -- Bug 3615970: can not assume direction code has value.
1724: -- it may be null because we don't have data fix script
1725: -- when the new column is introduced.
1726: --
1727: UPDATE hz_relationships
1728: SET direction_code = 'P'
1729: WHERE direction_code IS NULL
1730: AND relationship_id = i_relationship_id(i)
1731: AND relationship_type = p_rel_type
1732: AND relationship_code = i_relationship_code(i)
1733: AND subject_type = i_parent_type(i)
1734: AND object_type = i_child_type(i);
1735:
1736: UPDATE hz_relationships
1737: SET direction_code = 'C'
1738: WHERE direction_code IS NULL
1739: AND relationship_id = i_relationship_id(i)
1740: AND relationship_type = p_rel_type