APPS.FV_SLA_PROCESSING_PKG dependencies on AR_GL_SEGMENTS_REF_V

Line 265: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj

261: CURSOR cur_ar_invline_natseg_value (p_event_id NUMBER,
262: p_line_number NUMBER)
263: IS
264: SELECT glseg.ar_gl_natural_segment_value inv_natseg_value
265: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj
266: WHERE trxobj.trx_line_dist_ccid = glseg.ar_gl_code_combination_id
267: AND trxobj.event_id = p_event_id
268: AND trxobj.line_number = p_line_number;
269:

Line 283: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj

279: CURSOR cur_ar_rct_natseg_value (p_event_id NUMBER,
280: p_line_number NUMBER)
281: IS
282: SELECT to_number(glseg.ar_gl_natural_segment_value) rct_natseg_value
283: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj
284: WHERE trxobj.dist_code_combination_id = glseg.ar_gl_code_combination_id
285: AND trxobj.event_id = p_event_id
286: AND trxobj.line_number = p_line_number;
287:

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 2981: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj

2977: CURSOR cur_ar_inv_balseg_value (p_event_id NUMBER,
2978: p_line_number NUMBER)
2979: IS
2980: SELECT glseg.ar_gl_balacing_segment_value inv_fund_value
2981: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj
2982: WHERE trxobj.trx_line_dist_ccid = glseg.ar_gl_code_combination_id
2983: AND trxobj.event_id = p_event_id
2984: AND trxobj.line_number = p_line_number;
2985:

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:

Line 3016: FROM ar_gl_segments_ref_v glseg

3012:
3013: /* Get the Natural Account Segment for a particular CCID */
3014: CURSOR cur_get_natacct (p_ccid NUMBER) IS
3015: SELECT to_number(glseg.ar_gl_natural_segment_value) natseg_value
3016: FROM ar_gl_segments_ref_v glseg
3017: WHERE glseg.ar_gl_code_combination_id = p_ccid;
3018:
3019: /* Get the Miscellaneous Receipt Extract Detail */
3020: CURSOR cur_misc_rct_extract_details IS

Line 3029: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj

3025: CURSOR cur_app_to_trx_balseg_val (p_event_id NUMBER,
3026: p_line_number NUMBER)
3027: IS
3028: SELECT glseg.ar_gl_balacing_segment_value inv_rev_fund_value
3029: FROM ar_gl_segments_ref_v glseg , ar_cust_trx_lines_l_v trxobj
3030: WHERE trxobj.trx_line_dist_ccid = glseg.ar_gl_code_combination_id
3031: AND trxobj.event_id = p_event_id
3032: AND trxobj.line_number = p_line_number;
3033:

Line 3039: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj

3035: CURSOR cur_ar_rct_balseg_value (p_event_id NUMBER,
3036: p_line_number NUMBER)
3037: IS
3038: SELECT glseg.ar_gl_balacing_segment_value rct_fund_value
3039: FROM ar_gl_segments_ref_v glseg , ar_distributions_l_v trxobj
3040: WHERE trxobj.dist_code_combination_id = glseg.ar_gl_code_combination_id
3041: AND trxobj.event_id = p_event_id
3042: AND trxobj.line_number = p_line_number;
3043: