DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on DUAL

Line 175: FROM dual;

171: Begin
172:
173: SELECT fun_interface_controls_s.nextval
174: INTO l_group_id
175: FROM dual;
176:
177: If p_insert_flag = 'Y' Then
178: Insert Into Fun_Interface_Batches(
179: source,

Line 646: From Dual;

642: Where batch_number = cp_batch_number;
643:
644: Cursor C_Batch_Id Is
645: Select Fun_Trx_Batches_S.nextval batch_id
646: From Dual;
647:
648: -- Bug No: 6134848. 2 more condetions added to validate Party_usage_code.
649:
650: Cursor C_Party(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is

Line 685: From Dual;

681: And trx_number = cp_trx_number;
682:
683: Cursor C_Trx_Id Is
684: Select Fun_Trx_Headers_S.nextval trx_id
685: From Dual;
686:
687: Cursor C_Dupl_Reci_In_Batch(
688: cp_batch_id In Fun_Interface_Headers.batch_id%type,
689: cp_trx_number In Fun_Interface_Headers.trx_number%type,

Line 713: From dual;

709: And dist_number=cp_dist_number;
710:
711: Cursor C_Dist_Id Is
712: Select Fun_Dist_Lines_S.nextval dist_id
713: From dual;
714:
715: Cursor C_Ccid(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
716: Select chart_of_accounts_id
717: From Hz_Parties hzp,