APPS.JAI_AR_IMPORT_POPU_PKG dependencies on OE_WF_LINE_ASSIGN_V

Line 49: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is

45: SELECT Customer_Trx_Id
46: FROM JAI_AR_TRX_LINES
47: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
48:
49: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
50: select 1
51: from oe_wf_order_assign_v o_wf_asg
52: where order_type_name = pr_new.interface_line_attribute2
53: and exists

Line 56: from oe_wf_line_assign_v l_wf_asg

52: where order_type_name = pr_new.interface_line_attribute2
53: and exists
54: (
55: select 1
56: from oe_wf_line_assign_v l_wf_asg
57: where assignment_id = o_wf_asg.assignment_id
58: and process_name = cp_process_name /*'R_BILL_ONLY' Ramananda for removal of SQL LITERALs */
59: and order_type_id = l_wf_asg.order_type_id
60: );

Line 4975: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is

4971: --Added by Bo Li for ER VAT non-shippable RMA 2010-4-27 Begin
4972:
4973: /*changes by abezgam for bug 10176878, start */
4974:
4975: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
4976: select 1
4977: from oe_wf_order_assign_v o_wf_asg
4978: where order_type_name = pr_new.interface_line_attribute2
4979: and exists

Line 4982: from oe_wf_line_assign_v l_wf_asg

4978: where order_type_name = pr_new.interface_line_attribute2
4979: and exists
4980: (
4981: select 1
4982: from oe_wf_line_assign_v l_wf_asg
4983: where assignment_id = o_wf_asg.assignment_id
4984: and process_name = cp_process_name /*'R_BILL_ONLY' Ramananda for removal of SQL LITERALs */
4985: and order_type_id = l_wf_asg.order_type_id
4986: )