DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 303: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups

299: where assignment_id = p_assignment_id;
300:
301: cursor get_info_from_scl is
302: select lookups.meaning
303: from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
304: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
305: and lookups.lookup_type=l_information_code
306: and lookups.enabled_flag = 'Y'
307: and lookups.lookup_code = decode(l_information_code,'NO_JOB_STATUS',scl.segment5,

Line 339: from hr_soft_coding_keyflex

335: and hoi.org_information1 = 'HR_ORG';
336:
337: cursor get_local_unit is
338: select segment2
339: from hr_soft_coding_keyflex
340: where soft_coding_keyflex_id = l_scl_id;
341:
342:
343: cursor get_info_from_local_unit is

Line 372: from HR_SOFT_CODING_KEYFLEX scl

368: where organization_id = l_organization_id;
369:
370: cursor get_info_from_scl_awh is
371: select scl.segment10
372: from HR_SOFT_CODING_KEYFLEX scl
373: where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id;
374:
375:
376: cursor get_info_from_org_awh is