APPS.JTF_RESOURCE_UTL dependencies on FND_LOOKUPS

Line 356: FROM fnd_lookups

352: l_usage jtf_rs_group_usages.usage%TYPE;
353:
354: CURSOR c_usage(p_lookup_type in varchar2,p_enabled_flag in varchar2) IS
355: SELECT lookup_code
356: FROM fnd_lookups
357: WHERE lookup_type = p_lookup_type
358: AND upper(lookup_code) = upper(p_usage)
359: AND trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
360: AND enabled_flag = p_enabled_flag;

Line 954: FROM fnd_lookups

950: l_hold_reason_code VARCHAR2(30);
951:
952: CURSOR c_hold_reason_code IS
953: SELECT lookup_code
954: FROM fnd_lookups
955: WHERE lookup_type = 'JTF_RS_HOLD_REASON_TYPE'
956: AND lookup_code = p_hold_reason_code;
957:
958: BEGIN

Line 1992: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

1988: )
1989: IS
1990:
1991: l_value JTF_RS_RESOURCE_VALUES.VALUE%TYPE;
1992: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
1993: v_type VARCHAR2(32);
1994: v_length VARCHAR2(32);
1995: p_length NUMBER;
1996: i NUMBER;

Line 2000: FROM fnd_lookups fnl, jtf_rs_resource_params jrp

1996: i NUMBER;
1997:
1998: CURSOR c_lookup_code IS
1999: SELECT lookup_code
2000: FROM fnd_lookups fnl, jtf_rs_resource_params jrp
2001: WHERE fnl.lookup_type = jrp.domain_lookup_type
2002: AND jrp.resource_param_id = p_resource_param_id
2003: AND lookup_code = p_value;
2004: