APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PER_TIME_PERIODS

Line 90: l_time_period per_time_periods.period_name%TYPE;

86: p_template_name IN VARCHAR2,
87: p_xml OUT NOCOPY CLOB
88: )
89: IS
90: l_time_period per_time_periods.period_name%TYPE;
91: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
92: l_bg_name VARCHAR2 (240);
93: l_consolidation_set_name
94: pay_consolidation_sets.consolidation_set_name%TYPE;

Line 107: FROM per_time_periods

103: --
104: CURSOR csr_time_period
105: IS
106: SELECT period_name
107: FROM per_time_periods
108: WHERE time_period_id = p_period_id;
109:
110: --
111: CURSOR csr_consolidation_set_name

Line 160: per_time_periods ptp

156: pay_org_payment_methods_f popmf,
157: pay_payment_types_tl ppttl,
158: pay_payment_types ppt,
159: pay_external_accounts pea,
160: per_time_periods ptp
161: WHERE ppt.payment_type_id = ppttl.payment_type_id
162: AND ppttl.LANGUAGE = USERENV ('LANG')
163: AND popmf.org_payment_method_id =
164: popmftl.org_payment_method_id

Line 226: per_time_periods ptp -- Bug 5070091 Offset payroll change

222: FROM DUAL
223: WHERE EXISTS ( SELECT NULL
224: FROM pay_payroll_actions ppa,
225: pay_assignment_actions paa,
226: per_time_periods ptp -- Bug 5070091 Offset payroll change
227: WHERE paa.payroll_action_id = ppa.payroll_action_id
228: AND ppa.action_status = 'C'
229: AND ppa.action_type IN ('Q', 'R')
230: AND ppa.payroll_id = p_payroll_id

Line 253: FROM /* per_time_periods ptp, */

249: IS
250: SELECT '*** Warning: These Amount totals include payments from previous
251: payroll period(s) ***'
252: payments_from_previous_periods
253: FROM /* per_time_periods ptp, */
254: pay_payroll_actions ppa,
255: pay_assignment_actions paa,
256: pay_pre_payments ppp
257: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 272: per_time_periods ptp1

268: SELECT 1
269: FROM pay_action_interlocks pai,
270: pay_assignment_actions paa1,
271: pay_payroll_actions ppa1,
272: per_time_periods ptp1
273: WHERE pai.locking_action_id = paa.assignment_action_id
274: AND pai.locked_action_id = paa1.assignment_action_id
275: AND ppa1.payroll_action_id = paa1.payroll_action_id
276: AND ppa1.action_type IN ('Q', 'R')

Line 287: per_time_periods ptp2

283: SELECT 1
284: FROM pay_action_interlocks pai2,
285: pay_assignment_actions paa2,
286: pay_payroll_actions ppa2,
287: per_time_periods ptp2
288: WHERE pai2.locking_action_id = paa.assignment_action_id
289: AND pai2.locked_action_id = paa2.assignment_action_id
290: AND ppa2.payroll_action_id = paa2.payroll_action_id
291: AND ppa2.action_type IN ('Q', 'R')