DBA Data[Home] [Help]

APPS.FV_SLA_PROCESSING_PKG dependencies on AR_TRANSACTIONS_S_V

Line 2972: FROM ar_gl_segments_ref_v glseg , ar_transactions_s_v trxobj

2968:
2969: /* Get the AR Invoice Extract Header Balancing Segment Value */
2970: CURSOR cur_ar_inv_head_balseg_value (p_event_id NUMBER) IS
2971: SELECT glseg.ar_gl_balacing_segment_value inv_fund_value
2972: FROM ar_gl_segments_ref_v glseg , ar_transactions_s_v trxobj
2973: WHERE trxobj.trx_receivable_ccid = glseg.ar_gl_code_combination_id
2974: AND trxobj.event_id = p_event_id;
2975:
2976: /* Get the AR Invoice Extract Detail Balancing Segment Value */

Line 2989: FROM ar_gl_segments_ref_v glseg , ar_transactions_s_v trxobj

2985:
2986: /* Get the AR Invoice Extract Header Natural Segment Value */
2987: CURSOR cur_ar_invhead_natseg_value (p_event_id NUMBER) IS
2988: SELECT glseg.ar_gl_natural_segment_value invhead_natseg_value
2989: FROM ar_gl_segments_ref_v glseg , ar_transactions_s_v trxobj
2990: WHERE trxobj.trx_receivable_ccid = glseg.ar_gl_code_combination_id
2991: AND trxobj.event_id = p_event_id;
2992:
2993: