DBA Data[Home] [Help]

APPS.IGS_AS_DOC_DETAILS_PKG dependencies on IGS_AS_DOCPROC_STUP

Line 2732: FROM igs_as_docproc_stup;

2728: --
2729: DECLARE
2730: CURSOR cur_admin_to_notify IS
2731: SELECT administrator_id
2732: FROM igs_as_docproc_stup;
2733: CURSOR cur_person_details (cp_party_id IN NUMBER) IS
2734: SELECT party_number,
2735: party_name
2736: FROM hz_parties

Line 2738: l_admin_to_notify igs_as_docproc_stup.administrator_id%TYPE;

2734: SELECT party_number,
2735: party_name
2736: FROM hz_parties
2737: WHERE party_id = cp_party_id;
2738: l_admin_to_notify igs_as_docproc_stup.administrator_id%TYPE;
2739: rec_person_details cur_person_details%ROWTYPE;
2740: BEGIN
2741: OPEN cur_admin_to_notify;
2742: FETCH cur_admin_to_notify INTO l_admin_to_notify;