APPS.PA_OTC_API dependencies on DUAL

Line 1181: from dual;

1177: End If;
1178:
1179: select pa_txn_interface_s.nextval
1180: into l_txn_xface_id
1181: from dual;
1182:
1183: G_Stage := 'Store new/changed Trx Import Rec in pl/sql arrays for BB/Ovn: ' || l_New_Orig_Trx_Ref ||
1184: ' for Resource_Id(Person_Id): ' || to_char(l_New_Timecard_Rec.Incurred_By_Person_Id);
1185: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Stage;

Line 1746: From Dual;

1742: End If;
1743:
1744: Select Pa_Txn_Interface_S.NextVal
1745: Into l_Txn_Xface_Id
1746: From Dual;
1747:
1748: If l_Person_Type = 'CWK' And l_PO_Line_Id Is Not Null Then
1749:
1750: G_Stage := 'Get Supplier Info by calling GetPOInfo() 2.';

Line 4974: into l_closed_proj_flag from dual

4970:
4971: Begin
4972: Select
4973: 'Y'
4974: into l_closed_proj_flag from dual
4975: where exists (select 1
4976: From
4977: Pa_Expenditure_Items_All ei,
4978: pa_projects_all ppa

Line 9769: Dual;

9765: To_Char(P_Exp_End_Date,'YYMMDD')
9766: Into
9767: l_Date_String
9768: From
9769: Dual;
9770:
9771: G_Stage := 'Use mod(pa_expenditure_groups_s.nextval,1000) to create number value.';
9772: If G_Debug_Mode = 'Y' Then
9773: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 9782: Dual;

9778: Mod(Pa_Expenditure_Groups_S.NextVal,1000)
9779: INTO
9780: l_Sequence_No
9781: FROM
9782: Dual;
9783:
9784: G_Stage := 'Create a batch Name for Import run.';
9785: If G_Debug_Mode = 'Y' Then
9786: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;