DBA Data[Home] [Help]

APPS.ASO_APR_WF_PVT dependencies on ASO_LOOKUPS

Line 3985: FROM aso_apr_approval_details apd, aso_lookups fl

3981: CURSOR approver_details (
3982: c_object_approval_id NUMBER
3983: ) IS
3984: SELECT approver_user_id, approver_person_id, fl.meaning, approver_comments
3985: FROM aso_apr_approval_details apd, aso_lookups fl
3986: WHERE apd.approver_status = fl.lookup_code
3987: AND object_approval_id = c_object_approval_id
3988: AND fl.lookup_type = 'ASO_APPROVER_STATUS'
3989: ORDER BY approver_sequence;