DBA Data[Home] [Help]

APPS.GL_INTERCOMPANY_ACCTS_PKG dependencies on GL_INTERCOMPANY_ACCOUNTS

Line 58: FROM gl_intercompany_accounts ia

54: x_je_category_name VARCHAR2,
55: x_bal_seg_value VARCHAR2 ) IS
56: CURSOR c_dup IS
57: SELECT 'Duplicate row found'
58: FROM gl_intercompany_accounts ia
59: WHERE ia.LEDGER_ID = x_ledger_id
60: AND ia.JE_SOURCE_NAME = x_je_source_name
61: AND ia.JE_CATEGORY_NAME = x_je_category_name
62: AND ia.bal_seg_value = x_bal_seg_value

Line 101: FROM gl_intercompany_accounts ia

97: FUNCTION is_other_exist( x_ledger_id NUMBER ) RETURN BOOLEAN IS
98:
99: CURSOR c_other IS
100: SELECT 'found'
101: FROM gl_intercompany_accounts ia
102: WHERE ia.LEDGER_ID = x_ledger_id
103: AND ia.JE_SOURCE_NAME = 'Other'
104: AND ia.JE_CATEGORY_NAME = 'Other'
105: AND ia.BAL_SEG_VALUE = 'OTHER1234567890123456789012345';