DBA Data[Home] [Help]

APPS.CSL_CS_INCIDENTS_ALL_ACC_PKG dependencies on ASG_USER

Line 548: FROM ASG_USER au

544: )
545: IS
546: CURSOR c_incident( b_incident_id NUMBER ) IS
547: SELECT au.RESOURCE_ID
548: FROM ASG_USER au
549: , CS_INCIDENTS_ALL_B inc
550: WHERE au.USER_ID = inc.CREATED_BY
551: AND inc.INCIDENT_ID = b_incident_id;
552: r_incident c_incident%ROWTYPE;

Line 997: FROM ASG_USER au

993: , x_return_status OUT NOCOPY VARCHAR2 ) IS
994:
995: CURSOR c_incident( b_resource_id NUMBER ) IS
996: SELECT inc.INCIDENT_ID
997: FROM ASG_USER au
998: , CS_INCIDENTS_ALL_B inc
999: WHERE au.USER_ID = inc.CREATED_BY
1000: AND au.RESOURCE_ID = b_resource_id;
1001: r_incident c_incident%ROWTYPE;