APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on OE_WF_LINE_ASSIGN_V

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

1376: /*
1377: ends here additions by sriram -bug#3607101
1378: */
1379:
1380: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
1381: select 1
1382: from oe_wf_order_assign_v o_wf_asg
1383: where order_type_name = pr_new.interface_line_attribute2
1384: and exists

Line 1387: from oe_wf_line_assign_v l_wf_asg

1383: where order_type_name = pr_new.interface_line_attribute2
1384: and exists
1385: (
1386: select 1
1387: from oe_wf_line_assign_v l_wf_asg
1388: where assignment_id = o_wf_asg.assignment_id
1389: and process_name = cp_process_name /*'R_BILL_ONLY' Ramananda for removal of SQL LITERALs */
1390: and order_type_id = l_wf_asg.order_type_id
1391: )

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

4707:
4708:
4709: /*changes by abezgam for bug 10176878, start */
4710:
4711: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
4712: select 1
4713: from oe_wf_order_assign_v o_wf_asg
4714: where order_type_name = pr_new.interface_line_attribute2
4715: and exists

Line 4718: from oe_wf_line_assign_v l_wf_asg

4714: where order_type_name = pr_new.interface_line_attribute2
4715: and exists
4716: (
4717: select 1
4718: from oe_wf_line_assign_v l_wf_asg
4719: where assignment_id = o_wf_asg.assignment_id
4720: and process_name = cp_process_name /*'R_BILL_ONLY' Ramananda for removal of SQL LITERALs */
4721: and order_type_id = l_wf_asg.order_type_id
4722: )