APPS.IGS_FI_GEN_004 dependencies on IGS_PS_VER

Line 849: p_c_career IN igs_ps_ver.course_type%TYPE,

845: p_trace_on IN VARCHAR2,
846: p_test_run IN VARCHAR2,
847: p_org_id NUMBER,
848: p_process_mode IN VARCHAR2,
849: p_c_career IN igs_ps_ver.course_type%TYPE,
850: p_d_gl_date IN VARCHAR2,
851: p_comments IN VARCHAR2
852: ) AS
853:

Line 1515: CURSOR cur_career (cp_course_cd IN igs_ps_ver.course_cd%type)

1511: SELECT fee_calc_mthd_code
1512: FROM igs_fi_control;
1513: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;
1514:
1515: CURSOR cur_career (cp_course_cd IN igs_ps_ver.course_cd%type)
1516: IS
1517: SELECT course_type
1518: FROM igs_ps_ver
1519: WHERE course_cd = cp_course_cd;

Line 1518: FROM igs_ps_ver

1514:
1515: CURSOR cur_career (cp_course_cd IN igs_ps_ver.course_cd%type)
1516: IS
1517: SELECT course_type
1518: FROM igs_ps_ver
1519: WHERE course_cd = cp_course_cd;
1520: l_course_type igs_ps_ver.course_type%TYPE;
1521: l_course_cd igs_ps_ver.course_cd%TYPE;
1522: l_n_waiver_amount NUMBER;

Line 1520: l_course_type igs_ps_ver.course_type%TYPE;

1516: IS
1517: SELECT course_type
1518: FROM igs_ps_ver
1519: WHERE course_cd = cp_course_cd;
1520: l_course_type igs_ps_ver.course_type%TYPE;
1521: l_course_cd igs_ps_ver.course_cd%TYPE;
1522: l_n_waiver_amount NUMBER;
1523:
1524:

Line 1521: l_course_cd igs_ps_ver.course_cd%TYPE;

1517: SELECT course_type
1518: FROM igs_ps_ver
1519: WHERE course_cd = cp_course_cd;
1520: l_course_type igs_ps_ver.course_type%TYPE;
1521: l_course_cd igs_ps_ver.course_cd%TYPE;
1522: l_n_waiver_amount NUMBER;
1523:
1524:
1525: BEGIN -- finpl_prc_reverse_fee_assess