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.CSC_PROFILE_ENGINE_PKG dependencies on HZ_PARTY_SITES

Line 685: FROM hz_party_sites hz

681: SELECT hz.party_id,
682: NULL,
683: hz.party_site_id ,
684: NULL
685: FROM hz_party_sites hz
686: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
687: WHERE c.party_id = hz.party_id
688: and c.party_site_id = hz.party_site_id)
689: AND hz.status = 'A'

Line 1031: FROM hz_party_sites

1027: AND status = 'A' ;
1028: -- Begin fix by spamujul for NCR ER#8473903
1029: CURSOR cpsite_csr IS
1030: SELECT party_id, party_site_id
1031: FROM hz_party_sites
1032: WHERE party_id=v_party_id
1033: AND status = 'A'
1034: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
1035: -- End fix by spamujul for NCR ER#8473903

Line 1488: FROM hz_party_sites

1484: AND status = 'A';
1485: -- Begin fix by spamujul for ER#8473903
1486: CURSOR cpsite_csr IS
1487: SELECT party_id, party_site_id
1488: FROM hz_party_sites
1489: WHERE party_id=v_party_id
1490: AND status = 'A'
1491: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
1492: -- End fix by spamujul for ER#8473903

Line 1998: FROM HZ_PARTY_SITES

1994: -- Begin fix by spamujul for ER#8473903
1995: CURSOR cpsite_csr IS
1996: SELECT party_id,
1997: party_site_id
1998: FROM HZ_PARTY_SITES
1999: WHERE party_id = v_party_id
2000: AND status ='A'
2001: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
2002: -- End fix by spamujul for ER#8473903

Line 2814: FROM HZ_PARTY_SITES

2810: AND status = 'A' ;
2811: -- Begin fix by spamujul for ER#8473903
2812: CURSOR cpsite_csr IS
2813: SELECT party_id,party_site_id
2814: FROM HZ_PARTY_SITES
2815: WHERE party_id = p_party_id
2816: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
2817: -- End fix by spamujul for ER#8473903
2818:

Line 3897: FROM hz_party_sites hz

3893: ACCOUNT_ID,
3894: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3895: VALUE)
3896: SELECT hz.party_id, NULL, hz.party_site_id ,NULL -- Included NULL for party_site_id for ER#8473903
3897: FROM hz_party_sites hz
3898: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id and c.party_site_id = hz.party_site_id)
3899: AND hz.status = 'A'
3900: AND nvl(hz.created_by_module,'XXX') <> 'SR_ONETIME';
3901: -- End fix by spamujul for ER#8473903

Line 4254: FROM hz_party_sites

4250: AND status = 'A' ;
4251: -- Begin fix by spamujul for NCR ER#8473903
4252: CURSOR cpsite_csr IS
4253: SELECT party_id, party_site_id
4254: FROM hz_party_sites
4255: WHERE party_id=v_party_id
4256: AND status = 'A'
4257: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
4258: -- End fix by spamujul for NCR ER#8473903

Line 4700: FROM hz_party_sites

4696: AND status = 'A' ;
4697: -- Begin fix by spamujul for ER#8473903
4698: CURSOR cpsite_csr IS
4699: SELECT party_id, party_site_id
4700: FROM hz_party_sites
4701: WHERE party_id=v_party_id
4702: AND status = 'A'
4703: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
4704: -- End fix by spamujul for ER#8473903

Line 5853: FROM hz_party_sites

5849:
5850: -- Begin fix by spamujul for NCR ER#8473903
5851: CURSOR bpsite_csr IS
5852: SELECT party_id, party_site_id
5853: FROM hz_party_sites
5854: WHERE party_id=v_party_id
5855: AND status = 'A'
5856: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
5857: -- End fix by spamujul for NCR ER#8473903

Line 6150: FROM HZ_PARTY_SITES

6146: -- Begin fx by spamujul for ER#8473903
6147: CURSOR bpsite_csr IS
6148: SELECT party_id,
6149: party_site_id
6150: FROM HZ_PARTY_SITES
6151: WHERE party_id = v_party_id
6152: AND status ='A'
6153: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
6154: -- End fx by spamujul for ER#8473903

Line 6419: FROM hz_party_sites

6415: AND status = 'A' ;
6416: -- Begin fix by spamujul for NCR ER#8473903
6417: CURSOR bpsite_csr IS
6418: SELECT party_id, party_site_id
6419: FROM hz_party_sites
6420: WHERE party_id=v_party_id
6421: AND status = 'A'
6422: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
6423: -- End fix by spamujul for NCR ER#8473903

Line 6743: FROM HZ_PARTY_SITES

6739: -- Begin fix by spamujul for ER#8473903
6740: CURSOR bpsite_csr IS
6741: SELECT party_id,
6742: party_site_id
6743: FROM HZ_PARTY_SITES
6744: WHERE party_id = v_party_id
6745: AND status ='A'
6746: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
6747: -- End fix by spamujul for ER#8473903

Line 7029: FROM HZ_PARTY_SITES

7025: -- Begin fx by spamujul for ER#8473903
7026: CURSOR bpsite_csr IS
7027: SELECT party_id,
7028: party_site_id
7029: FROM HZ_PARTY_SITES
7030: WHERE party_id = v_party_id
7031: AND status ='A'
7032: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
7033: -- End fx by spamujul for ER#8473903

Line 7291: FROM hz_party_sites

7287: AND Nvl(end_date_active, Sysdate));
7288: -- Begin fix by spamujul for NCR ER#8473903
7289: CURSOR bpsite_csr IS
7290: SELECT party_id, party_site_id
7291: FROM hz_party_sites
7292: WHERE party_id=v_party_id
7293: AND status = 'A'
7294: AND NVL(created_by_module,'XXX') <> 'SR_ONETIME';
7295: -- End fix by spamujul for NCR ER#8473903

Line 7460: FROM HZ_PARTY_SITES

7456: -- Begin fix by spamujul for ER#8473903
7457: CURSOR bpsite_csr IS
7458: SELECT party_id,
7459: party_site_id
7460: FROM HZ_PARTY_SITES
7461: WHERE party_id = v_party_id
7462: AND status ='A'
7463: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
7464: -- End fix by spamujul for ER#8473903

Line 7773: FROM HZ_PARTY_SITES

7769: -- Begin fix by spamujul for ER#8473903
7770: CURSOR cpsite_csr IS
7771: SELECT party_id,
7772: party_site_id
7773: FROM HZ_PARTY_SITES
7774: WHERE party_id = v_party_id
7775: AND status ='A'
7776: AND NVL(created_by_module,'XXX') <>'SR_ONETIME';
7777: -- End fix by spamujul for ER#8473903