APPS.JTF_TASKS_PUB dependencies on FND_USER

Line 661: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;

657: l_actual_start_date DATE := p_actual_start_date;
658: l_actual_end_date DATE := p_actual_end_date;
659: l_scheduled_start_date DATE := p_scheduled_start_date;
660: l_scheduled_end_date DATE := p_scheduled_end_date;
661: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
662: l_assigned_by_id NUMBER := p_assigned_by_id;
663: l_cust_account_number hz_cust_accounts.account_number%TYPE := p_cust_account_number;
664: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE := p_cust_account_id;
665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;

Line 2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;

2926: l_task_status_name jtf_task_statuses_tl.NAME%TYPE := p_task_status_name;
2927: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;
2928: l_task_priority_name jtf_task_priorities_tl.NAME%TYPE := p_task_priority_name;
2929: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
2931: l_assigned_by_id NUMBER := p_assigned_by_id;
2932: l_customer_id hz_parties.party_id%TYPE;
2933: l_customer_number hz_parties.party_number%TYPE;
2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

Line 5313: FROM fnd_user

5309: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE
5310: ) IS
5311: CURSOR c_assigned_by_name IS
5312: SELECT user_id assigned_by_id
5313: FROM fnd_user
5314: WHERE user_name = p_assigned_name
5315: AND NVL(end_date, SYSDATE) >= SYSDATE
5316: AND NVL(start_date, SYSDATE) <= SYSDATE;
5317: BEGIN