APPS.PA_TASKS_MAINT_PVT dependencies on PA_TASKS_S

Line 799: select PA_TASKS_S.NEXTVAL INTO l_new_task_id from sys.dual;

795: -- Get Task Id
796: --Commented the following line and replaced with new one.
797: -- IF (p_calling_module IN ('FORMS', 'EXCHANGE', 'SELF_SERVICE')) THEN
798: IF p_task_id IS NULL THEN --Added by Ansari
799: select PA_TASKS_S.NEXTVAL INTO l_new_task_id from sys.dual;
800: ELSE --Added by Ansari
801: l_new_task_id := p_task_id;
802: END IF;
803:

Line 3780: UPDATE PA_TASKS SET CHARGEABLE_FLAG='N'

3776: -- As Parent Task Id of the Task being indented is updated and b'coz of this
3777: -- for this particular case the parent task was earlier a lowest level task
3778: -- but now it has become a summarized level task so need to update its chargeable flag to N
3779:
3780: UPDATE PA_TASKS SET CHARGEABLE_FLAG='N'
3781: WHERE TASK_ID = l_task_id_above;
3782:
3783: -- End of Changes for bug 3125880
3784: