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 4857: FROM pa_lookups plks

4853: WHERE assignment_id = p_assignment_id;
4854:
4855: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
4856: SELECT plks.meaning
4857: FROM pa_lookups plks
4858: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
4859: AND plks.lookup_code = p_override_basis_code;
4860:
4861: -- Bug 5362698 - Get the name from HR instead of pa_resources_denorm so

Line 5528: FROM pa_lookups plks

5524: AND hr.organization_id = res.resource_organization_id;
5525:
5526: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
5527: SELECT plks.meaning
5528: FROM pa_lookups plks
5529: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
5530: AND plks.lookup_code = p_override_basis_code;
5531:
5532: l_assignments_rec l_assignments_csr%ROWTYPE;

Line 7334: FROM pa_lookups plks

7330: l_assignments_rec l_assignments_csr%ROWTYPE;
7331:
7332: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
7333: SELECT plks.meaning
7334: FROM pa_lookups plks
7335: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
7336: AND plks.lookup_code = p_override_basis_code;
7337:
7338: CURSOR count_error_asgns IS