APPS.PA_OTC_API dependencies on DUAL

Line 1163: from dual;

1159: End If;
1160:
1161: select pa_txn_interface_s.nextval
1162: into l_txn_xface_id
1163: from dual;
1164:
1165: G_Stage := 'Store new/changed Trx Import Rec in pl/sql arrays for BB/Ovn: ' || l_New_Orig_Trx_Ref ||
1166: ' for Resource_Id(Person_Id): ' || to_char(l_New_Timecard_Rec.Incurred_By_Person_Id);
1167: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Stage;

Line 1698: From Dual;

1694: End If;
1695:
1696: Select Pa_Txn_Interface_S.NextVal
1697: Into l_Txn_Xface_Id
1698: From Dual;
1699:
1700: If l_Person_Type = 'CWK' And l_PO_Line_Id Is Not Null Then
1701:
1702: G_Stage := 'Get Supplier Info by calling GetPOInfo() 2.';

Line 8854: Dual;

8850: To_Char(P_Exp_End_Date,'YYMMDD')
8851: Into
8852: l_Date_String
8853: From
8854: Dual;
8855:
8856: G_Stage := 'Use mod(pa_expenditure_groups_s.nextval,1000) to create number value.';
8857: If G_Debug_Mode = 'Y' Then
8858: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 8867: Dual;

8863: Mod(Pa_Expenditure_Groups_S.NextVal,1000)
8864: INTO
8865: l_Sequence_No
8866: FROM
8867: Dual;
8868:
8869: G_Stage := 'Create a batch Name for Import run.';
8870: If G_Debug_Mode = 'Y' Then
8871: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;