DBA Data[Home] [Help]

APPS.AMV_WFAPPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 47: from JTF_RS_RESOURCE_EXTNS RD

43: where item_id = ItemId;
44:
45: CURSOR Requestor_Name IS
46: select FND.USER_NAME
47: from JTF_RS_RESOURCE_EXTNS RD
48: , FND_USER FND
49: where RD.USER_ID = FND.USER_ID
50: and RD.RESOURCE_ID = RequestorId;
51:

Line 524: from JTF_RS_RESOURCE_EXTNS RD

520: --
521: -- NOTE Remove PPX relation in the cursor
522: CURSOR Chan_Approvers(chn_id NUMBER) IS
523: select FND1.USER_NAME
524: from JTF_RS_RESOURCE_EXTNS RD
525: , FND_USER FND1
526: , AMV_C_CHANNELS_B CHN
527: where RD.USER_ID = FND1.USER_ID
528: and RD.RESOURCE_ID = CHN.DEFAULT_APPROVER_USER_ID