APPS.HR_DE_GENERAL dependencies on PQH_DE_INS_END_REASONS

Line 400: SELECT end_reason_number FROM pqh_de_ins_end_reasons

396: --
397: FUNCTION get_end_reason_no(p_end_reason_id in number)
398: RETURN number is
399: CURSOR c1(p_end_reason_id in number) IS
400: SELECT end_reason_number FROM pqh_de_ins_end_reasons
401: WHERE ins_end_reason_id = p_end_reason_id;
402: l_end_reason_no PQH_DE_INS_END_REASONS.END_REASON_NUMBER%TYPE;
403: --
404: BEGIN

Line 402: l_end_reason_no PQH_DE_INS_END_REASONS.END_REASON_NUMBER%TYPE;

398: RETURN number is
399: CURSOR c1(p_end_reason_id in number) IS
400: SELECT end_reason_number FROM pqh_de_ins_end_reasons
401: WHERE ins_end_reason_id = p_end_reason_id;
402: l_end_reason_no PQH_DE_INS_END_REASONS.END_REASON_NUMBER%TYPE;
403: --
404: BEGIN
405: OPEN c1(p_end_reason_id);
406: FETCH c1 INTO l_end_reason_no ;

Line 419: SELECT end_reason_description FROM pqh_de_ins_end_reasons

415: --
416: FUNCTION get_end_reason_desc(p_end_reason_id in number)
417: RETURN varchar2 is
418: CURSOR c1(p_end_reason_id in number) IS
419: SELECT end_reason_description FROM pqh_de_ins_end_reasons
420: WHERE ins_end_reason_id = p_end_reason_id;
421: l_end_reason_desc PQH_DE_INS_END_REASONS.END_REASON_DESCRIPTION%TYPE;
422: --
423: BEGIN

Line 421: l_end_reason_desc PQH_DE_INS_END_REASONS.END_REASON_DESCRIPTION%TYPE;

417: RETURN varchar2 is
418: CURSOR c1(p_end_reason_id in number) IS
419: SELECT end_reason_description FROM pqh_de_ins_end_reasons
420: WHERE ins_end_reason_id = p_end_reason_id;
421: l_end_reason_desc PQH_DE_INS_END_REASONS.END_REASON_DESCRIPTION%TYPE;
422: --
423: BEGIN
424: OPEN c1(p_end_reason_id);
425: FETCH c1 INTO l_end_reason_desc;