DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_REPORTING_EXCEPTIONS

Line 6978: FROM PA_REPORTING_EXCEPTIONS

6974: l_submitter_user_id NUMBER;
6975:
6976: CURSOR sub_not_required_csr IS
6977: SELECT 'Y'
6978: FROM PA_REPORTING_EXCEPTIONS
6979: WHERE user_id = l_submitter_user_id
6980: AND context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
6981: AND sub_context = 'MASS_APPROVAL'
6982: AND source_identifier1 = 'PAWFAAP'

Line 7356: FROM PA_REPORTING_EXCEPTIONS

7352: AND plks.lookup_code = p_override_basis_code;
7353:
7354: CURSOR count_error_asgns IS
7355: SELECT count( distinct ( attribute2))
7356: FROM PA_REPORTING_EXCEPTIONS
7357: WHERE context = PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1
7358: AND sub_context = 'MASS_APPROVAL'
7359: AND source_identifier1 = 'PAWFAAP'
7360: AND source_identifier2 = p_group_id;