APPS.PATC dependencies on PA_TRANSACTION_CONTROLS

Line 202: pa_transaction_controls tc

198: , tc.SCHEDULED_EXP_ONLY
199: , tc.employees_only_flag -- PA.M/CWK changes
200: , tc.workplan_res_only_flag -- PA.M/Task Assignment changes
201: FROM
202: pa_transaction_controls tc
203: WHERE
204: tc.project_id = X_project_id
205: AND ( tc.task_id is null
206: OR

Line 433: FROM pa_transaction_controls

429: INTO dummy
430: FROM dual
431: WHERE EXISTS
432: ( SELECT 1
433: FROM pa_transaction_controls
434: WHERE project_id = X_project_id
435: AND task_id = X_task_id ) ;
436:
437: IF ( dummy = 0 ) THEN

Line 593: From pa_transaction_controls

589:
590: If p_task_id is not null then
591:
592: SELECT count(1) INTO l_tc_count
593: From pa_transaction_controls
594: WHERE project_id = p_project_id
595: AND task_id = p_task_id;
596:
597: Else

Line 600: From pa_transaction_controls

596:
597: Else
598:
599: SELECT count(1) INTO l_tc_count
600: From pa_transaction_controls
601: WHERE project_id = p_project_id;
602:
603: End If;
604: /* Ends - Added for bug4778164 */

Line 614: From pa_transaction_controls

610:
611: print_message(' p '||p_project_id||' t '||p_task_id);
612:
613: SELECT 1 INTO TC_EXISTS
614: From pa_transaction_controls
615: WHERE project_id = p_project_id
616: AND task_id = p_task_id
617: AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)
618: AND person_id IS NULL

Line 625: FROM pa_transaction_controls

621:
622: ELSE
623:
624: SELECT 1 INTO TC_EXISTS
625: FROM pa_transaction_controls
626: WHERE project_id = p_project_id
627: AND task_id is NULL
628: AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)
629: AND person_id IS NULL

Line 645: FROM pa_transaction_controls

641:
642: print_message(' p '||p_project_id||' t '||p_task_id);
643:
644: SELECT 1 INTO TC_EXISTS
645: FROM pa_transaction_controls
646: WHERE project_id = p_project_id
647: AND task_id = p_task_id
648: -- Commented for bug 4585740
649: -- AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)

Line 656: FROM pa_transaction_controls

652:
653: ELSE
654:
655: SELECT 1 INTO TC_EXISTS
656: FROM pa_transaction_controls
657: WHERE project_id = p_project_id
658: AND task_id is NULL
659: -- Commented for bug 4585740
660: -- AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)