APPS.IGF_SL_DL_GEN_XML dependencies on HZ_PARTIES

Line 1445: lv_person_number hz_parties.party_number%TYPE;

1441: chk_pidgroup_rec cur_chk_pidgroup%ROWTYPE;
1442:
1443: lv_cal_type VARCHAR2(30);
1444: ln_seq_number NUMBER;
1445: lv_person_number hz_parties.party_number%TYPE;
1446:
1447: lb_record_exist BOOLEAN;
1448:
1449: l_list VARCHAR2(32767);

Line 1454: l_person_id hz_parties.party_id%TYPE;

1450: lv_status VARCHAR2(1);
1451: TYPE cur_person_id_type IS REF CURSOR;
1452: cur_per_grp cur_person_id_type;
1453:
1454: l_person_id hz_parties.party_id%TYPE;
1455: ln_base_id NUMBER;
1456: ln_top NUMBER;
1457: ln_sm NUMBER;
1458: ln_rs NUMBER;

Line 1750: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pgroup_id;

1746: l_list := igf_ap_ss_pkg.get_pid(p_pgroup_id,lv_status,lv_group_type);
1747:
1748: --Bug #5021084. Passing Group ID if the group type is STATIC.
1749: IF lv_group_type = 'STATIC' THEN
1750: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pgroup_id;
1751: ELSIF lv_group_type = 'DYNAMIC' THEN
1752: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
1753: END IF;
1754:

Line 1752: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';

1748: --Bug #5021084. Passing Group ID if the group type is STATIC.
1749: IF lv_group_type = 'STATIC' THEN
1750: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pgroup_id;
1751: ELSIF lv_group_type = 'DYNAMIC' THEN
1752: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
1753: END IF;
1754:
1755: FETCH cur_per_grp INTO l_person_id;
1756: