APPS.PQH_COMMITMENT_POSTING dependencies on PA_TASKS

Line 4818: l_task_number pa_tasks.task_number%TYPE;

4814: ---------------Local Variables---------------------------------------------
4815: l_bg_id NUMBER(15) ;
4816: l_org_name hr_all_organization_units_tl.name%TYPE;
4817: l_seg1 VARCHAR2(25);
4818: l_task_number pa_tasks.task_number%TYPE;
4819: l_gms_batch_name VARCHAR2(10);
4820: l_exp_end_dt DATE;
4821: l_call_status BOOLEAN;
4822: l_value VARCHAR2(200);

Line 4879: From pa_tasks

4875:
4876:
4877: Cursor csr_pa_task_num(p_task_id NUMBER) IS
4878: Select task_number
4879: From pa_tasks
4880: Where task_id = p_task_id;
4881:
4882:
4883:

Line 4959: l_table := 'PA_TASKS';

4955: FETCH csr_pa_task_num INTO l_task_number;
4956: IF (csr_pa_task_num%NOTFOUND) THEN
4957: CLOSE csr_pa_task_num;
4958: l_value := 'Task id ='||to_char(C1.task_id);
4959: l_table := 'PA_TASKS';
4960: RAISE tran_setup_exception;
4961: else
4962: CLOSE csr_pa_task_num;
4963: hr_utility.set_location('task num: '||l_task_number, 25);