APPS.ASO_CHECK_TCA_PVT dependencies on HZ_PARTIES

Line 36: FROM HZ_PARTIES

32: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
33:
34: CURSOR C_Party_Type(pty_id NUMBER) IS
35: SELECT party_type
36: FROM HZ_PARTIES
37: WHERE party_id = pty_id;
38:
39: CURSOR C_Get_Cust_Party(pty_id NUMBER) IS
40: SELECT object_id

Line 44: AND object_table_name = 'HZ_PARTIES';

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:
46: l_api_version CONSTANT NUMBER := 1.0;
47: l_api_name CONSTANT VARCHAR2(45) := 'Check_tca';
48: l_org_contact NUMBER;

Line 1627: and b.subject_table_name = 'HZ_PARTIES'

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
1627: and b.subject_table_name = 'HZ_PARTIES'
1628: and b.subject_type = 'PERSON';
1629:
1630: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
1631: SELECT cust_account_id

Line 1640: from hz_parties

1636: ORDER BY creation_date ASC;
1637:
1638: CURSOR party_rec(l_party_id NUMBER) IS
1639: select party_type
1640: from hz_parties
1641: where party_id = l_party_id;
1642:
1643: CURSOR party_rel_cur(l_party_id number) IS
1644: select object_id

Line 1647: and object_table_name = 'HZ_PARTIES'

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';
1650:
1651: CURSOR account_user_cur(l_party_id NUMBER) IS

Line 1648: and subject_table_name = 'HZ_PARTIES'

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';
1650:
1651: CURSOR account_user_cur(l_party_id NUMBER) IS
1652: select a.cust_account_id

Line 1658: and b.subject_table_name = 'HZ_PARTIES'

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
1658: and b.subject_table_name = 'HZ_PARTIES'
1659: and b.subject_type = 'PERSON'
1660: ORDER BY a.creation_date ASC;
1661:
1662: l_acct_count NUMBER := 0;

Line 1932: HZ_PARTIES a, HZ_PARTY_SITES b

1928: IS
1929: CURSOR party_cur IS
1930: SELECT a.party_type, a.party_id
1931: from
1932: HZ_PARTIES a, HZ_PARTY_SITES b
1933: where
1934: a.status = 'A'
1935: and b.status = 'A'
1936: and b.party_site_id = p_party_site_id