DBA Data[Home] [Help]

APPS.ASO_APR_WF_PVT dependencies on ASO_LOOKUPS

Line 3955: FROM aso_apr_approval_details apd, aso_lookups fl

3951: CURSOR approver_details (
3952: c_object_approval_id NUMBER
3953: ) IS
3954: SELECT approver_user_id, approver_person_id, fl.meaning, approver_comments
3955: FROM aso_apr_approval_details apd, aso_lookups fl
3956: WHERE apd.approver_status = fl.lookup_code
3957: AND object_approval_id = c_object_approval_id
3958: AND fl.lookup_type = 'ASO_APPROVER_STATUS'
3959: ORDER BY approver_sequence;