APPS.PA_ASGMT_WFSTD dependencies on PA_LOOKUPS

Line 126: FROM pa_lookups plks

122: WHERE assignment_id = p_assignment_id;
123:
124: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
125: SELECT plks.meaning
126: FROM pa_lookups plks
127: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
128: AND plks.lookup_code = p_override_basis_code;
129:
130: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS

Line 4873: FROM pa_lookups plks

4869: WHERE assignment_id = p_assignment_id;
4870:
4871: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4872: SELECT plks.meaning
4873: FROM pa_lookups plks
4874: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
4875: AND plks.lookup_code = p_override_basis_code;
4876:
4877: -- Bug 5362698 - Get the name from HR instead of pa_resources_denorm so

Line 5544: FROM pa_lookups plks

5540: AND hr.organization_id = res.resource_organization_id;
5541:
5542: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
5543: SELECT plks.meaning
5544: FROM pa_lookups plks
5545: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
5546: AND plks.lookup_code = p_override_basis_code;
5547:
5548: l_assignments_rec l_assignments_csr%ROWTYPE;

Line 7350: FROM pa_lookups plks

7346: l_assignments_rec l_assignments_csr%ROWTYPE;
7347:
7348: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
7349: SELECT plks.meaning
7350: FROM pa_lookups plks
7351: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
7352: AND plks.lookup_code = p_override_basis_code;
7353:
7354: CURSOR count_error_asgns IS