APPS.IGS_EN_GEN_009 dependencies on IGS_EN_MRG_ID_ACT_CH

Line 553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,

549: obsolete_id_row_info IGS_EN_MERGE_ID_ROWS.obsolete_id_row_info%TYPE,
550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,
554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );
555: v_merge_record t_merge_type;
556: CURSOR c_get_merge_data IS
557: SELECT smir.obsolete_person_id,

Line 554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );

550: current_person_id IGS_EN_MERGE_ID_ROWS.current_person_id%TYPE,
551: current_id_row_info IGS_EN_MERGE_ID_ROWS.current_id_row_info%TYPE,
552: table_alias IGS_EN_MERGE_ID_ROWS.table_alias%TYPE,
553: action_id IGS_EN_MRG_ID_ACT_CH.action_id%TYPE,
554: perform_action_id IGS_EN_MRG_ID_ACT_CH.perform_action_ind%TYPE );
555: v_merge_record t_merge_type;
556: CURSOR c_get_merge_data IS
557: SELECT smir.obsolete_person_id,
558: smir.obsolete_id_row_info,

Line 564: FROM IGS_EN_MERGE_ID_ROWS smir, IGS_EN_MRG_ID_ACT_CH smiac

560: smir.current_id_row_info,
561: smir.table_alias,
562: smiac.action_id,
563: smiac.perform_action_ind
564: FROM IGS_EN_MERGE_ID_ROWS smir, IGS_EN_MRG_ID_ACT_CH smiac
565: WHERE smir.smir_id = p_smir_id AND
566: smir.smir_id = smiac.smir_id;
567: l_seqval NUMBER;
568: