APPS.PQH_GL_POSTING dependencies on PA_TASKS

Line 5785: l_task_number pa_tasks.task_number%TYPE;

5781: ---------------Local Variables---------------------------------------------
5782: l_bg_id NUMBER(15) ;
5783: l_org_name hr_all_organization_units_tl.name%TYPE;
5784: l_seg1 VARCHAR2(25);
5785: l_task_number pa_tasks.task_number%TYPE;
5786: l_gms_batch_name VARCHAR2(10);
5787: l_exp_end_dt DATE;
5788: l_call_status BOOLEAN;
5789: l_value VARCHAR2(200);

Line 5846: From pa_tasks

5842:
5843:
5844: Cursor csr_pa_task_num(p_task_id NUMBER) IS
5845: Select task_number
5846: From pa_tasks
5847: Where task_id = p_task_id;
5848:
5849:
5850:

Line 5926: l_table := 'PA_TASKS';

5922: FETCH csr_pa_task_num INTO l_task_number;
5923: IF (csr_pa_task_num%NOTFOUND) THEN
5924: CLOSE csr_pa_task_num;
5925: l_value := 'Task id ='||to_char(C1.task_id);
5926: l_table := 'PA_TASKS';
5927: RAISE tran_setup_exception;
5928: else
5929: CLOSE csr_pa_task_num;
5930: hr_utility.set_location('task num: '||l_task_number, 25);