APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_FI_WAV_STD_PGMS

Line 39: l_person_id igs_fi_wav_std_pgms.person_id%TYPE,

35:
36: v_ftci_rec c_ftci%ROWTYPE;
37:
38: CURSOR c1 (
39: l_person_id igs_fi_wav_std_pgms.person_id%TYPE,
40: l_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
41: l_fee_ci_sequence_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE
42: )
43: IS

Line 40: l_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,

36: v_ftci_rec c_ftci%ROWTYPE;
37:
38: CURSOR c1 (
39: l_person_id igs_fi_wav_std_pgms.person_id%TYPE,
40: l_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
41: l_fee_ci_sequence_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE
42: )
43: IS
44: SELECT 'X'

Line 41: l_fee_ci_sequence_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE

37:
38: CURSOR c1 (
39: l_person_id igs_fi_wav_std_pgms.person_id%TYPE,
40: l_fee_cal_type igs_fi_wav_std_pgms.fee_cal_type%TYPE,
41: l_fee_ci_sequence_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE
42: )
43: IS
44: SELECT 'X'
45: FROM igs_fi_wav_std_pgms

Line 45: FROM igs_fi_wav_std_pgms

41: l_fee_ci_sequence_number igs_fi_wav_std_pgms.fee_ci_sequence_number%TYPE
42: )
43: IS
44: SELECT 'X'
45: FROM igs_fi_wav_std_pgms
46: WHERE person_id = l_person_id
47: AND fee_cal_type = l_fee_cal_type
48: AND fee_ci_sequence_number = l_fee_ci_sequence_number
49: AND assignment_status_code = 'ACTIVE';