DBA Data[Home] [Help]

APPS.HR_DE_ORG_INFO dependencies on HR_SOFT_CODING_KEYFLEX

Line 404: SELECT substr(segment2,1,5), substr(segment3,1,15) INTO l_exempt, l_liab_prov FROM Hr_soft_coding_keyflex

400: WHERE assignment_id = p_assignment_id
401: AND primary_flag = 'Y'
402: AND p_incident_date BETWEEN effective_start_date and effective_end_date;
403: -- Querying employee has Workers Liability details recorded against the assignment SCL
404: SELECT substr(segment2,1,5), substr(segment3,1,15) INTO l_exempt, l_liab_prov FROM Hr_soft_coding_keyflex
405: WHERE soft_coding_keyflex_id =
406: (SELECT unique(soft_coding_keyflex_id) FROM per_assignments_f WHERE assignment_id = p_assignment_id and p_incident_date BETWEEN effective_start_date AND effective_end_date);
407: IF SQL%FOUND THEN
408: IF l_exempt = 'N' THEN