[Home] [Help]
3573: SELECT COUNT(1)
3574: FROM igs_pe_nonimg_stat
3575: WHERE nonimg_form_id = p_person_rec.form_id
3576: AND p_term_reason NOT IN
3577: ( SELECT lookup_code FROM igs_lookup_values
3578: WHERE lookup_type ='PE_SV_TERMINATE_REASON' AND
3579: enabled_flag ='Y' AND
3580: (tag= p_visa OR tag= 'FM')
3581: );
13515:
13516: l_api_name CONSTANT VARCHAR(30) := 'xml_log_file';
13517: l_per_count NUMBER(5) := 0;
13518: l_person_num hz_parties.party_number%TYPE;
13519: l_info_meaning igs_lookup_values.meaning%TYPE;
13520:
13521: CURSOR c_updated_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13522: IS
13523: SELECT summ.person_id, summ.tag_code
13548:
13549: CURSOR c_get_info(cp_tag_code igs_sv_btch_summary.tag_code%TYPE)
13550: IS
13551: SELECT lkp.meaning info
13552: FROM igs_lookup_values lkp
13553: WHERE lkp.lookup_code = cp_tag_code
13554: AND lkp.lookup_type ='IGS_SV_COMP_TREE';
13555: BEGIN
13556:
13641:
13642: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13643: IS
13644: SELECT hz.party_number prsn_num, lkp.meaning info
13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13646: WHERE svbs.batch_id = cp_batch_id
13647: AND svbs.person_id = hz.party_id
13648: AND svbs.tag_code = lkp.lookup_code
13649: AND lkp.lookup_type ='IGS_SV_COMP_TREE'
13654:
13655: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13656: IS
13657: SELECT hz.party_number prsn_num, lkp.meaning info
13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13659: WHERE svbs.batch_id = cp_batch_id
13660: AND svbs.person_id = hz.party_id
13661: AND svbs.tag_code = lkp.lookup_code
13662: AND lkp.lookup_type ='IGS_SV_COMP_TREE'