APPS.ASO_CHECK_TCA_PVT dependencies on HZ_CUST_ACCOUNTS

Line 29: FROM HZ_CUST_ACCOUNTS

25: IS
26:
27: CURSOR C_Get_Party_From_Acct(acct_id NUMBER) IS
28: SELECT party_id
29: FROM HZ_CUST_ACCOUNTS
30: WHERE cust_account_id = acct_id
31: AND status = 'A'
32: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
33:

Line 1015: FROM HZ_CUST_ACCOUNTS

1011: WHERE quote_header_id = qte_hdr;
1012:
1013: CURSOR C_Get_Party_From_Acct(acct_id NUMBER) IS
1014: SELECT party_id
1015: FROM HZ_CUST_ACCOUNTS
1016: WHERE cust_account_id = acct_id
1017: AND status = 'A'
1018: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
1019:

Line 1615: FROM hz_cust_accounts

1611: IS
1612:
1613: CURSOR C_Get_Account_Count(l_party_id NUMBER) IS
1614: SELECT count(rowid)
1615: FROM hz_cust_accounts
1616: WHERE party_id = l_party_id
1617: AND status = 'A'
1618: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
1619:

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 1632: FROM hz_cust_accounts

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
1632: FROM hz_cust_accounts
1633: WHERE party_id = l_Party_Id
1634: AND status = 'A'
1635: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate)
1636: ORDER BY creation_date ASC;

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 2004: hz_relationships a, hz_cust_accounts b

2000:
2001: CURSOR relationship_cur IS
2002: select a.object_id
2003: from
2004: hz_relationships a, hz_cust_accounts b
2005: where a.party_id = l_party_id
2006: and a.object_id = b.party_id
2007: and b.cust_account_id = p_cust_account_id;
2008:

Line 3259: FROM HZ_CUST_ACCOUNTS

3255: IS
3256:
3257: CURSOR C_Get_Party_From_Acct(acct_id NUMBER) IS
3258: SELECT party_id
3259: FROM HZ_CUST_ACCOUNTS
3260: WHERE cust_account_id = acct_id
3261: AND status = 'A'
3262: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
3263:

Line 3385: FROM hz_cust_accounts

3381: AND ship_to_cust_party_id IS NOT NULL;
3382:
3383: CURSOR C_Chk_Party_Acct (pty_id NUMBER) IS
3384: SELECT cust_account_id
3385: FROM hz_cust_accounts
3386: WHERE party_id = pty_id
3387: AND status = 'A'
3388: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
3389: