521: usg.person_type_id = map.per_person_type_id AND
522: SYSDATE BETWEEN usg.effective_start_date and usg.effective_end_date AND
523: TRUNC(SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date;
524:
525: l_n_person_id hz_parties.party_id%TYPE;
526:
527: PROCEDURE print_fac_list(p_n_person_id hz_parties.party_id%TYPE,p_c_cal_type igs_ca_inst.cal_type%TYPE,p_n_cal_seq_num igs_ca_inst.sequence_number%TYPE) AS
528:
529: /* Cursor to get the person name */
523: TRUNC(SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date;
524:
525: l_n_person_id hz_parties.party_id%TYPE;
526:
527: PROCEDURE print_fac_list(p_n_person_id hz_parties.party_id%TYPE,p_c_cal_type igs_ca_inst.cal_type%TYPE,p_n_cal_seq_num igs_ca_inst.sequence_number%TYPE) AS
528:
529: /* Cursor to get the person name */
530:
531: CURSOR c_person_name(cp_n_person_id hz_parties.party_id%TYPE) IS
527: PROCEDURE print_fac_list(p_n_person_id hz_parties.party_id%TYPE,p_c_cal_type igs_ca_inst.cal_type%TYPE,p_n_cal_seq_num igs_ca_inst.sequence_number%TYPE) AS
528:
529: /* Cursor to get the person name */
530:
531: CURSOR c_person_name(cp_n_person_id hz_parties.party_id%TYPE) IS
532: SELECT hz.party_name
533: FROM hz_parties hz
534: WHERE party_id = cp_n_person_id AND
535: hz.status = 'A';
529: /* Cursor to get the person name */
530:
531: CURSOR c_person_name(cp_n_person_id hz_parties.party_id%TYPE) IS
532: SELECT hz.party_name
533: FROM hz_parties hz
534: WHERE party_id = cp_n_person_id AND
535: hz.status = 'A';
536:
537: l_c_person_name hz_parties.party_name%TYPE;
533: FROM hz_parties hz
534: WHERE party_id = cp_n_person_id AND
535: hz.status = 'A';
536:
537: l_c_person_name hz_parties.party_name%TYPE;
538:
539: BEGIN
540:
541: /* Getting Person name */