APPS.ASO_CHECK_TCA_PVT dependencies on HZ_RELATIONSHIPS

Line 41: FROM HZ_RELATIONSHIPS

37: WHERE party_id = pty_id;
38:
39: CURSOR C_Get_Cust_Party(pty_id NUMBER) IS
40: SELECT object_id
41: FROM HZ_RELATIONSHIPS
42: WHERE party_id = pty_id
43: AND object_type = 'ORGANIZATION'
44: AND object_table_name = 'HZ_PARTIES';
45:

Line 1622: from hz_cust_accounts a, hz_relationships b

1618: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
1619:
1620: CURSOR C_Get_Account_User_Count(l_party_id NUMBER) IS
1621: SELECT count(a.rowid)
1622: from hz_cust_accounts a, hz_relationships b
1623: where a.party_id = b.object_id
1624: and a.status = 'A'
1625: AND sysdate BETWEEN NVL(a.account_activation_date, sysdate) AND NVL(a.account_termination_date, sysdate)
1626: and b.party_id = l_party_id

Line 1645: from hz_relationships

1641: where party_id = l_party_id;
1642:
1643: CURSOR party_rel_cur(l_party_id number) IS
1644: select object_id
1645: from hz_relationships
1646: where party_id = l_party_id
1647: and object_table_name = 'HZ_PARTIES'
1648: and subject_table_name = 'HZ_PARTIES'
1649: and subject_type = 'PERSON';

Line 1653: from hz_cust_accounts a, hz_relationships b

1649: and subject_type = 'PERSON';
1650:
1651: CURSOR account_user_cur(l_party_id NUMBER) IS
1652: select a.cust_account_id
1653: from hz_cust_accounts a, hz_relationships b
1654: where a.party_id = b.object_id
1655: and a.status = 'A'
1656: AND sysdate BETWEEN NVL(a.account_activation_date, sysdate) AND NVL(a.account_termination_date, sysdate)
1657: and b.party_id = l_party_id

Line 1996: hz_relationships a, hz_cust_accounts b

1992:
1993: CURSOR relationship_cur IS
1994: select a.object_id
1995: from
1996: hz_relationships a, hz_cust_accounts b
1997: where a.party_id = l_party_id
1998: and a.object_id = b.party_id
1999: and b.cust_account_id = p_cust_account_id;
2000: