APPS.PA_RLMI_RBS_MAP_PUB dependencies on DUAL

Line 504: FROM Dual ;

500: ,l_NON_LABOR_RESOURCE_ID_TBL(i) --nlr.non_labor_resource_id //added for 14040849
501: ,g_project_role_id_sqltab(i)
502: ,g_person_type_code_sqltab(i)
503: ,l_RESOURCE_CLASS_ID_TBL(i) --rc.resource_class_id //added for 14040849
504: FROM Dual ;
505:
506: g_rbs_numRecInserted := g_txn_source_id_sqltab.Count ;
507: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
508: print_msg(g_debug_flag,l_stage);

Line 624: FROM Dual ;

620: ,l_NON_LABOR_RESOURCE_ID_TBL(i) --nlr.non_labor_resource_id -- added for 14040849
621: ,g_project_role_id_systab(i)
622: ,g_person_type_code_systab(i)
623: ,l_RESOURCE_CLASS_ID_TBL(i) --rc.resource_class_id -- added for 14040849
624: FROM Dual ;
625:
626: g_rbs_numRecInserted := g_txn_source_id_systab.count;
627: l_stage := 'Num Of Records Inserted ['||g_rbs_numRecInserted||']';
628: print_msg(g_debug_flag,l_stage);

Line 1059: FROM DUAL;

1055: ,g_PROJECT_ID
1056: ,g_BUDGET_VERSION_ID
1057: ,l_financial_res_class_rlm_id --bug#16827157
1058: ,g_CBS_ELEMENT_ID_sqltab(i)
1059: FROM DUAL;
1060:
1061:
1062: ELSE -- IF l_uncategorized_flag = 'Y' THEN
1063: l_stage := 'Inserting records into pa_res_list_map_tmp1 from PLSQL tables';

Line 1152: FROM DUAL;

1148: ,g_TXN_PLAN_END_DATE_sqltab (i)
1149: ,g_PROJECT_ID
1150: ,g_BUDGET_VERSION_ID
1151: ,g_CBS_ELEMENT_ID_sqltab(i) --bug#16827157
1152: FROM DUAL;
1153: END IF; -- IF l_uncategorized_flag = 'Y' THEN
1154: l_NumRecInserted := sql%Rowcount;
1155: g_res_numRecInserted := l_NumRecInserted;
1156:

Line 1259: FROM DUAL;

1255: ,g_PROJECT_ID
1256: ,g_BUDGET_VERSION_ID
1257: ,l_financial_res_class_rlm_id
1258: ,g_CBS_ELEMENT_ID_systab(i) --bug#16827157
1259: FROM DUAL;
1260:
1261: ELSE--IF l_uncategorized_flag = 'Y' THEN
1262:
1263: l_stage := 'Inserting records into pa_res_list_map_tmp1 from SYSTEM tables';

Line 1352: FROM DUAL;

1348: ,g_TXN_PLAN_END_DATE_systab (i)
1349: ,g_PROJECT_ID
1350: ,g_BUDGET_VERSION_ID
1351: ,g_CBS_ELEMENT_ID_systab(i) --bug#16827157
1352: FROM DUAL;
1353:
1354: END IF;--IF l_uncategorized_flag = 'Y' THEN
1355: l_NumRecInserted := sql%Rowcount;
1356: g_res_numRecInserted := l_NumRecInserted;

Line 2909: FROM dual

2905: -- End OLAP
2906:
2907: CURSOR check_ResAsgn_Exists(p_budget_version_id Number) IS
2908: SELECT 'Y'
2909: FROM dual
2910: WHERE EXISTS (select null
2911: from pa_resource_assignments ra
2912: where ra.budget_version_id = p_budget_version_id);
2913: