DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on GL_SETS_OF_BOOKS

Line 966: FROM Gl_Sets_Of_Books

962: AND h.Org_Id = gd.Org_Id
963: AND h.Org_Id = ctt.Org_Id
964: AND h.Org_Id =:p_org_id
965: AND GP.PERIOD_SET_NAME = (SELECT period_set_name
966: FROM Gl_Sets_Of_Books
967: WHERE set_of_books_id = h.set_of_books_id)
968: AND gp.period_type = (SELECT accounted_period_type
969: FROM Gl_Sets_Of_Books
970: WHERE set_of_books_id = h.set_of_books_id)

Line 969: FROM Gl_Sets_Of_Books

965: AND GP.PERIOD_SET_NAME = (SELECT period_set_name
966: FROM Gl_Sets_Of_Books
967: WHERE set_of_books_id = h.set_of_books_id)
968: AND gp.period_type = (SELECT accounted_period_type
969: FROM Gl_Sets_Of_Books
970: WHERE set_of_books_id = h.set_of_books_id)
971: AND gp.adjustment_period_flag = ''N''
972: AND gp.start_date <= gd.GL_DATE
973: AND gp.end_date >= gd.gl_date ';

Line 2508: FROM Gl_Sets_Of_Books

2504: AND h.Org_Id = ctt.Org_Id
2505: AND h.Org_Id = p_org_id
2506: AND GP.PERIOD_SET_NAME =
2507: (SELECT period_set_name
2508: FROM Gl_Sets_Of_Books
2509: WHERE set_of_books_id = h.set_of_books_id)
2510: AND gp.period_type =
2511: (SELECT accounted_period_type
2512: FROM Gl_Sets_Of_Books

Line 2512: FROM Gl_Sets_Of_Books

2508: FROM Gl_Sets_Of_Books
2509: WHERE set_of_books_id = h.set_of_books_id)
2510: AND gp.period_type =
2511: (SELECT accounted_period_type
2512: FROM Gl_Sets_Of_Books
2513: WHERE set_of_books_id = h.set_of_books_id)
2514: AND gp.adjustment_period_flag = 'N'
2515: AND gp.start_date <= gd.GL_DATE
2516: AND gp.end_date >= gd.gl_date