APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AS_ASSESSMNT_ITM

Line 2510: FROM igs_as_assessmnt_itm

2506: l_c_var VARCHAR2(1);
2507:
2508: CURSOR cur_ass_desc(cp_assessment_id NUMBER) IS
2509: SELECT description
2510: FROM igs_as_assessmnt_itm
2511: WHERE ass_id = cp_assessment_id;
2512: l_cur_ass_desc cur_ass_desc%ROWTYPE;
2513:
2514: BEGIN

Line 2700: CURSOR c_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE)IS

2696: END Assign_default;
2697:
2698: -- Validate Database Constraints
2699: PROCEDURE validate_db_cons_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2700: CURSOR c_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE)IS
2701: SELECT 'X'
2702: FROM igs_as_assessmnt_itm
2703: WHERE ass_id =cp_assessment_id;
2704:

Line 2702: FROM igs_as_assessmnt_itm

2698: -- Validate Database Constraints
2699: PROCEDURE validate_db_cons_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2700: CURSOR c_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE)IS
2701: SELECT 'X'
2702: FROM igs_as_assessmnt_itm
2703: WHERE ass_id =cp_assessment_id;
2704:
2705: c_assessment_id_rec c_assessment_id%ROWTYPE;
2706: BEGIN