APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_AP_INVOICE_LINES

Line 51: , jai_ap_invoice_lines jail

47: CURSOR get_tax_type_cur IS
48: SELECT jcta.tax_type
49: FROM jai_cmn_document_taxes jcdt
50: , jai_cmn_taxes_all jcta
51: , jai_ap_invoice_lines jail
52: , jai_rgm_registrations jrr
53: , jai_rgm_definitions jrd
54: WHERE jcdt.source_doc_id = pr_new.invoice_id
55: AND jail.invoice_id = pr_new.invoice_id

Line 117: FROM jai_ap_invoice_lines

113: WHERE regime_code = jai_constants.service_regime;
114:
115: CURSOR get_org_cur IS
116: SELECT organization_id,location_id
117: FROM jai_ap_invoice_lines
118: WHERE invoice_id = pr_new.invoice_id
119: AND invoice_line_number = (SELECT parent_invoice_line_number
120: FROM jai_ap_invoice_lines jail
121: WHERE jail.invoice_line_number = pr_new.invoice_line_number

Line 120: FROM jai_ap_invoice_lines jail

116: SELECT organization_id,location_id
117: FROM jai_ap_invoice_lines
118: WHERE invoice_id = pr_new.invoice_id
119: AND invoice_line_number = (SELECT parent_invoice_line_number
120: FROM jai_ap_invoice_lines jail
121: WHERE jail.invoice_line_number = pr_new.invoice_line_number
122: AND jail.invoice_id = pr_new.invoice_id)
123: AND parent_invoice_line_number IS NULL;
124:

Line 232: lv_interface_flag jai_ap_invoice_lines.interface_flag%type; --Added by zhiwei for POT change Bug#13023443 on 20110930

228:
229: ---------------------------------------------------------------------------
230: --Add by Wenqiong for POT, reg bug#12397015 on 26-Apr-2011, end
231:
232: lv_interface_flag jai_ap_invoice_lines.interface_flag%type; --Added by zhiwei for POT change Bug#13023443 on 20110930
233: lv_interface_event jai_ap_invoice_lines.interface_event%type; --Added by zhiwei for POT change Bug#13023443 on 20110930
234:
235: --The cursor get_jai_interface_info is added by Eric Ma for bug 13405997
236: CURSOR get_jai_interface_info

Line 233: lv_interface_event jai_ap_invoice_lines.interface_event%type; --Added by zhiwei for POT change Bug#13023443 on 20110930

229: ---------------------------------------------------------------------------
230: --Add by Wenqiong for POT, reg bug#12397015 on 26-Apr-2011, end
231:
232: lv_interface_flag jai_ap_invoice_lines.interface_flag%type; --Added by zhiwei for POT change Bug#13023443 on 20110930
233: lv_interface_event jai_ap_invoice_lines.interface_event%type; --Added by zhiwei for POT change Bug#13023443 on 20110930
234:
235: --The cursor get_jai_interface_info is added by Eric Ma for bug 13405997
236: CURSOR get_jai_interface_info
237: IS

Line 239: FROM jai_ap_invoice_lines jail_parent,

235: --The cursor get_jai_interface_info is added by Eric Ma for bug 13405997
236: CURSOR get_jai_interface_info
237: IS
238: SELECT interface_flag,interface_event
239: FROM jai_ap_invoice_lines jail_parent,
240: (SELECT invoice_id, parent_invoice_line_number
241: FROM jai_ap_invoice_lines
242: WHERE invoice_line_number = pr_new.invoice_line_number
243: AND invoice_id = pr_new.invoice_id) jail_child

Line 241: FROM jai_ap_invoice_lines

237: IS
238: SELECT interface_flag,interface_event
239: FROM jai_ap_invoice_lines jail_parent,
240: (SELECT invoice_id, parent_invoice_line_number
241: FROM jai_ap_invoice_lines
242: WHERE invoice_line_number = pr_new.invoice_line_number
243: AND invoice_id = pr_new.invoice_id) jail_child
244: WHERE jail_parent.invoice_id = jail_child.invoice_id
245: AND jail_parent.invoice_line_number = jail_child.parent_invoice_line_number;

Line 668: FROM jai_ap_invoice_lines jail_parent,

664: --For External , if Service tax and GL > POT then ignore .
665: /* Move the select into to declar section as a cursor
666: SELECT interface_flag,interface_event
667: INTO lv_interface_flag,lv_interface_event
668: FROM jai_ap_invoice_lines jail_parent,
669: (SELECT invoice_id, parent_invoice_line_number
670: FROM jai_ap_invoice_lines
671: WHERE invoice_line_number = pr_new.invoice_line_number
672: AND invoice_id = pr_new.invoice_id) jail_child

Line 670: FROM jai_ap_invoice_lines

666: SELECT interface_flag,interface_event
667: INTO lv_interface_flag,lv_interface_event
668: FROM jai_ap_invoice_lines jail_parent,
669: (SELECT invoice_id, parent_invoice_line_number
670: FROM jai_ap_invoice_lines
671: WHERE invoice_line_number = pr_new.invoice_line_number
672: AND invoice_id = pr_new.invoice_id) jail_child
673: WHERE jail_parent.invoice_id = jail_child.invoice_id
674: AND jail_parent.invoice_line_number = jail_child.parent_invoice_line_number;