APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_EN_DCNT_REASONCD_V

Line 85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all

81:
82: -- Cursor for validation of the Discontinuation Reason Code
83: CURSOR cur_dcnt_reason_cd(cp_dcnt_reason_cd IN VARCHAR2) IS
84: SELECT description
85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all
86: FROM igs_en_dcnt_reasoncd_all
87: WHERE discontinuation_reason_cd = cp_dcnt_reason_cd
88: AND closed_ind = g_no_ind
89: AND dcnt_unit_ind = g_yes_ind;

Line 99: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%TYPE,

95: p_fee_period IN VARCHAR2,
96: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
97: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
98: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
99: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%TYPE,
100: p_test_run IN VARCHAR2
101: ) RETURN BOOLEAN IS
102: /***************************************************
103: Created By : [email protected]

Line 166: l_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;

162: l_flag BOOLEAN;
163: rec_cur_person_id cur_person_id%ROWTYPE;
164: l_test_run igs_lookups_view.meaning%TYPE;
165: l_balance_type_meaning igs_lookups_view.meaning%TYPE;
166: l_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
167: l_person_grp_cd igs_pe_persid_group.group_cd%TYPE;
168:
169: BEGIN
170: l_flag := TRUE;

Line 280: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%type,

276: p_person_id IN igs_pe_person.person_id%type,
277: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%type,
278: p_FEE_PERIOD IN VARCHAR2,
279: p_balance_type IN igs_fi_balance_rules.balance_name%type,
280: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%type,
281: p_test_run IN VARCHAR2
282: ) AS
283:
284:

Line 513: l_v_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;

509: l_n_pp_person_id igs_fi_parties_v.person_id%TYPE;
510: e_skip_record EXCEPTION;
511: l_b_proceed BOOLEAN;
512:
513: l_v_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
514:
515: --Bug 5123583, variable declared to fetch calendar description from cur_get_cal_inst_desc.
516: l_v_cal_inst_desc igs_ca_inst_all.description%TYPE := NULL;
517: