DBA Data[Home] [Help]

APPS.ASO_PA_APR_INT dependencies on ASO_LOOKUPS

Line 445: from aso_lookups

441: x_approvers_list ( m).approver_Status := approvers2(i).approval_status;
442: else
443: Select meaning
444: into x_approvers_list( m).approver_Status
445: from aso_lookups
446: where lookup_type = 'ASO_APPROVER_STATUS'
447: and lookup_code = l_appr_status_code
448: and enabled_flag='Y'
449: And trunc(nvl(start_date_active, sysdate-1)) <= trunc(sysdate)

Line 2069: from aso_lookups

2065:
2066: if (c1.approver_status is not null) then
2067: Select meaning
2068: into l_approval_status_desc
2069: from aso_lookups
2070: where lookup_type = 'ASO_APPROVER_STATUS'
2071: and lookup_code = c1.approver_status
2072: and enabled_flag='Y'
2073: And trunc(nvl(start_date_active, sysdate-1)) <= trunc(sysdate)