DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 430: from org_organization_definitions

426: AND jrttv.regime_code = jai_constants.tcs_regime;
427:
428: cursor c_fetch_org_information(cp_organization_id in number) is
429: select set_of_books_id, organization_code
430: from org_organization_definitions
431: where organization_id = cp_organization_id;
432:
433: cursor c_trx(cp_transaction_id in number) IS
434: select *

Line 450: lv_organization_code org_organization_definitions.organization_code%type;

446: WHERE shipment_line_id = p_shipment_line_id;
447:
448: v_rcv_rec rcv_cur%ROWTYPE;
449: v_item_id rcv_shipment_lines.item_id%type;
450: lv_organization_code org_organization_definitions.organization_code%type;
451: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
452: r_trx c_trx%ROWTYPE;
453: lv_account_nature VARCHAR2(30) := 'REVERSAL';
454: lv_account_type VARCHAR2(30);

Line 451: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;

447:
448: v_rcv_rec rcv_cur%ROWTYPE;
449: v_item_id rcv_shipment_lines.item_id%type;
450: lv_organization_code org_organization_definitions.organization_code%type;
451: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
452: r_trx c_trx%ROWTYPE;
453: lv_account_nature VARCHAR2(30) := 'REVERSAL';
454: lv_account_type VARCHAR2(30);
455: lv_period_name gl_periods.period_name%type;