DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_WF_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 83: ,hr_soft_coding_keyflex hsc

79: where org.org_information_context = 'Contact Information'
80: and org.organization_id = (
81: select hsc.segment1
82: from per_assignments_f paf
83: ,hr_soft_coding_keyflex hsc
84: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
85: and paf.assignment_id = l_assignment_id
86: and trunc(p_tran_date) between paf.effective_start_date and
87: paf.effective_end_date);