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 6785: FROM GL_PERIOD_STATUSES g

6781: BEGIN
6782: --Fetch the start date of the period in to which p_profile_start_date falls
6783: SELECT start_date
6784: INTO x_start_period_start_date
6785: FROM GL_PERIOD_STATUSES g
6786: ,PA_IMPLEMENTATIONS i
6787: WHERE adjustment_period_flag = 'N'
6788: AND g.application_id = pa_period_process_pkg.application_id
6789: AND g.set_of_books_id = i.set_of_books_id

Line 6795: FROM GL_PERIOD_STATUSES g

6791: EXCEPTION
6792: WHEN NO_DATA_FOUND THEN
6793: SELECT MIN(start_date)
6794: INTO x_start_period_start_date
6795: FROM GL_PERIOD_STATUSES g
6796: ,PA_IMPLEMENTATIONS i
6797: WHERE adjustment_period_flag = 'N'
6798: AND g.application_id = pa_period_process_pkg.application_id
6799: AND g.set_of_books_id = i.set_of_books_id;

Line 6806: FROM GL_PERIOD_STATUSES g

6802: BEGIN
6803: --Fetch the end date of the period in to which p_profile_end_date falls
6804: SELECT end_date
6805: INTO x_end_period_end_date
6806: FROM GL_PERIOD_STATUSES g
6807: ,PA_IMPLEMENTATIONS i
6808: WHERE adjustment_period_flag = 'N'
6809: AND g.application_id = pa_period_process_pkg.application_id
6810: AND g.set_of_books_id = i.set_of_books_id

Line 6816: FROM GL_PERIOD_STATUSES g

6812: EXCEPTION
6813: WHEN NO_DATA_FOUND THEN
6814: SELECT MAX(end_date)
6815: INTO x_end_period_end_date--Selected the max(end_date) into x_end_period_end_date. Bug 3329002.
6816: FROM GL_PERIOD_STATUSES g
6817: ,PA_IMPLEMENTATIONS i
6818: WHERE adjustment_period_flag = 'N'
6819: AND g.application_id = pa_period_process_pkg.application_id
6820: AND g.set_of_books_id = i.set_of_books_id;

Line 6887: FROM GL_PERIOD_STATUSES a

6883: --Select start date of periods which is 51 periods before end period
6884:
6885: SELECT start_date
6886: INTO l_profile_start_date
6887: FROM GL_PERIOD_STATUSES a
6888: ,PA_IMPLEMENTATIONS i
6889: WHERE a.application_id = pa_period_process_pkg.application_id
6890: AND a.set_of_books_id = i.set_of_books_id
6891: AND a.adjustment_period_flag = 'N'

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

6888: ,PA_IMPLEMENTATIONS i
6889: WHERE a.application_id = pa_period_process_pkg.application_id
6890: AND a.set_of_books_id = i.set_of_books_id
6891: AND a.adjustment_period_flag = 'N'
6892: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6893: ,PA_IMPLEMENTATIONS i2
6894: WHERE b.adjustment_period_flag = 'N'
6895: AND b.application_id = pa_period_process_pkg.application_id
6896: AND b.set_of_books_id = i2.set_of_books_id

Line 6910: FROM GL_PERIOD_STATUSES a

6906: END IF;
6907: */
6908: SELECT MIN(start_date)
6909: INTO l_profile_start_date
6910: FROM GL_PERIOD_STATUSES a
6911: ,PA_IMPLEMENTATIONS i
6912: WHERE a.application_id = pa_period_process_pkg.application_id
6913: AND a.set_of_books_id = i.set_of_books_id
6914: AND a.adjustment_period_flag = 'N';

Line 6976: FROM GL_PERIOD_STATUSES a

6972: --Select the 51st period's start date from start period as profile end date
6973:
6974: SELECT end_date
6975: INTO l_profile_end_date
6976: FROM GL_PERIOD_STATUSES a
6977: ,PA_IMPLEMENTATIONS i
6978: WHERE a.application_id = pa_period_process_pkg.application_id
6979: AND a.set_of_books_id = i.set_of_books_id
6980: AND a.adjustment_period_flag = 'N'

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

6977: ,PA_IMPLEMENTATIONS i
6978: WHERE a.application_id = pa_period_process_pkg.application_id
6979: AND a.set_of_books_id = i.set_of_books_id
6980: AND a.adjustment_period_flag = 'N'
6981: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6982: ,PA_IMPLEMENTATIONS i2
6983: WHERE b.adjustment_period_flag = 'N'
6984: AND b.application_id = pa_period_process_pkg.application_id
6985: AND b.set_of_books_id = i2.set_of_books_id

Line 6999: FROM GL_PERIOD_STATUSES a

6995: END IF;
6996: */
6997: SELECT MAX(end_date)
6998: INTO l_profile_end_date
6999: FROM GL_PERIOD_STATUSES a
7000: ,PA_IMPLEMENTATIONS i
7001: WHERE a.application_id = pa_period_process_pkg.application_id
7002: AND a.set_of_books_id = i.set_of_books_id
7003: AND a.adjustment_period_flag = 'N';

Line 7250: FROM GL_PERIOD_STATUSES a

7246: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
7247:
7248: SELECT count(*)
7249: INTO l_number_of_periods
7250: FROM GL_PERIOD_STATUSES a
7251: ,PA_IMPLEMENTATIONS i
7252: WHERE a.application_id = pa_period_process_pkg.application_id
7253: AND a.set_of_books_id = i.set_of_books_id
7254: AND a.adjustment_period_flag = 'N'

Line 7301: FROM GL_PERIOD_STATUSES g

7297: IF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
7298:
7299: SELECT start_date
7300: INTO l_profile_start_date
7301: FROM GL_PERIOD_STATUSES g
7302: ,PA_IMPLEMENTATIONS i
7303: WHERE adjustment_period_flag = 'N'
7304: AND g.application_id = pa_period_process_pkg.application_id
7305: AND g.set_of_books_id = i.set_of_books_id