APPS.JAI_PA_BILLING_PKG dependencies on JAI_CMN_FIN_YEARS

Line 782: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is

778: (cpn_location_id is null and (location_id = 0 or location_id is null) )
779: );
780:
781: /*
782: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is
783: select max(fin_year) fin_year
784: from JAI_CMN_FIN_YEARS
785: where organization_id = cpn_organization_id
786: and fin_active_flag = 'Y';

Line 784: from JAI_CMN_FIN_YEARS

780:
781: /*
782: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is
783: select max(fin_year) fin_year
784: from JAI_CMN_FIN_YEARS
785: where organization_id = cpn_organization_id
786: and fin_active_flag = 'Y';
787: */
788:

Line 813: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;

809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
810: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
811: lv_transaction_type varchar2(30);
812: lv_transaction_source varchar2(30);
813: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
814: lv_source_name varchar2(30);
815: ln_source_type JAI_CMN_RG_OTHERS.source_type%type;
816:
817: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;