APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_ACT_SITE

Line 1061: igs_pe_act_site usg

1057: AND usg.status = 'A'
1058: UNION
1059: SELECT 1
1060: FROM hz_locations adr,
1061: igs_pe_act_site usg
1062: WHERE usg.person_id = cp_person_id
1063: AND SYSDATE BETWEEN nvl(ADDRESS_EFFECTIVE_DATE,sysdate-1) AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE + 1)
1064: AND usg.location_id = adr.location_id
1065: AND adr.location_id = cp_party_site_id

Line 2434: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE

2430:
2431: Change History
2432: Who When What
2433: pkpatel 23-APR-2003 Bug No 2908378
2434: Replaced IGS_PE_ADDR_V with IGS_AD_LOCVENUE_ADDR_V while joining with IGS_PE_ACT_SITE
2435: Selected LOCATION_ID instead of PARTY_SITE_ID for these cases.
2436: Added p_data_rec(l_counter).party_site_id := c_addr_rec.party_site_id
2437: gmaheswa 12-Nov-2003 Modified c_addr cursor to select active address records,
2438: as part of address related changes .

Line 2499: igs_pe_act_site usg

2495: usg.primary_flag primary_site,
2496: usg.activity_site_cd activity_site_cd,
2497: usg.remarks remarks
2498: FROM HZ_LOCATIONS adr,
2499: igs_pe_act_site usg
2500: WHERE usg.person_id = p_person_rec.person_id
2501: AND SYSDATE BETWEEN nvl(ADDRESS_EFFECTIVE_DATE,sysdate-1) AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE + 1)
2502: AND usg.location_id = adr.location_id
2503: AND sysdate BETWEEN usg.start_date AND NVL(usg.end_date,sysdate+1);

Line 2561: igs_pe_act_site usg

2557: usg.primary_flag primary_site,
2558: usg.activity_site_cd activity_site_cd,
2559: usg.remarks remarks
2560: from HZ_LOCATIONS loc,
2561: igs_pe_act_site usg
2562: where
2563: usg.person_id = p_person_rec.person_id
2564: and (loc.ADDRESS_EXPIRATION_DATE is not null and loc.ADDRESS_EXPIRATION_DATE <= trunc(sysdate) )
2565: and usg.location_id = loc.location_id

Line 2584: FROM igs_pe_act_site a

2580: SELECT COUNT('X')
2581: FROM
2582: (
2583: SELECT a.location_id
2584: FROM igs_pe_act_site a
2585: WHERE a.person_id = p_person_rec.person_id AND
2586: a.primary_flag = 'Y' /*AND
2587: (a.end_date IS NULL OR sysdate between a.start_date and a.end_date)*/
2588: UNION

Line 2601: CURSOR c_activity_site(cp_person_id igs_pe_act_site.activity_site_cd%TYPE) IS

2597: AND adr.identifying_address_flag = 'Y'
2598: )
2599: ;
2600: /*
2601: CURSOR c_activity_site(cp_person_id igs_pe_act_site.activity_site_cd%TYPE) IS
2602: SELECT COUNT(a.activity_site_cd)
2603: FROM igs_pe_act_site a
2604: WHERE a.person_id = p_person_rec.person_id AND
2605: (a.end_date IS NULL OR sysdate between a.start_date and a.end_date);

Line 2603: FROM igs_pe_act_site a

2599: ;
2600: /*
2601: CURSOR c_activity_site(cp_person_id igs_pe_act_site.activity_site_cd%TYPE) IS
2602: SELECT COUNT(a.activity_site_cd)
2603: FROM igs_pe_act_site a
2604: WHERE a.person_id = p_person_rec.person_id AND
2605: (a.end_date IS NULL OR sysdate between a.start_date and a.end_date);
2606: */
2607: l_counter NUMBER(10) :=0;