DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on OE_WF_LINE_ASSIGN_V

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

1305: /*
1306: ends here additions by sriram -bug#3607101
1307: */
1308:
1309: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
1310: select 1
1311: from oe_wf_order_assign_v o_wf_asg
1312: where order_type_name = pr_new.interface_line_attribute2
1313: and exists

Line 1316: from oe_wf_line_assign_v l_wf_asg

1312: where order_type_name = pr_new.interface_line_attribute2
1313: and exists
1314: (
1315: select 1
1316: from oe_wf_line_assign_v l_wf_asg
1317: where assignment_id = o_wf_asg.assignment_id
1318: and process_name = cp_process_name /*'R_BILL_ONLY' Ramananda for removal of SQL LITERALs */
1319: and order_type_id = l_wf_asg.order_type_id
1320: )