APPS.JAI_PA_BILLING_PKG dependencies on JAI_CMN_FIN_YEARS

Line 748: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is

744: (cpn_location_id is null and (location_id = 0 or location_id is null) )
745: );
746:
747: /*
748: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is
749: select max(fin_year) fin_year
750: from JAI_CMN_FIN_YEARS
751: where organization_id = cpn_organization_id
752: and fin_active_flag = 'Y';

Line 750: from JAI_CMN_FIN_YEARS

746:
747: /*
748: cursor c_JAI_CMN_FIN_YEARS(cpn_organization_id in number) is
749: select max(fin_year) fin_year
750: from JAI_CMN_FIN_YEARS
751: where organization_id = cpn_organization_id
752: and fin_active_flag = 'Y';
753: */
754:

Line 779: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;

775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
776: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
777: lv_transaction_type varchar2(30);
778: lv_transaction_source varchar2(30);
779: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
780: lv_source_name varchar2(30);
781: ln_source_type JAI_CMN_RG_OTHERS.source_type%type;
782:
783: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;