APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_DIS_DES_HDRS

Line 184: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type

180: where party_type = cp_party_type
181: and party_id = cp_party_id
182: and transfer_id = cp_transfer_id;
183:
184: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
185: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
186: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
187: )
188: is

Line 185: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type

181: and party_id = cp_party_id
182: and transfer_id = cp_transfer_id;
183:
184: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
185: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
186: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
187: )
188: is
189: select transfer_number

Line 186: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type

182: and transfer_id = cp_transfer_id;
183:
184: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
185: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
186: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
187: )
188: is
189: select transfer_number
190: ,creation_date transaction_date

Line 193: from JAI_RGM_DIS_DES_HDRS

189: select transfer_number
190: ,creation_date transaction_date
191: ,destination_party_id
192: ,location_id
193: from JAI_RGM_DIS_DES_HDRS
194: where destination_party_type = cp_party_type
195: and destination_party_id = cp_party_id
196: and transfer_id = cp_transfer_id;
197: