APPS.IGF_GR_GEN_XML dependencies on HZ_PARTIES

Line 1470: lv_person_number hz_parties.party_number%TYPE;

1466: lv_status VARCHAR2(1);
1467: l_ci_cal_type VARCHAR2(11);
1468: l_ci_sequence_number NUMBER;
1469: ln_base_id NUMBER;
1470: lv_person_number hz_parties.party_number%TYPE;
1471: l_person_id hz_parties.party_id%TYPE;
1472: l_list VARCHAR2(32767);
1473: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1474:

Line 1471: l_person_id hz_parties.party_id%TYPE;

1467: l_ci_cal_type VARCHAR2(11);
1468: l_ci_sequence_number NUMBER;
1469: ln_base_id NUMBER;
1470: lv_person_number hz_parties.party_number%TYPE;
1471: l_person_id hz_parties.party_id%TYPE;
1472: l_list VARCHAR2(32767);
1473: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1474:
1475: BEGIN

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

1547: l_list := igf_ap_ss_pkg.get_pid(p_persid_grp,lv_status,lv_group_type);
1548:
1549: --Bug #5021084. Passing Group ID if the group type is STATIC.
1550: IF lv_group_type = 'STATIC' THEN
1551: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_persid_grp;
1552: ELSIF lv_group_type = 'DYNAMIC' THEN
1553: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
1554: END IF;
1555:

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

1549: --Bug #5021084. Passing Group ID if the group type is STATIC.
1550: IF lv_group_type = 'STATIC' THEN
1551: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_persid_grp;
1552: ELSIF lv_group_type = 'DYNAMIC' THEN
1553: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
1554: END IF;
1555:
1556: FETCH cur_per_grp INTO l_person_id;
1557: