DBA Data[Home] [Help]

APPS.GL_ARCH_PRG_FROM_PRD_PKG dependencies on GL_PERIOD_STATUSES

Line 24: GL_PERIOD_STATUSES PS

20: PS.closing_status,
21: PS.period_name,
22: PS.effective_period_num
23: FROM
24: GL_PERIOD_STATUSES PS
25: WHERE
26: PS.application_id = x_appl_id
27: AND PS.ledger_id = x_ledger_id
28: AND PS.closing_status <> 'N'

Line 91: GL_PERIOD_STATUSES PS

87: PS.closing_status,
88: PS.period_name,
89: PS.effective_period_num
90: FROM
91: GL_PERIOD_STATUSES PS
92: WHERE
93: PS.application_id = x_appl_id
94: AND PS.ledger_id = x_ledger_id
95: AND PS.closing_status <> 'N'

Line 166: GL_PERIOD_STATUSES PS

162: PS.closing_status,
163: PS.period_name,
164: PS.effective_period_num
165: FROM
166: GL_PERIOD_STATUSES PS
167: WHERE
168: PS.application_id = x_appl_id
169: AND PS.ledger_id = x_ledger_id
170: AND PS.closing_status <> 'N'

Line 430: GL_PERIOD_STATUSES PS,

426: PS.period_name,
427: PS.closing_status,
428: PS.effective_period_num
429: FROM
430: GL_PERIOD_STATUSES PS,
431: GL_TRANSLATION_TRACKING TT
432: WHERE
433: PS.application_id = x_appl_id
434: AND PS.ledger_id = x_ledger_id

Line 493: GL_PERIOD_STATUSES PS,

489: PS.period_name,
490: PS.closing_status,
491: PS.effective_period_num
492: FROM
493: GL_PERIOD_STATUSES PS,
494: GL_TRANSLATION_TRACKING TT
495: WHERE
496: PS.application_id = x_appl_id
497: AND PS.ledger_id = x_ledger_id

Line 557: GL_PERIOD_STATUSES PS,

553: PS.period_name,
554: PS.closing_status,
555: PS.effective_period_num
556: FROM
557: GL_PERIOD_STATUSES PS,
558: GL_TRANSLATION_TRACKING TT
559: WHERE
560: PS.application_id = x_appl_id
561: AND PS.ledger_id = x_ledger_id