APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on DUAL

Line 139: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'

135: WHERE ap.rcv_transaction_id = rcv.transaction_id
136: AND ap.invoice_id = pr_new.invoice_id
137: AND ap.line_number = pn_line_number;
138:
139: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
140: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
141: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
142: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
143: select to_date(attribute_value, 'DD/MM/YYYY')

Line 1165: from dual;

1161:
1162:
1163: CURSOR c_get_invoice_distribution is
1164: select ap_invoice_distributions_s.nextval
1165: from dual;
1166:
1167: cursor get_dist_no(cp_invoice_id number,cp_inv_lineno number)
1168: is
1169: select max(nvl(distribution_line_number,0))