[Home] [Help]
130: -- To support new criteria add new CURSORs or add to existing CURSOR.
131:
132: CURSOR get_employee_id(p_user_id IN Number) Is
133:
134: Select employee_id from fnd_user
135: Where user_id = p_user_id;
136:
137:
138: /*Cursor Modified By Mithun for CWK Terminate Bug*/
1640: CURSOR c_personal_hierarchy(p_resource_id IN NUMBER) IS
1641:
1642: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order, hrr.start_date, hrr.end_date
1643: FROM hxc_resource_rules hrr,
1644: fnd_user fu
1645: WHERE hrr.resource_type='PERSON'
1646: AND hrr.eligibility_criteria_type = 'LOGIN'
1647: AND hrr.eligibility_criteria_id = to_char(fu.user_id) -- Issue 4
1648: AND fu.employee_id = p_resource_id;
1693:
1694:
1695:
1696: CURSOR get_employee_id(p_user_id IN Number) Is
1697: Select employee_id from fnd_user
1698: Where user_id = p_user_id;
1699:
1700:
1701: CURSOR c_person_type_hierarchies(p_resource_id IN NUMBER,
3431: resp_id VARCHAR2(100);
3432: l_tc_user_id VARCHAR2(150);
3433: l_tc_employee_id NUMBER;
3434: CURSOR get_employee_id(p_user_id IN Number) Is
3435: Select employee_id from fnd_user
3436: Where user_id = p_user_id;
3437: BEGIN
3438: g_debug := hr_utility.debug_enabled;
3439: if g_debug then
3503: resp_appl_id VARCHAR2(100);
3504: l_tc_user_id VARCHAR2(150);
3505: l_tc_employee_id NUMBER;
3506: CURSOR get_employee_id(p_user_id IN Number) Is
3507: Select employee_id from fnd_user
3508: Where user_id = p_user_id;
3509:
3510:
3511:
3728:
3729:
3730: CURSOR get_user_person_id ( p_user_id NUMBER )
3731: IS SELECT employee_id
3732: FROM fnd_user
3733: WHERE user_id = p_user_id;
3734:
3735: TYPE time_periodsrec IS RECORD
3736: ( timecard_id NUMBER,