APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_DIS_DES_HDRS

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

594: where party_type = cp_party_type
595: and party_id = cp_party_id
596: and transfer_id = cp_transfer_id;
597:
598: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
599: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
600: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
601: )
602: is

Line 599: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type

595: and party_id = cp_party_id
596: and transfer_id = cp_transfer_id;
597:
598: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
599: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
600: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
601: )
602: is
603: select transfer_number

Line 600: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type

596: and transfer_id = cp_transfer_id;
597:
598: cursor c_get_dest_rec( cp_transfer_id jai_rgm_dis_des_hdrs.transfer_id%type
599: , cp_party_type jai_rgm_dis_des_hdrs.destination_party_type%type
600: , cp_party_id jai_rgm_dis_des_hdrs.destination_party_id%type
601: )
602: is
603: select transfer_number
604: ,creation_date transaction_date

Line 607: from JAI_RGM_DIS_DES_HDRS

603: select transfer_number
604: ,creation_date transaction_date
605: ,destination_party_id
606: ,location_id
607: from JAI_RGM_DIS_DES_HDRS
608: where destination_party_type = cp_party_type
609: and destination_party_id = cp_party_id
610: and transfer_id = cp_transfer_id;
611: