APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 555: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)

551:
552: lv_discarded_flag ap_invoice_lines_all.discarded_flag%TYPE;
553: --Added by Qinglei for bug#13405591 13-Dec-2011 end
554:
555: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)
556: is
557: select name
558: from hr_organization_units
559: where organization_id = cp_organization_id;

Line 558: from hr_organization_units

554:
555: cursor c_get_organization_name (cp_organization_id hr_organization_units.organization_id%type)
556: is
557: select name
558: from hr_organization_units
559: where organization_id = cp_organization_id;
560:
561: cursor c_get_location_name (cp_location_id hr_locations_all.location_id%type)
562: is

Line 677: lv_organization_name hr_organization_units.name%type;

673: rec_st_transprt_party_details c_st_transprt_party_details%rowtype;/* Changes by nprashar , Forward porting from bug 7172723 */
674: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
675:
676: lr_trx_repo_extract jai_trx_repo_extract_gt%rowtype;
677: lv_organization_name hr_organization_units.name%type;
678: lv_location_name hr_locations_all.description%type;
679: ln_reg_id number;
680: --start additions for bug#10085619
681: cursor c_get_line_number(p_invoice_id jai_rgm_trx_refs.invoice_id%type,p_line_id jai_rgm_trx_refs.line_id%type)