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_RLMI_RBS_MAP_PUB dependencies on DUAL

Line 360: FROM Dual ;

356: ,NULL --nlr.non_labor_resource_id
357: ,g_project_role_id_sqltab(i)
358: ,g_person_type_code_sqltab(i)
359: ,NULL --rc.resource_class_id
360: FROM Dual ;
361:
362: g_rbs_numRecInserted := g_txn_source_id_sqltab.Count ;
363: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
364: print_msg(g_debug_flag,l_stage);

Line 427: FROM Dual ;

423: ,NULL --nlr.non_labor_resource_id
424: ,g_project_role_id_systab(i)
425: ,g_person_type_code_systab(i)
426: ,NULL --rc.resource_class_id
427: FROM Dual ;
428:
429: g_rbs_numRecInserted := g_txn_source_id_systab.count;
430: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
431: print_msg(g_debug_flag,l_stage);

Line 859: FROM DUAL;

855: ,g_TXN_PLAN_END_DATE_sqltab (i)
856: ,g_PROJECT_ID
857: ,g_BUDGET_VERSION_ID
858: ,l_financial_res_class_rlm_id
859: FROM DUAL;
860:
861: ELSE -- IF l_uncategorized_flag = 'Y' THEN
862: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';
863: print_msg(g_debug_flag,l_stage);

Line 948: FROM DUAL;

944: ,g_TXN_PLAN_START_DATE_sqltab(i)
945: ,g_TXN_PLAN_END_DATE_sqltab (i)
946: ,g_PROJECT_ID
947: ,g_BUDGET_VERSION_ID
948: FROM DUAL;
949: END IF; -- IF l_uncategorized_flag = 'Y' THEN
950: l_NumRecInserted := sql%Rowcount;
951: g_res_numRecInserted := l_NumRecInserted;
952:

Line 1050: FROM DUAL;

1046: ,g_TXN_PLAN_END_DATE_systab (i)
1047: ,g_PROJECT_ID
1048: ,g_BUDGET_VERSION_ID
1049: ,l_financial_res_class_rlm_id
1050: FROM DUAL;
1051:
1052: ELSE--IF l_uncategorized_flag = 'Y' THEN
1053:
1054: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';

Line 1140: FROM DUAL;

1136: ,g_TXN_PLAN_START_DATE_systab(i)
1137: ,g_TXN_PLAN_END_DATE_systab (i)
1138: ,g_PROJECT_ID
1139: ,g_BUDGET_VERSION_ID
1140: FROM DUAL;
1141:
1142: END IF;--IF l_uncategorized_flag = 'Y' THEN
1143: l_NumRecInserted := sql%Rowcount;
1144: g_res_numRecInserted := l_NumRecInserted;

Line 2628: FROM dual

2624: FOR UPDATE OF fp.proj_fp_options_id,bv.budget_version_id ;
2625:
2626: CURSOR check_ResAsgn_Exists(p_budget_version_id Number) IS
2627: SELECT 'Y'
2628: FROM dual
2629: WHERE EXISTS (select null
2630: from pa_resource_assignments ra
2631: where ra.budget_version_id = p_budget_version_id);
2632: