DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on GL_LEDGER_SEGMENT_VALUES

Line 3786: p_balancing_segment_value IN gl_ledger_segment_values.segment_value%type,

3782: -- bug 7531219
3783: -- Function to validate balancing segment to the ledger
3784: FUNCTION is_balancing_segment_valid (
3785: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type,
3786: p_balancing_segment_value IN gl_ledger_segment_values.segment_value%type,
3787: p_date IN DATE,
3788: p_calling_sequence IN VARCHAR2)
3789: RETURN BOOLEAN IS
3790: l_valid varchar2(1) := 'N';

Line 3815: FROM gl_ledger_segment_values glsv

3811: begin
3812:
3813: SELECT 'Y'
3814: INTO l_valid
3815: FROM gl_ledger_segment_values glsv
3816: WHERE glsv.segment_value = p_balancing_segment_value
3817: AND glsv.segment_type_code = 'B'
3818: AND glsv.ledger_id = p_set_of_books_id
3819: AND p_date BETWEEN NVL(glsv.start_date, p_date)