APPS.JTF_RESOURCE_UTL dependencies on JTF_OBJECT_USAGES

Line 420: jtf_object_usages jou

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

Line 1445: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1441: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1442: ) AS
1443:
1444: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1445: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1446: IS
1447: SELECT a.select_id
1448: ,a.from_table
1449: ,a.where_clause

Line 1451: jtf_object_usages b

1447: SELECT a.select_id
1448: ,a.from_table
1449: ,a.where_clause
1450: FROM jtf_objects_B a,
1451: jtf_object_usages b
1452: WHERE b.OBJECT_USER_CODE = l_object_user_code
1453: AND b.object_code = a.object_code
1454: and A.object_code = l_object_code;
1455:

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

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

Line 1461: FROM jtf_object_usages b

1457:
1458: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1459: IS
1460: SELECT 'x'
1461: FROM jtf_object_usages b
1462: WHERE b.OBJECT_USER_CODE = l_object_user_code;
1463:
1464: object_code_rec object_code_cur%rowtype;
1465:

Line 1477: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;

1473:
1474: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1475: l_select_id number;
1476:
1477: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1478: l_select_clause VARCHAR2(4000);
1479:
1480: --FOR DYNAMIC SQL
1481: l_cursorid NUMBER;

Line 1635: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)

1631: X_RETURN_STATUS OUT NOCOPY VARCHAR2
1632: ) AS
1633:
1634: CURSOR object_dtls_cur(l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE,
1635: l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1636: IS
1637: SELECT a.select_id
1638: ,a.from_table
1639: ,a.where_clause

Line 1641: jtf_object_usages b

1637: SELECT a.select_id
1638: ,a.from_table
1639: ,a.where_clause
1640: FROM jtf_objects_B a,
1641: jtf_object_usages b
1642: WHERE b.OBJECT_USER_CODE = l_object_user_code
1643: AND b.object_code = a.object_code
1644: and A.object_code = l_object_code;
1645:

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

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

Line 1651: FROM jtf_object_usages b

1647:
1648: CURSOR object_code_cur(l_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%TYPE)
1649: IS
1650: SELECT 'x'
1651: FROM jtf_object_usages b
1652: WHERE b.OBJECT_USER_CODE = l_object_user_code;
1653:
1654: CURSOR emp_existence(p_person_id IN NUMBER)
1655: IS

Line 1674: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;

1670:
1671: l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE;
1672: l_select_id number;
1673:
1674: ll_object_user_code JTF_OBJECT_USAGES.OBJECT_USER_CODE%type;
1675: l_select_clause VARCHAR2(4000);
1676:
1677: --FOR DYNAMIC SQL
1678: l_cursorid NUMBER;