DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_REPORTING_EXCEPTIONS

Line 6962: FROM PA_REPORTING_EXCEPTIONS

6958: l_submitter_user_id NUMBER;
6959:
6960: CURSOR sub_not_required_csr IS
6961: SELECT 'Y'
6962: FROM PA_REPORTING_EXCEPTIONS
6963: WHERE user_id = l_submitter_user_id
6964: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
6965: AND sub_context = 'MASS_APPROVAL'
6966: AND source_identifier1 = 'PAWFAAP'

Line 7340: FROM PA_REPORTING_EXCEPTIONS

7336: AND plks.lookup_code = p_override_basis_code;
7337:
7338: CURSOR count_error_asgns IS
7339: SELECT count( distinct ( attribute2))
7340: FROM PA_REPORTING_EXCEPTIONS
7341: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
7342: AND sub_context = 'MASS_APPROVAL'
7343: AND source_identifier1 = 'PAWFAAP'
7344: AND source_identifier2 = p_group_id;