APPS.HR_US_FF_UDF1 dependencies on HR_SOFT_CODING_KEYFLEX

Line 245: hr_soft_coding_keyflex hsk

241: select nvl(hoi.org_information16,'N')
242: into l_return_value
243: from per_assignments_f paf,
244: hr_organization_information hoi,
245: hr_soft_coding_keyflex hsk
246: where paf.assignment_id = p_assignment_id
247: and p_date_earned between paf.effective_start_date
248: and paf.effective_end_date
249: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 1729: , hr_soft_coding_keyflex HRSCKF

1725: l_county,
1726: l_state,
1727: l_zip_code
1728: FROM hr_locations HRLOC
1729: , hr_soft_coding_keyflex HRSCKF
1730: , per_all_assignments_f ASSIGN
1731: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1732: AND ASSIGN.effective_end_date
1733: AND ASSIGN.assignment_id = l_assignment_id

Line 2680: ,hr_soft_coding_keyflex hrsckf

2676: NVL(hrloc.loc_information19,hrloc.region_1),
2677: NVL(hrloc.loc_information17,hrloc.region_2),
2678: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2679: FROM hr_locations hrloc
2680: ,hr_soft_coding_keyflex hrsckf
2681: ,per_all_assignments_f assign
2682: WHERE p_date_earned BETWEEN assign.effective_start_date
2683: AND assign.effective_end_date
2684: AND assign.assignment_id = p_assignment_id

Line 2784: FROM hr_soft_coding_keyflex target,

2780: -- Get work schedule details
2781: --
2782: CURSOR csr_ws(p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
2783: SELECT segment4
2784: FROM hr_soft_coding_keyflex target,
2785: per_all_assignments_f assign
2786: WHERE ASSIGN.assignment_id = p_assignment_id
2787: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
2788: AND target.enabled_flag = 'Y'