APPS.PSP_PSPARREP_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 18: FROM PER_TIME_PERIODS PTP1

14: l_time_period_id NUMBER(15);
15:
16: Cursor c_begin_period_id IS
17: SELECT min(PTP1.time_period_id) time_period_id
18: FROM PER_TIME_PERIODS PTP1
19: WHERE PTP1.payroll_id = nvl(p_payroll_id,PTP1.payroll_id);
20:
21: x_period_id c_begin_period_id%ROWTYPE;
22:

Line 25: FROM PER_TIME_PERIODS PTP

21: x_period_id c_begin_period_id%ROWTYPE;
22:
23: Cursor c_period IS
24: SELECT PTP.period_name period_name
25: FROM PER_TIME_PERIODS PTP
26: WHERE PTP.time_period_id = l_time_period_id;
27:
28: x_period_name c_period%ROWTYPE;
29:

Line 69: FROM PER_TIME_PERIODS PTP1

65: l_time_period_id NUMBER(15);
66:
67: Cursor c_end_period_id IS
68: SELECT max(PTP1.time_period_id) time_period_id
69: FROM PER_TIME_PERIODS PTP1
70: WHERE PTP1.payroll_id = nvl(p_payroll_id,PTP1.payroll_id);
71:
72: x_period_id c_end_period_id%ROWTYPE;
73:

Line 76: FROM PER_TIME_PERIODS PTP

72: x_period_id c_end_period_id%ROWTYPE;
73:
74: Cursor c_period IS
75: SELECT PTP.period_name period_name
76: FROM PER_TIME_PERIODS PTP
77: WHERE PTP.time_period_id = l_time_period_id;
78:
79: x_period_name c_period%ROWTYPE;
80:

Line 122: PER_TIME_PERIODS PTP,

118:
119: CURSOR c_distribution IS
120: SELECT COUNT(*) no_dist_lines
121: FROM PSP_PAYROLL_CONTROLS PPC,
122: PER_TIME_PERIODS PTP,
123: PAY_PAYROLLS_F PPF
124: WHERE PPC.payroll_id = PPF.payroll_id
125: and PPC.time_period_id = PTP.time_period_id
126: and PPC.payroll_id = nvl(p_payroll_id,PPF.payroll_id)

Line 136: PER_TIME_PERIODS PTP,

132:
133: CURSOR c_encumbrance IS
134: SELECT COUNT(*) no_enc_lines
135: FROM PSP_ENC_CONTROLS PEC,
136: PER_TIME_PERIODS PTP,
137: PAY_PAYROLLS_F PPF
138: WHERE PEC.payroll_id = PPF.payroll_id
139: and PEC.time_period_id = PTP.time_period_id
140: and PEC.payroll_id = nvl(p_payroll_id,PPF.payroll_id)