eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_APPROVAL_PKG dependencies on PA_TASKS

Line 31: WHERE object_type_from = 'PA_TASKS'

27: AND parent_structure_version_id = p_parent_struc_ver
28: AND financial_task_flag = 'Y'
29: AND EXISTS (SELECT 1
30: FROM PA_OBJECT_RELATIONSHIPS
31: WHERE object_type_from = 'PA_TASKS'
32: AND object_id_to1 = element_version_id
33: AND object_type_to = 'PA_TASKS'
34: AND relationship_type = 'S');
35:

Line 33: AND object_type_to = 'PA_TASKS'

29: AND EXISTS (SELECT 1
30: FROM PA_OBJECT_RELATIONSHIPS
31: WHERE object_type_from = 'PA_TASKS'
32: AND object_id_to1 = element_version_id
33: AND object_type_to = 'PA_TASKS'
34: AND relationship_type = 'S');
35:
36: l_is_child_task VARCHAR2(1) :='N';
37: BEGIN

Line 71: -- Cursor is to identify if the p_parent_task_id exists in PA_TASKs or not.

67: ,p_msg_count OUT NOCOPY NUMBER
68: ,p_msg_data OUT NOCOPY VARCHAR2
69: ,p_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
70:
71: -- Cursor is to identify if the p_parent_task_id exists in PA_TASKs or not.
72: CURSOR C1 IS
73: SELECT 'Y'
74: FROM PA_TASKS
75: WHERE project_id = p_project_id

Line 74: FROM PA_TASKS

70:
71: -- Cursor is to identify if the p_parent_task_id exists in PA_TASKs or not.
72: CURSOR C1 IS
73: SELECT 'Y'
74: FROM PA_TASKS
75: WHERE project_id = p_project_id
76: AND task_id = p_parent_task_id
77: AND EXISTS (
78: SELECT 1

Line 94: AND object_type_to = 'PA_TASKS'

90: AND EXISTS (SELECT 1
91: FROM PA_OBJECT_RELATIONSHIPS
92: WHERE object_type_from = 'PA_STRUCTURES'
93: AND object_id_to1 = element_version_id
94: AND object_type_to = 'PA_TASKS'
95: AND relationship_type = 'S');
96:
97: l_is_parent_tsk_aprvd VARCHAR2(1) := 'N';
98: BEGIN

Line 203: and por.object_type_to = 'PA_TASKS'

199: and ppe.link_task_flag = 'Y'
200: and ppe.type_id = 1
201: and ppev.proj_element_id = ppe.proj_element_id
202: and por.object_id_to1 = ppev.element_version_id
203: and por.object_type_to = 'PA_TASKS'
204: and por.relationship_type = 'S'
205: and ppev.financial_task_flag = 'Y')
206: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);
207:

Line 206: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);

202: and por.object_id_to1 = ppev.element_version_id
203: and por.object_type_to = 'PA_TASKS'
204: and por.relationship_type = 'S'
205: and ppev.financial_task_flag = 'Y')
206: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);
207:
208: l_unapproved_task_cnt NUMBER;
209: BEGIN
210: log_message('Inside PA_TASK_APPROVAL_PKG.Check_UsedTask_Status',3);