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 589: , hz_cust_accounts hca2

585:
586: CURSOR csr_buy_group (cv_bg_party_id IN NUMBER, cv_cust_account_id IN NUMBER) IS
587: SELECT COUNT(seg.party_id)
588: FROM ams_party_market_segments seg
589: , hz_cust_accounts hca2
590: WHERE seg.market_qualifier_reference = cv_bg_party_id
591: AND hca2.party_id = seg.party_id
592: AND seg.market_qualifier_type = 'BG'
593: AND hca2.cust_account_id = cv_cust_account_id

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

599: p_select_cust_children_flag = 'F' OR
600: p_select_cust_children_flag = 'N' THEN
601: -- not to include member earnings
602: IF p_buy_group_party_id IS NOT NULL THEN
603: FND_DSQL.add_text(' IN (SELECT c.cust_account_id FROM hz_cust_accounts c');
604: FND_DSQL.add_text(' WHERE c.party_id = ');
605: FND_DSQL.add_bind(p_buy_group_party_id);
606: FND_DSQL.add_text(')');
607: ELSIF p_relationship_type IS NOT NULL AND

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

641: END IF;
642:
643: IF l_bg_is_parent_of_cust = 1 OR l_bg_is_parent_of_relcust = 1 THEN
644: FND_DSQL.add_text(' IN (SELECT c.cust_account_id ');
645: FND_DSQL.add_text(' FROM hz_cust_accounts c ');
646: FND_DSQL.add_text(' WHERE c.party_id = ');
647: FND_DSQL.add_bind(p_buy_group_party_id);
648: FND_DSQL.add_text(' OR c.cust_account_id = ');
649: IF p_related_cust_account_id is not NULL THEN

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

655:
656: ELSE
657: IF p_buy_group_party_id IS NOT NULL THEN
658: FND_DSQL.add_text(' IN (SELECT c2.cust_account_id ');
659: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');
660: FND_DSQL.add_text(' WHERE sg.market_qualifier_type = ''BG'' ');
661: FND_DSQL.add_text(' AND sg.party_id = c2.party_id ');
662: FND_DSQL.add_text(' AND sg.market_qualifier_reference = ');
663: FND_DSQL.add_bind(p_buy_group_party_id);

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

663: FND_DSQL.add_bind(p_buy_group_party_id);
664: FND_DSQL.add_text(')');
665: ELSE
666: -- Modified for Bugfix 5346249
667: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
668: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
669: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
670: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
671: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');

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

665: ELSE
666: -- Modified for Bugfix 5346249
667: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
668: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
669: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
670: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
671: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');
672: FND_DSQL.add_text(' and cust1.cust_account_id = ');
673: IF p_related_cust_account_id IS NOT NULL THEN

Line 1468: FROM hz_cust_accounts

1464: l_party_id NUMBER;
1465:
1466: CURSOR csr_get_party_id(cv_cust_account_id IN NUMBER) IS
1467: SELECT party_id
1468: FROM hz_cust_accounts
1469: WHERE cust_account_id = cv_cust_account_id;
1470:
1471: BEGIN
1472: IF OZF_DEBUG_HIGH_ON THEN

Line 1531: FROM hz_cust_accounts ca

1527: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1528:
1529: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
1530: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
1531: FROM hz_cust_accounts ca
1532: , hz_parties party
1533: WHERE ca.party_id = party.party_id
1534: AND ca.cust_account_id = cv_cust_account_id;
1535:

Line 4961: FROM hz_parties p, hz_cust_accounts c

4957: l_close_claim_flag VARCHAR2(1);
4958:
4959: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
4960: SELECT p.party_name
4961: FROM hz_parties p, hz_cust_accounts c
4962: WHERE p.party_id = c.party_id
4963: AND c.cust_account_id = cv_cust_account_id;
4964:
4965: BEGIN

Line 5881: FROM hz_parties p, hz_cust_accounts c

5877: WHERE claim_id = cv_claim_id;
5878:
5879: CURSOR csr_party_name(cv_cust_account_id IN NUMBER) IS
5880: SELECT p.party_name
5881: FROM hz_parties p, hz_cust_accounts c
5882: WHERE p.party_id = c.party_id
5883: AND c.cust_account_id = cv_cust_account_id;
5884:
5885: --Added for bug 7030415

Line 6313: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca

6309:
6310: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
6311: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
6312: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
6313: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca
6314: WHERE tp.party_id = hca.party_id
6315: AND tp.cust_account_id IS NULL
6316: AND hca.cust_account_id = cv_cust_account_id;
6317:

Line 9364: FROM ozf_cust_trd_prfls p, hz_cust_accounts c

9360: WHERE cust_account_id = cv_cust_account_id;
9361:
9362: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
9363: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag
9364: FROM ozf_cust_trd_prfls p, hz_cust_accounts c
9365: WHERE p.party_id = c.party_id
9366: AND p.cust_account_id IS NULL
9367: AND c.cust_account_id = cv_cust_account_id;
9368: