APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_TIMESLOT_PREF

Line 32: gpa_sort_ord igs_en_timeslot_pref.preference_code%TYPE;

28: ***************************************************************/
29:
30: plsql_empty plsql_table_1;
31: gpa_ord NUMBER := 0 ;
32: gpa_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
33: cpc_ord NUMBER := 0 ;
34: cpc_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
35: ecp_ord NUMBER := 0 ;
36: ecp_sort_ord igs_en_timeslot_pref.preference_code%TYPE;

Line 34: cpc_sort_ord igs_en_timeslot_pref.preference_code%TYPE;

30: plsql_empty plsql_table_1;
31: gpa_ord NUMBER := 0 ;
32: gpa_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
33: cpc_ord NUMBER := 0 ;
34: cpc_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
35: ecp_ord NUMBER := 0 ;
36: ecp_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
37:
38: cnt4 NUMBER := 0;

Line 36: ecp_sort_ord igs_en_timeslot_pref.preference_code%TYPE;

32: gpa_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
33: cpc_ord NUMBER := 0 ;
34: cpc_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
35: ecp_ord NUMBER := 0 ;
36: ecp_sort_ord igs_en_timeslot_pref.preference_code%TYPE;
37:
38: cnt4 NUMBER := 0;
39: plsql_4 plsql_table_2;
40: plsql_empty_4 plsql_table_2;

Line 1468: igs_en_timeslot_pref prf

1464:
1465: CURSOR cur_prty_pref(p_IGS_EN_TIMESLOT_STUP_ID NUMBER,p_order NUMBER) IS
1466: SELECT prt.priority_value,prf.preference_code,prf.preference_version,prf.sequence_number
1467: FROM igs_en_timeslot_prty prt,
1468: igs_en_timeslot_pref prf
1469: WHERE prt.IGS_EN_TIMESLOT_STUP_ID = p_IGS_EN_TIMESLOT_STUP_ID AND
1470: prt.priority_order = p_order AND
1471: prt.igs_en_timeslot_prty_id = prf.igs_en_timeslot_prty_id
1472: order by prt.priority_order, prf.preference_order;

Line 1670: igs_en_timeslot_pref prf

1666:
1667: CURSOR cur_prty_pref(p_IGS_EN_TIMESLOT_STUP_ID NUMBER,p_order NUMBER) IS
1668: SELECT prt.priority_value,prf.preference_code,prf.preference_version,prf.sequence_number
1669: FROM igs_en_timeslot_prty prt,
1670: igs_en_timeslot_pref prf
1671: WHERE prt.IGS_EN_TIMESLOT_STUP_ID = p_IGS_EN_TIMESLOT_STUP_ID AND
1672: prt.priority_order = p_order AND
1673: prt.igs_en_timeslot_prty_id = prf.igs_en_timeslot_prty_id
1674: order by prf.preference_order;