APPS.JTF_RESOURCE_UTL dependencies on FND_LOOKUPS

Line 358: FROM fnd_lookups

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

Line 956: FROM fnd_lookups

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

Line 1996: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

1992: )
1993: IS
1994:
1995: l_value JTF_RS_RESOURCE_VALUES.VALUE%TYPE;
1996: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
1997: v_type VARCHAR2(32);
1998: v_length VARCHAR2(32);
1999: p_length NUMBER;
2000: i NUMBER;

Line 2004: FROM fnd_lookups fnl, jtf_rs_resource_params jrp

2000: i NUMBER;
2001:
2002: CURSOR c_lookup_code IS
2003: SELECT lookup_code
2004: FROM fnd_lookups fnl, jtf_rs_resource_params jrp
2005: WHERE fnl.lookup_type = jrp.domain_lookup_type
2006: AND jrp.resource_param_id = p_resource_param_id
2007: AND lookup_code = p_value;
2008: