APPS.IGS_EN_GEN_015 dependencies on IGS_PR_S_SCRATCH_PAD_V

Line 1410: FROM igs_pr_s_scratch_pad_v

1406: --
1407: CURSOR cur_crs_stg_result (cp_creation_dt DATE,cp_key_1 VARCHAR2,cp_key_2 VARCHAR2,cp_key_3 VARCHAR2,
1408: cp_key_4 VARCHAR2,cp_key_5 VARCHAR2,cp_key_6 VARCHAR2) IS
1409: SELECT text_1
1410: FROM igs_pr_s_scratch_pad_v
1411: WHERE creation_dt = cp_creation_dt AND
1412: (cp_key_1 IS NULL OR
1413: key_1 = cp_key_1) AND
1414: (cp_key_2 IS NULL OR

Line 1427: l_crs_stg_result_rec igs_pr_s_scratch_pad_v.text_1%TYPE;

1423: key_6 = cp_key_6);
1424: --
1425: l_cur_seq_num igs_ps_stage.sequence_number%TYPE;
1426: lv_message_name VARCHAR2(30);
1427: l_crs_stg_result_rec igs_pr_s_scratch_pad_v.text_1%TYPE;
1428: lv_log_dt DATE;
1429: --
1430: BEGIN
1431: OPEN cur_seq_num;