1158: IS
1159: CURSOR cur_rec_appl_audits_s
1160: IS
1161: SELECT jai_ar_rec_appl_audits_s.nextval
1162: FROM dual;
1163:
1164: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1165: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1166: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1277:
1278: CURSOR cur_payment_audits_s
1279: IS
1280: SELECT jai_ar_payment_audits_s.nextval
1281: FROM dual;
1282:
1283: ln_created_by jai_ar_payment_audits.created_by%TYPE;
1284: ld_creation_date jai_ar_payment_audits.creation_date%TYPE;
1285: ln_last_updated_by jai_ar_payment_audits.last_updated_by%TYPE;
1442:
1443: CURSOR cur_gl_seq
1444: IS
1445: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
1446: FROM dual;
1447:
1448: /* Ramananda for bug#5219225. */
1449: lv_object_name user_procedures.object_name%type ;
1450: lv_procedure_name user_procedures.procedure_name%type ;
4833: */
4834: --Commented by Chong.Lei for POT code port end
4835: --Added by Chong.Lei for POT code port start
4836: ------------------------------------------------------------------------------------
4837: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
4838: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
4839: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
4840: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
4841: select to_date(attribute_value, 'DD/MM/YYYY')
4889: ----------------------------------------------------------------------------------
4890: Cursor chk_external_event
4891: is
4892: select 1
4893: from dual
4894: where exists
4895: ( select customer_trx_line_id
4896: from jai_ar_trx_lines
4897: where customer_trx_id = pn_customer_trx_id