APPS.IGS_AD_GEN_011 dependencies on IGS_CO_LTR_PHR

Line 1625: cp_phrase_cd IGS_CO_LTR_PHR.phrase_cd%TYPE) IS

1621: aalp.letter_parameter_type = cp_letter_parameter_type
1622: ORDER BY aalp.phrase_order_number,
1623: aalp.sequence_number;
1624: CURSOR c_ltp (
1625: cp_phrase_cd IGS_CO_LTR_PHR.phrase_cd%TYPE) IS
1626: SELECT ltp.phrase_text
1627: FROM IGS_CO_LTR_PHR ltp
1628: WHERE ltp.phrase_cd = cp_phrase_cd;
1629: CURSOR c_get_nxt_seq IS

Line 1627: FROM IGS_CO_LTR_PHR ltp

1623: aalp.sequence_number;
1624: CURSOR c_ltp (
1625: cp_phrase_cd IGS_CO_LTR_PHR.phrase_cd%TYPE) IS
1626: SELECT ltp.phrase_text
1627: FROM IGS_CO_LTR_PHR ltp
1628: WHERE ltp.phrase_cd = cp_phrase_cd;
1629: CURSOR c_get_nxt_seq IS
1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;