APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on GL_PERIOD_STATUSES

Line 4500: GL_PERIOD_STATUSES GL_PS,

4496: GL_PS.PERIOD_YEAR,
4497: GL_PS.PERIOD_NUM,
4498: GL_PS.QUARTER_NUM
4499: FROM
4500: GL_PERIOD_STATUSES GL_PS,
4501: GL_PERIOD_STATUSES PO_PS,
4502: GL_SETS_OF_BOOKS GL_SOB
4503: WHERE
4504: -- Join conditions:

Line 4501: GL_PERIOD_STATUSES PO_PS,

4497: GL_PS.PERIOD_NUM,
4498: GL_PS.QUARTER_NUM
4499: FROM
4500: GL_PERIOD_STATUSES GL_PS,
4501: GL_PERIOD_STATUSES PO_PS,
4502: GL_SETS_OF_BOOKS GL_SOB
4503: WHERE
4504: -- Join conditions:
4505: GL_SOB.set_of_books_id = p_set_of_books_id

Line 4548: GL_PERIOD_STATUSES GL_PS2

4544: GL_PS2.PERIOD_NUM ,
4545: GL_PS2.QUARTER_NUM,
4546: GL_PS2.START_DATE --
4547: FROM
4548: GL_PERIOD_STATUSES GL_PS2
4549: WHERE
4550: GL_PS2.set_of_books_id = p_set_of_books_id AND
4551: GL_PS2.application_id= 101 AND
4552: /* Bug 3967418 Start */

Line 4558: GL_PERIOD_STATUSES GL_PS

4554: /* Bug 3967418 End */
4555: GL_PS2.start_date=
4556: (SELECT min(gl_ps.start_date)
4557: FROM
4558: GL_PERIOD_STATUSES GL_PS
4559: , GL_PERIOD_STATUSES PO_PS
4560: , GL_SETS_OF_BOOKS GL_SOB
4561: WHERE
4562: -- Join conditions:

Line 4559: , GL_PERIOD_STATUSES PO_PS

4555: GL_PS2.start_date=
4556: (SELECT min(gl_ps.start_date)
4557: FROM
4558: GL_PERIOD_STATUSES GL_PS
4559: , GL_PERIOD_STATUSES PO_PS
4560: , GL_SETS_OF_BOOKS GL_SOB
4561: WHERE
4562: -- Join conditions:
4563: GL_SOB.set_of_books_id = p_set_of_books_id

Line 4608: GL_PERIOD_STATUSES GL_PS2

4604: GL_PS2.PERIOD_NUM ,
4605: GL_PS2.QUARTER_NUM,
4606: GL_PS2.START_DATE --
4607: FROM
4608: GL_PERIOD_STATUSES GL_PS2
4609: WHERE
4610: GL_PS2.set_of_books_id = p_set_of_books_id AND
4611: GL_PS2.application_id= 101 AND
4612: /* Bug 3967418 Start */

Line 4618: GL_PERIOD_STATUSES GL_PS

4614: /* Bug 3967418 End */
4615: GL_PS2.end_date=
4616: (SELECT max(gl_ps.end_date)
4617: FROM
4618: GL_PERIOD_STATUSES GL_PS
4619: , GL_PERIOD_STATUSES PO_PS
4620: , GL_SETS_OF_BOOKS GL_SOB
4621: WHERE
4622: -- Join conditions:

Line 4619: , GL_PERIOD_STATUSES PO_PS

4615: GL_PS2.end_date=
4616: (SELECT max(gl_ps.end_date)
4617: FROM
4618: GL_PERIOD_STATUSES GL_PS
4619: , GL_PERIOD_STATUSES PO_PS
4620: , GL_SETS_OF_BOOKS GL_SOB
4621: WHERE
4622: -- Join conditions:
4623: GL_SOB.set_of_books_id = p_set_of_books_id

Line 4679: GL_PERIOD_STATUSES GL_PS,

4675: GL_PS.PERIOD_NUM,
4676: GL_PS.QUARTER_NUM,
4677: TRUNC(GL_PS.START_DATE) latest_open_date
4678: FROM
4679: GL_PERIOD_STATUSES GL_PS,
4680: GL_PERIOD_STATUSES PO_PS,
4681: GL_SETS_OF_BOOKS GL_SOB
4682: WHERE GL_SOB.set_of_books_id = p_set_of_books_id
4683: AND GL_PS.application_id = 101

Line 4680: GL_PERIOD_STATUSES PO_PS,

4676: GL_PS.QUARTER_NUM,
4677: TRUNC(GL_PS.START_DATE) latest_open_date
4678: FROM
4679: GL_PERIOD_STATUSES GL_PS,
4680: GL_PERIOD_STATUSES PO_PS,
4681: GL_SETS_OF_BOOKS GL_SOB
4682: WHERE GL_SOB.set_of_books_id = p_set_of_books_id
4683: AND GL_PS.application_id = 101
4684: AND PO_PS.application_id = 201