APPS.AS_RESOURCE_MERGE_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 44: select resource_id from jtf_rs_resource_extns

40: l_length NUMBER;
41: l_sysdate VARCHAR2(100) := TO_CHAR(SYSDATE,'DD-MON-YYYY-HH:MI:SS');
42:
43: cursor c_get_from_resource (c_resource_id NUMBER) is
44: select resource_id from jtf_rs_resource_extns
45: where category in ('PARTNER', 'PARTY')
46: and source_id =
47: (select party_id from hz_relationships
48: where relationship_id=

Line 55: from jtf_rs_resource_extns

51: (select relationship_id
52: from hz_relationships
53: where party_id=
54: (select source_id
55: from jtf_rs_resource_extns
56: where resource_id=c_resource_id) ) ) );
57:
58: l_to_resource_id NUMBER;
59: