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 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:

Line 3211: FROM HZ_CUST_ACCOUNTS

3207: IS
3208:
3209: CURSOR C_Get_Party_From_Acct(acct_id NUMBER) IS
3210: SELECT party_id
3211: FROM HZ_CUST_ACCOUNTS
3212: WHERE cust_account_id = acct_id
3213: AND status = 'A'
3214: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
3215:

Line 3337: FROM hz_cust_accounts

3333: AND ship_to_cust_party_id IS NOT NULL;
3334:
3335: CURSOR C_Chk_Party_Acct (pty_id NUMBER) IS
3336: SELECT cust_account_id
3337: FROM hz_cust_accounts
3338: WHERE party_id = pty_id
3339: AND status = 'A'
3340: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
3341: