APPS.HR_US_FF_UDF1 dependencies on HR_SOFT_CODING_KEYFLEX

Line 204: hr_soft_coding_keyflex hsk

200: select nvl(hoi.org_information16,'N')
201: into l_return_value
202: from per_assignments_f paf,
203: hr_organization_information hoi,
204: hr_soft_coding_keyflex hsk
205: where paf.assignment_id = p_assignment_id
206: and p_date_earned between paf.effective_start_date
207: and paf.effective_end_date
208: and paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 1688: , hr_soft_coding_keyflex HRSCKF

1684: l_county,
1685: l_state,
1686: l_zip_code
1687: FROM hr_locations HRLOC
1688: , hr_soft_coding_keyflex HRSCKF
1689: , per_all_assignments_f ASSIGN
1690: WHERE l_date_earned BETWEEN ASSIGN.effective_start_date
1691: AND ASSIGN.effective_end_date
1692: AND ASSIGN.assignment_id = l_assignment_id

Line 2581: ,hr_soft_coding_keyflex hrsckf

2577: NVL(hrloc.loc_information19,hrloc.region_1),
2578: NVL(hrloc.loc_information17,hrloc.region_2),
2579: SUBSTR(NVL(hrloc.loc_information20,hrloc.postal_code),1,5)
2580: FROM hr_locations hrloc
2581: ,hr_soft_coding_keyflex hrsckf
2582: ,per_all_assignments_f assign
2583: WHERE p_date_earned BETWEEN assign.effective_start_date
2584: AND assign.effective_end_date
2585: AND assign.assignment_id = p_assignment_id

Line 2685: FROM hr_soft_coding_keyflex target,

2681: -- Get work schedule details
2682: --
2683: CURSOR csr_ws(p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
2684: SELECT segment4
2685: FROM hr_soft_coding_keyflex target,
2686: per_all_assignments_f assign
2687: WHERE ASSIGN.assignment_id = p_assignment_id
2688: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
2689: AND target.enabled_flag = 'Y'