APPS.JTF_RESOURCE_UTL dependencies on JTF_OBJECT_USAGES

Line 422: jtf_object_usages jou

418:
419: CURSOR c_resource_category IS
420: SELECT jo.object_code
421: FROM jtf_objects_b jo,
422: jtf_object_usages jou
423: WHERE jo.object_code = jou.object_code
424: AND jou.object_user_code = 'RESOURCE_CATEGORIES'
425: AND upper(jo.object_code) = upper(p_category)
426: AND trunc(nvl(jo.end_date_active, sysdate)) >= trunc(sysdate);

Line 1449: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1445: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1446: ) AS
1447:
1448: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1449: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1450: IS
1451: SELECT a.select_id
1452: ,a.from_table
1453: ,a.where_clause

Line 1455: jtf_object_usages b

1451: SELECT a.select_id
1452: ,a.from_table
1453: ,a.where_clause
1454: FROM jtf_objects_B a,
1455: jtf_object_usages b
1456: WHERE b.OBJECT_USER_CODE = l_object_user_code
1457: AND b.object_code = a.object_code
1458: and A.object_code = l_object_code;
1459:

Line 1462: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1458: and A.object_code = l_object_code;
1459:
1460: object_dtls_rec object_dtls_cur%rowtype;
1461:
1462: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1463: IS
1464: SELECT 'x'
1465: FROM jtf_object_usages b
1466: WHERE b.OBJECT_USER_CODE = l_object_user_code;

Line 1465: FROM jtf_object_usages b

1461:
1462: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1463: IS
1464: SELECT 'x'
1465: FROM jtf_object_usages b
1466: WHERE b.OBJECT_USER_CODE = l_object_user_code;
1467:
1468: object_code_rec object_code_cur%rowtype;
1469:

Line 1481: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;

1477:
1478: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1479: l_select_id number;
1480:
1481: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1482: l_select_clause VARCHAR2(4000);
1483:
1484: --FOR DYNAMIC SQL
1485: l_cursorid NUMBER;

Line 1639: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1635: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1636: ) AS
1637:
1638: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1639: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1640: IS
1641: SELECT a.select_id
1642: ,a.from_table
1643: ,a.where_clause

Line 1645: jtf_object_usages b

1641: SELECT a.select_id
1642: ,a.from_table
1643: ,a.where_clause
1644: FROM jtf_objects_B a,
1645: jtf_object_usages b
1646: WHERE b.OBJECT_USER_CODE = l_object_user_code
1647: AND b.object_code = a.object_code
1648: and A.object_code = l_object_code;
1649:

Line 1652: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1648: and A.object_code = l_object_code;
1649:
1650: object_dtls_rec object_dtls_cur%rowtype;
1651:
1652: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1653: IS
1654: SELECT 'x'
1655: FROM jtf_object_usages b
1656: WHERE b.OBJECT_USER_CODE = l_object_user_code;

Line 1655: FROM jtf_object_usages b

1651:
1652: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1653: IS
1654: SELECT 'x'
1655: FROM jtf_object_usages b
1656: WHERE b.OBJECT_USER_CODE = l_object_user_code;
1657:
1658: CURSOR emp_existence(p_person_id IN NUMBER)
1659: IS

Line 1678: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;

1674:
1675: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1676: l_select_id number;
1677:
1678: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1679: l_select_clause VARCHAR2(4000);
1680:
1681: --FOR DYNAMIC SQL
1682: l_cursorid NUMBER;