APPS.GL_JE_HEADER_SECURITY dependencies on GL_JE_SEGMENT_VALUES

Line 35: FROM GL_JE_SEGMENT_VALUES jsv

31: p_edate DATE,
32: p_ledger_id NUMBER)
33: IS
34: SELECT 'Invalid'
35: FROM GL_JE_SEGMENT_VALUES jsv
36: WHERE jsv.segment_type_code = p_segment_type_code
37: AND jsv.je_header_id = p_je_header_id
38: AND NOT EXISTS (SELECT 'Valid'
39: FROM GL_LEDGER_SEGMENT_VALUES sv

Line 52: FROM GL_JE_SEGMENT_VALUES jsv

48: p_edate DATE,
49: p_ledger_id NUMBER)
50: IS
51: SELECT 'Invalid'
52: FROM GL_JE_SEGMENT_VALUES jsv
53: WHERE jsv.je_header_id = p_je_header_id
54: AND NOT EXISTS (SELECT 'Valid'
55: FROM GL_LEDGER_SEGMENT_VALUES sv
56: WHERE NVL(trunc(p_edate), NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD')))