eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 664: , hz_cust_accounts hca2

660:
661: CURSOR csr_buy_group (cv_bg_party_id IN NUMBER, cv_cust_account_id IN NUMBER) IS
662: SELECT COUNT(seg.party_id)
663: FROM ams_party_market_segments seg
664: , hz_cust_accounts hca2
665: WHERE seg.market_qualifier_reference = cv_bg_party_id
666: AND hca2.party_id = seg.party_id
667: AND seg.market_qualifier_type = 'BG'
668: AND hca2.cust_account_id = cv_cust_account_id

Line 678: FND_DSQL.add_text(' IN (SELECT c.cust_account_id FROM hz_cust_accounts c');

674: p_select_cust_children_flag = 'F' OR
675: p_select_cust_children_flag = 'N' THEN
676: -- not to include member earnings
677: IF p_buy_group_party_id IS NOT NULL THEN
678: FND_DSQL.add_text(' IN (SELECT c.cust_account_id FROM hz_cust_accounts c');
679: FND_DSQL.add_text(' WHERE c.party_id = ');
680: FND_DSQL.add_bind(p_buy_group_party_id);
681: FND_DSQL.add_text(')');
682: ELSIF p_relationship_type IS NOT NULL AND

Line 720: FND_DSQL.add_text(' FROM hz_cust_accounts c ');

716: END IF;
717:
718: IF l_bg_is_parent_of_cust = 1 OR l_bg_is_parent_of_relcust = 1 THEN
719: FND_DSQL.add_text(' IN (SELECT c.cust_account_id ');
720: FND_DSQL.add_text(' FROM hz_cust_accounts c ');
721: FND_DSQL.add_text(' WHERE c.party_id = ');
722: FND_DSQL.add_bind(p_buy_group_party_id);
723: FND_DSQL.add_text(' OR c.cust_account_id = ');
724: IF p_related_cust_account_id is not NULL THEN

Line 734: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');

730:
731: ELSE
732: IF p_buy_group_party_id IS NOT NULL THEN
733: FND_DSQL.add_text(' IN (SELECT c2.cust_account_id ');
734: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');
735: FND_DSQL.add_text(' WHERE sg.market_qualifier_type = ''BG'' ');
736: FND_DSQL.add_text(' AND sg.party_id = c2.party_id ');
737: FND_DSQL.add_text(' AND sg.market_qualifier_reference = ');
738: FND_DSQL.add_bind(p_buy_group_party_id);

Line 742: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');

738: FND_DSQL.add_bind(p_buy_group_party_id);
739: FND_DSQL.add_text(')');
740: ELSE
741: -- Modified for Bugfix 5346249
742: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
743: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
744: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
745: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
746: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');

Line 744: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');

740: ELSE
741: -- Modified for Bugfix 5346249
742: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
743: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
744: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
745: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
746: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');
747: FND_DSQL.add_text(' and cust1.cust_account_id = ');
748: IF p_related_cust_account_id IS NOT NULL THEN

Line 1690: FROM hz_cust_accounts

1686: l_party_id NUMBER;
1687:
1688: CURSOR csr_get_party_id(cv_cust_account_id IN NUMBER) IS
1689: SELECT party_id
1690: FROM hz_cust_accounts
1691: WHERE cust_account_id = cv_cust_account_id;
1692:
1693: BEGIN
1694: IF OZF_DEBUG_HIGH_ON THEN

Line 1817: FROM hz_cust_accounts ca

1813: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1814:
1815: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
1816: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
1817: FROM hz_cust_accounts ca
1818: , hz_parties party
1819: WHERE ca.party_id = party.party_id
1820: AND ca.cust_account_id = cv_cust_account_id;
1821:

Line 5972: FROM hz_parties p, hz_cust_accounts c

5968: l_accrual_flag VARCHAR2(1):= p_accrual_flag;
5969:
5970: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
5971: SELECT p.party_name
5972: FROM hz_parties p, hz_cust_accounts c
5973: WHERE p.party_id = c.party_id
5974: AND c.cust_account_id = cv_cust_account_id;
5975:
5976: BEGIN

Line 6959: , hz_cust_accounts c

6955:
6956: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
6957: SELECT p.party_name
6958: FROM hz_parties p
6959: , hz_cust_accounts c
6960: WHERE p.party_id = c.party_id
6961: AND c.cust_account_id = cv_cust_account_id;
6962:
6963: CURSOR c_get_conversion_type IS

Line 7448: , hz_cust_accounts c

7444:
7445: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
7446: SELECT p.party_name
7447: FROM hz_parties p
7448: , hz_cust_accounts c
7449: WHERE p.party_id = c.party_id
7450: AND c.cust_account_id = cv_cust_account_id;
7451:
7452: CURSOR c_get_conversion_type IS

Line 8000: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca

7996:
7997: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
7998: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
7999: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
8000: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca
8001: WHERE tp.party_id = hca.party_id
8002: AND tp.cust_account_id IS NULL
8003: AND hca.cust_account_id = cv_cust_account_id;
8004:

Line 11616: FROM ozf_cust_trd_prfls p, hz_cust_accounts c

11612: WHERE cust_account_id = cv_cust_account_id;
11613:
11614: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
11615: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag
11616: FROM ozf_cust_trd_prfls p, hz_cust_accounts c
11617: WHERE p.party_id = c.party_id
11618: AND p.cust_account_id IS NULL
11619: AND c.cust_account_id = cv_cust_account_id;
11620: