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_TRANSACTIONS_PUB dependencies on PA_TASKS

Line 133: from pa_tasks

129: /*Bug 8574986 begin*/
130:
131: /* Start: changes for CBS Enhancement: Bug 16220146 */
132: select count(*) into l_task_count
133: from pa_tasks
134: where project_id = X_project_id
135: and task_id = X_task_id;
136:
137: IF l_task_count <> 0 THEN

Line 668: pa_tasks task,

664: FROM pa_expenditure_items_all ei,
665: pa_expenditures_all exp,
666: per_all_people_f per,
667: pa_projects_all proj,
668: pa_tasks task,
669: hr_all_organization_units hr1
670: WHERE ei.transaction_source = x_transaction_source AND
671: ei.orig_transaction_reference = x_orig_transaction_reference AND
672: ei.system_linkage_function = x_expenditure_type_class AND

Line 711: pa_tasks task,

707: FROM pa_expenditure_items_all ei,
708: pa_expenditures_all exp,
709: per_all_people_f per,
710: pa_projects_all proj,
711: pa_tasks task,
712: hr_all_organization_units hr1,
713: hr_all_organization_units hr2
714: WHERE ei.transaction_source = x_transaction_source AND
715: ei.orig_transaction_reference = x_orig_transaction_reference AND

Line 757: pa_tasks task,

753: SELECT net_zero_adjustment_flag
754: FROM pa_expenditure_items_all ei,
755: pa_expenditures_all exp,
756: pa_projects_all proj,
757: pa_tasks task,
758: hr_all_organization_units hr1,
759: hr_all_organization_units hr2
760: WHERE ei.transaction_source = x_transaction_source AND
761: ei.orig_transaction_reference = x_orig_transaction_reference AND

Line 800: pa_tasks task,

796: SELECT net_zero_adjustment_flag
797: FROM pa_expenditure_items_all ei,
798: pa_expenditures_all exp,
799: pa_projects_all proj,
800: pa_tasks task,
801: hr_all_organization_units hr1
802: WHERE ei.transaction_source = x_transaction_source AND
803: ei.orig_transaction_reference = x_orig_transaction_reference AND
804: ei.system_linkage_function = x_expenditure_type_class AND

Line 1048: and por.object_type_from='PA_TASKS')

1044: and ppe1.link_task_flag = 'Y'
1045: and ppe1.task_status is not null /*Bug 8916805*/
1046: and por.relationship_type = 'S'
1047: and ppev.financial_task_flag = 'Y'
1048: and por.object_type_from='PA_TASKS')
1049: and not exists (select 1 from pa_tasks where parent_task_id=X_task_id);
1050:
1051: IF (nvl(l_cm_subt_count,0)>0) Then
1052: X_msg_data :='PA_CM_SUB_TASK';

Line 1049: and not exists (select 1 from pa_tasks where parent_task_id=X_task_id);

1045: and ppe1.task_status is not null /*Bug 8916805*/
1046: and por.relationship_type = 'S'
1047: and ppev.financial_task_flag = 'Y'
1048: and por.object_type_from='PA_TASKS')
1049: and not exists (select 1 from pa_tasks where parent_task_id=X_task_id);
1050:
1051: IF (nvl(l_cm_subt_count,0)>0) Then
1052: X_msg_data :='PA_CM_SUB_TASK';
1053: select task_number into X_msg_token1 from pa_tasks where task_id=X_task_id;

Line 1053: select task_number into X_msg_token1 from pa_tasks where task_id=X_task_id;

1049: and not exists (select 1 from pa_tasks where parent_task_id=X_task_id);
1050:
1051: IF (nvl(l_cm_subt_count,0)>0) Then
1052: X_msg_data :='PA_CM_SUB_TASK';
1053: select task_number into X_msg_token1 from pa_tasks where task_id=X_task_id;
1054:
1055: raise INVALID_DATA;
1056: END IF;
1057: