APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 671: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/

667: p_trx_from_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_from_date) File.Sql.35 by Brathod
668: p_trx_till_date DATE; -- DEFAULT fnd_date.canonical_to_date(pv_trx_till_date) File.Sql.35 by Brathod
669: /*End of Bug# 4286646 */
670:
671: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/
672: SELECT a.organization_id org_id,a.location_id /*Bug 5879769 bduvarag*/
673: FROM JAI_RGM_ORG_REGNS_V a
674: WHERE regime_id = cp_regime_id
675: AND registration_type = jai_constants.regn_type_others

Line 942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c

938: CURSOR c_tax_dist_dtl(cp_regime_id IN NUMBER, cp_invoice_id IN NUMBER, cp_inv_distribution_id IN NUMBER) IS -- cp_dist_line_no IN NUMBER) IS
939: SELECT 1 chk, a.tax_id, b.tax_rate, a.tax_amount, a.parent_invoice_distribution_id, b.tax_type,
940: a.invoice_line_number, /* INVOICE LINES UPTAKE */
941: nvl(b.mod_cr_percentage,0) recoverable_ptg, a.base_amount
942: FROM JAI_AP_MATCH_INV_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c
943: WHERE a.invoice_id = cp_invoice_id
944: -- AND a.distribution_line_number = cp_dist_line_no Modified as part of AP INVOICE Lines Uptake project
945: AND a.invoice_distribution_id = cp_inv_distribution_id
946: AND a.tax_id = b.tax_id

Line 962: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d

958: CURSOR c_tp_inv_details (cp_regime_id IN NUMBER , cp_invoice_id IN NUMBER , cp_line_number IN NUMBER) IS
959: SELECT 1 chk , a.tax_id , a.tax_rate , a.tax_amount , NULL ,a.tax_type ,
960: a.line_number invoice_line_number, /* INVOICE LINES UPTAKE */
961: NVL(b.mod_cr_percentage,0) recoverable_ptg, NULL
962: FROM jai_rcv_tp_inv_details a , JAI_CMN_TAXES_ALL b , jai_rcv_tp_invoices c, JAI_RGM_REGISTRATIONS d
963: WHERE c.invoice_id = cp_invoice_id
964: AND a.batch_invoice_id = c.batch_invoice_id
965: AND a.tax_id = b.tax_id
966: AND a.line_number = cp_line_number /*INVOICE LINES UPTAKE cp_dist_line_number */