APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_PE_PERSID_GROUP_ALL

Line 549: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,

545: END chk_non_credit_course;
546:
547: PROCEDURE log_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
548: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
549: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,
550: p_v_override_excl VARCHAR2,
551: p_v_file_addr_correction VARCHAR2,
552: p_v_test_run VARCHAR2) AS
553:

Line 565: CURSOR cur_persid_grp(cp_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE) IS

561: Who When What
562: ***************************************************************** */
563: l_v_party_number hz_parties.party_number%TYPE;
564:
565: CURSOR cur_persid_grp(cp_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
566: SELECT group_cd
567: FROM igs_pe_persid_group_all
568: WHERE group_id = cp_n_person_grp_id;
569:

Line 567: FROM igs_pe_persid_group_all

563: l_v_party_number hz_parties.party_number%TYPE;
564:
565: CURSOR cur_persid_grp(cp_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE) IS
566: SELECT group_cd
567: FROM igs_pe_persid_group_all
568: WHERE group_id = cp_n_person_grp_id;
569:
570: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
571: BEGIN

Line 570: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;

566: SELECT group_cd
567: FROM igs_pe_persid_group_all
568: WHERE group_id = cp_n_person_grp_id;
569:
570: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
571: BEGIN
572:
573: -- Log the parameters
574: fnd_file.put_line(fnd_file.log,

Line 606: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,

602: END log_params;
603:
604: FUNCTION validate_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
605: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
606: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,
607: p_v_override_excl VARCHAR2,
608: p_v_file_addr_correction VARCHAR2,
609: p_v_test_run VARCHAR2) RETURN BOOLEAN AS
610: /******************************************************************

Line 627: CURSOR cur_val_persgrp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE,

623: SELECT 'x'
624: FROM igs_pe_person_base_v
625: WHERE person_id = cp_n_person_id;
626:
627: CURSOR cur_val_persgrp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE,
628: cp_v_closed_ind igs_pe_persid_group_all.closed_ind%TYPE) IS
629: SELECT 'x'
630: FROM igs_pe_persid_group_all
631: WHERE group_id = cp_n_pers_grp_id

Line 628: cp_v_closed_ind igs_pe_persid_group_all.closed_ind%TYPE) IS

624: FROM igs_pe_person_base_v
625: WHERE person_id = cp_n_person_id;
626:
627: CURSOR cur_val_persgrp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE,
628: cp_v_closed_ind igs_pe_persid_group_all.closed_ind%TYPE) IS
629: SELECT 'x'
630: FROM igs_pe_persid_group_all
631: WHERE group_id = cp_n_pers_grp_id
632: AND closed_ind = cp_v_closed_ind;

Line 630: FROM igs_pe_persid_group_all

626:
627: CURSOR cur_val_persgrp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE,
628: cp_v_closed_ind igs_pe_persid_group_all.closed_ind%TYPE) IS
629: SELECT 'x'
630: FROM igs_pe_persid_group_all
631: WHERE group_id = cp_n_pers_grp_id
632: AND closed_ind = cp_v_closed_ind;
633:
634: CURSOR cur_val_one_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS