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.PSP_ARCHIVE_RETRIEVE dependencies on PER_TIME_PERIODS

Line 31: PER_TIME_PERIODS PTP

27: SELECT distinct PPC.source_type,
28: PPC.time_period_id,
29: PTP.period_name
30: FROM PSP_PAYROLL_CONTROLS PPC,
31: PER_TIME_PERIODS PTP
32: WHERE PPC.time_period_id = PTP.time_period_id
33: and PPC.payroll_id = p_payroll_id
34: and PPC.time_period_id >= p_begin_period
35: and PPC.time_period_id <= p_end_period

Line 63: -- PER_TIME_PERIODS PTP1,

59: -- PER.version_num
60: -- FROM PSP_EFFORT_REPORTS PER,
61: -- PSP_EFFORT_REPORT_DETAILS PERD,
62: -- PER_ASSIGNMENTS_F PAF,
63: -- PER_TIME_PERIODS PTP1,
64: -- PER_TIME_PERIODS PTP2,
65: -- PSP_EFFORT_REPORT_PERIODS PERP,
66: -- PSP_EFFORT_REPORT_TEMPLATES PERT
67: -- WHERE PER.status_Code <> 'C'

Line 64: -- PER_TIME_PERIODS PTP2,

60: -- FROM PSP_EFFORT_REPORTS PER,
61: -- PSP_EFFORT_REPORT_DETAILS PERD,
62: -- PER_ASSIGNMENTS_F PAF,
63: -- PER_TIME_PERIODS PTP1,
64: -- PER_TIME_PERIODS PTP2,
65: -- PSP_EFFORT_REPORT_PERIODS PERP,
66: -- PSP_EFFORT_REPORT_TEMPLATES PERT
67: -- WHERE PER.status_Code <> 'C'
68: -- and PER.effort_Report_id = PERD.effort_report_id

Line 88: FROM per_time_periods PTP

84: -- );
85:
86: CURSOR effort_pending_cur IS
87: SELECT period_name
88: FROM per_time_periods PTP
89: WHERE PTP.payroll_id = p_payroll_id
90: AND PTP.time_period_id >= p_begin_period
91: AND PTP.time_period_id <= p_end_period
92: AND EXISTS (SELECT 1

Line 118: PER_TIME_PERIODS PTP

114: CURSOR valid_period_cur IS
115: SELECT distinct PPC.time_period_id,
116: PTP.period_name
117: FROM PSP_PAYROLL_CONTROLS PPC,
118: PER_TIME_PERIODS PTP
119: WHERE PPC.payroll_id = p_payroll_id
120: and PPC.time_period_id >= p_begin_period
121: and PPC.time_period_id <= p_end_period
122: and PPC.archive_flag is NULL

Line 138: FROM PER_TIME_PERIODS PTP

134: and PPF.gl_set_of_books_id = p_set_of_books_id;
135:
136: CURSOR begin_period_name_cur IS
137: SELECT distinct PTP.period_name
138: FROM PER_TIME_PERIODS PTP
139: WHERE PTP.time_period_id = p_begin_period;
140:
141: CURSOR end_period_name_cur IS
142: SELECT distinct PTP.period_name

Line 143: FROM PER_TIME_PERIODS PTP

139: WHERE PTP.time_period_id = p_begin_period;
140:
141: CURSOR end_period_name_cur IS
142: SELECT distinct PTP.period_name
143: FROM PER_TIME_PERIODS PTP
144: WHERE PTP.time_period_id = p_end_period;
145:
146: l_error_api_name VARCHAR2(2000);
147: l_status VARCHAR2(15);

Line 644: PER_TIME_PERIODS PTP

640: CURSOR valid_period_cur IS
641: SELECT distinct PPC.time_period_id,
642: PTP.period_name
643: FROM PSP_PAYROLL_CONTROLS PPC,
644: PER_TIME_PERIODS PTP
645: WHERE PPC.payroll_id = p_payroll_id
646: and PPC.time_period_id >= p_begin_period
647: and PPC.time_period_id <= p_end_period
648: and PPC.archive_flag = 'Y'

Line 664: FROM PER_TIME_PERIODS PTP

660: and PPF.gl_set_of_books_id = p_set_of_books_id;
661:
662: CURSOR begin_period_name_cur IS
663: SELECT distinct PTP.period_name
664: FROM PER_TIME_PERIODS PTP
665: WHERE PTP.time_period_id = p_begin_period;
666:
667: CURSOR end_period_name_cur IS
668: SELECT distinct PTP.period_name

Line 669: FROM PER_TIME_PERIODS PTP

665: WHERE PTP.time_period_id = p_begin_period;
666:
667: CURSOR end_period_name_cur IS
668: SELECT distinct PTP.period_name
669: FROM PER_TIME_PERIODS PTP
670: WHERE PTP.time_period_id = p_end_period;
671:
672: l_error_api_name VARCHAR2(2000);
673: l_status VARCHAR2(15);

Line 1054: PER_TIME_PERIODS PTP

1050: -- Cursor to select invalid time periods
1051: CURSOR invalid_period_cur
1052: IS Select distinct period_name
1053: FROM PSP_ENC_CONTROLS PEC,
1054: PER_TIME_PERIODS PTP
1055: WHERE PEC.time_period_id = PTP.time_period_id
1056: AND PEC.payroll_id = p_payroll_id
1057: AND PEC.time_period_id >= p_begin_period
1058: AND PEC.time_period_id <= p_end_period

Line 1069: PER_TIME_PERIODS PTP

1065: -- Cursor to select valid periods that can be archived
1066: CURSOR valid_period_cur
1067: IS SELECT distinct PEC.time_period_id, PTP.period_name
1068: FROM PSP_ENC_CONTROLS PEC,
1069: PER_TIME_PERIODS PTP
1070: WHERE PTP.time_period_id = PEC.time_period_id
1071: AND PEC.payroll_id = p_payroll_id
1072: AND PEC.time_period_id >= p_begin_period
1073: AND PEC.time_period_id <= p_end_period

Line 1083: PER_TIME_PERIODS PTP1,

1079: -- Cursor to get payroll name, begin period name, end period name for displaying in the messages
1080: CURSOR parameter_cur
1081: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1082: FROM PAY_PAYROLLS_F PPF,
1083: PER_TIME_PERIODS PTP1,
1084: PER_TIME_PERIODS PTP2
1085: WHERE PPF.payroll_id = p_payroll_id
1086: AND PTP1.payroll_id = p_payroll_id
1087: AND PTP1.time_period_id = p_begin_period

Line 1084: PER_TIME_PERIODS PTP2

1080: CURSOR parameter_cur
1081: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1082: FROM PAY_PAYROLLS_F PPF,
1083: PER_TIME_PERIODS PTP1,
1084: PER_TIME_PERIODS PTP2
1085: WHERE PPF.payroll_id = p_payroll_id
1086: AND PTP1.payroll_id = p_payroll_id
1087: AND PTP1.time_period_id = p_begin_period
1088: AND PTP2.payroll_id = p_payroll_id

Line 1352: PER_TIME_PERIODS PTP

1348: -- For bug fix 17770033, 1778727, changed the begin period to end period check as the functionality had changed
1349: CURSOR valid_period_cur
1350: IS SELECT distinct PEC.time_period_id, PTP.period_name
1351: FROM PSP_ENC_CONTROLS PEC,
1352: PER_TIME_PERIODS PTP
1353: WHERE PTP.time_period_id = PEC.time_period_id
1354: AND PEC.payroll_id = p_payroll_id
1355: AND PEC.time_period_id >= p_begin_period
1356: AND PEC.time_period_id <= p_end_period

Line 1366: PER_TIME_PERIODS PTP1,

1362: -- Cursor to get payroll name, begin period name, end period name for displaying in the messages
1363: CURSOR parameter_cur
1364: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1365: FROM PAY_PAYROLLS_F PPF,
1366: PER_TIME_PERIODS PTP1,
1367: PER_TIME_PERIODS PTP2
1368: WHERE PPF.payroll_id = p_payroll_id
1369: AND PTP1.payroll_id = p_payroll_id
1370: AND PTP1.time_period_id = p_begin_period

Line 1367: PER_TIME_PERIODS PTP2

1363: CURSOR parameter_cur
1364: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1365: FROM PAY_PAYROLLS_F PPF,
1366: PER_TIME_PERIODS PTP1,
1367: PER_TIME_PERIODS PTP2
1368: WHERE PPF.payroll_id = p_payroll_id
1369: AND PTP1.payroll_id = p_payroll_id
1370: AND PTP1.time_period_id = p_begin_period
1371: AND PTP2.payroll_id = p_payroll_id