eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_PUB dependencies on GL_PERIOD_STATUSES

Line 6805: FROM GL_PERIOD_STATUSES g

6801: BEGIN
6802: --Fetch the start date of the period in to which p_profile_start_date falls
6803: SELECT start_date
6804: INTO x_start_period_start_date
6805: FROM GL_PERIOD_STATUSES g
6806: ,PA_IMPLEMENTATIONS i
6807: WHERE adjustment_period_flag = 'N'
6808: AND g.application_id = pa_period_process_pkg.application_id
6809: AND g.set_of_books_id = i.set_of_books_id

Line 6815: FROM GL_PERIOD_STATUSES g

6811: EXCEPTION
6812: WHEN NO_DATA_FOUND THEN
6813: SELECT MIN(start_date)
6814: INTO x_start_period_start_date
6815: FROM GL_PERIOD_STATUSES g
6816: ,PA_IMPLEMENTATIONS i
6817: WHERE adjustment_period_flag = 'N'
6818: AND g.application_id = pa_period_process_pkg.application_id
6819: AND g.set_of_books_id = i.set_of_books_id;

Line 6826: FROM GL_PERIOD_STATUSES g

6822: BEGIN
6823: --Fetch the end date of the period in to which p_profile_end_date falls
6824: SELECT end_date
6825: INTO x_end_period_end_date
6826: FROM GL_PERIOD_STATUSES g
6827: ,PA_IMPLEMENTATIONS i
6828: WHERE adjustment_period_flag = 'N'
6829: AND g.application_id = pa_period_process_pkg.application_id
6830: AND g.set_of_books_id = i.set_of_books_id

Line 6836: FROM GL_PERIOD_STATUSES g

6832: EXCEPTION
6833: WHEN NO_DATA_FOUND THEN
6834: SELECT MAX(end_date)
6835: INTO x_end_period_end_date--Selected the max(end_date) into x_end_period_end_date. Bug 3329002.
6836: FROM GL_PERIOD_STATUSES g
6837: ,PA_IMPLEMENTATIONS i
6838: WHERE adjustment_period_flag = 'N'
6839: AND g.application_id = pa_period_process_pkg.application_id
6840: AND g.set_of_books_id = i.set_of_books_id;

Line 6907: FROM GL_PERIOD_STATUSES a

6903: --Select start date of periods which is 51 periods before end period
6904:
6905: SELECT start_date
6906: INTO l_profile_start_date
6907: FROM GL_PERIOD_STATUSES a
6908: ,PA_IMPLEMENTATIONS i
6909: WHERE a.application_id = pa_period_process_pkg.application_id
6910: AND a.set_of_books_id = i.set_of_books_id
6911: AND a.adjustment_period_flag = 'N'

Line 6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b

6908: ,PA_IMPLEMENTATIONS i
6909: WHERE a.application_id = pa_period_process_pkg.application_id
6910: AND a.set_of_books_id = i.set_of_books_id
6911: AND a.adjustment_period_flag = 'N'
6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6913: ,PA_IMPLEMENTATIONS i2
6914: WHERE b.adjustment_period_flag = 'N'
6915: AND b.application_id = pa_period_process_pkg.application_id
6916: AND b.set_of_books_id = i2.set_of_books_id

Line 6930: FROM GL_PERIOD_STATUSES a

6926: END IF;
6927: */
6928: SELECT MIN(start_date)
6929: INTO l_profile_start_date
6930: FROM GL_PERIOD_STATUSES a
6931: ,PA_IMPLEMENTATIONS i
6932: WHERE a.application_id = pa_period_process_pkg.application_id
6933: AND a.set_of_books_id = i.set_of_books_id
6934: AND a.adjustment_period_flag = 'N';

Line 6996: FROM GL_PERIOD_STATUSES a

6992: --Select the 51st period's start date from start period as profile end date
6993:
6994: SELECT end_date
6995: INTO l_profile_end_date
6996: FROM GL_PERIOD_STATUSES a
6997: ,PA_IMPLEMENTATIONS i
6998: WHERE a.application_id = pa_period_process_pkg.application_id
6999: AND a.set_of_books_id = i.set_of_books_id
7000: AND a.adjustment_period_flag = 'N'

Line 7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b

6997: ,PA_IMPLEMENTATIONS i
6998: WHERE a.application_id = pa_period_process_pkg.application_id
6999: AND a.set_of_books_id = i.set_of_books_id
7000: AND a.adjustment_period_flag = 'N'
7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
7002: ,PA_IMPLEMENTATIONS i2
7003: WHERE b.adjustment_period_flag = 'N'
7004: AND b.application_id = pa_period_process_pkg.application_id
7005: AND b.set_of_books_id = i2.set_of_books_id

Line 7019: FROM GL_PERIOD_STATUSES a

7015: END IF;
7016: */
7017: SELECT MAX(end_date)
7018: INTO l_profile_end_date
7019: FROM GL_PERIOD_STATUSES a
7020: ,PA_IMPLEMENTATIONS i
7021: WHERE a.application_id = pa_period_process_pkg.application_id
7022: AND a.set_of_books_id = i.set_of_books_id
7023: AND a.adjustment_period_flag = 'N';

Line 7270: FROM GL_PERIOD_STATUSES a

7266: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
7267:
7268: SELECT count(*)
7269: INTO l_number_of_periods
7270: FROM GL_PERIOD_STATUSES a
7271: ,PA_IMPLEMENTATIONS i
7272: WHERE a.application_id = pa_period_process_pkg.application_id
7273: AND a.set_of_books_id = i.set_of_books_id
7274: AND a.adjustment_period_flag = 'N'

Line 7321: FROM GL_PERIOD_STATUSES g

7317: IF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
7318:
7319: SELECT start_date
7320: INTO l_profile_start_date
7321: FROM GL_PERIOD_STATUSES g
7322: ,PA_IMPLEMENTATIONS i
7323: WHERE adjustment_period_flag = 'N'
7324: AND g.application_id = pa_period_process_pkg.application_id
7325: AND g.set_of_books_id = i.set_of_books_id