APPS.PAY_IE_PAYE_PKG dependencies on PER_TIME_PERIODS

Line 124: ,per_time_periods ptp

120: -- cursor to fetch tax basis
121: cursor c_paye_tax_basis is select tax_basis
122: from pay_ie_paye_details_f pipd
123: ,pay_payroll_actions ppa
124: ,per_time_periods ptp
125: where pipd.assignment_id = p_assignment_id
126: and ppa.payroll_action_id = p_payroll_action_id
127: and ppa.effective_date between pipd.effective_start_date and --Bug Fix 3227184
128: nvl(pipd.effective_end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 176: ,per_time_periods ptp

172: -- Cursor to check whether multiple assignment has a different tax basis
173: CURSOR chk_multi_asgn_tax_basis IS
174: SELECT 1
175: FROM per_all_assignments_f paaf
176: ,per_time_periods ptp
177: ,pay_ie_paye_details_f pipd
178: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
179: AND paaf.assignment_id <> p_assignment_id
180: AND pipd.assignment_id(+) = paaf.assignment_id

Line 226: ,per_time_periods ptp

222: -- Cursor to check whether multiple assignment has a different tax basis
223: CURSOR chk_multi_asgn_tax_basis IS
224: SELECT 1
225: FROM per_all_assignments_f paaf
226: ,per_time_periods ptp
227: ,pay_ie_paye_details_f pipd
228: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
229: AND paaf.assignment_id <> p_assignment_id
230: AND pipd.assignment_id(+) = paaf.assignment_id

Line 317: ,per_time_periods ptp

313: ,nvl(pipd.certificate_issue_date,to_date('01-01-0001','DD-MM-YYYY'))
314: ,ptp.period_type
315: from pay_ie_paye_details_f pipd
316: ,pay_payroll_actions ppa
317: ,per_time_periods ptp
318: where pipd.assignment_id = p_assignment_id
319: and ppa.payroll_action_id = p_payroll_action_id
320: -- and ppa.date_earned between pipd.effective_start_date and
321: and ppa.effective_date between pipd.effective_start_date and --Bug Fix 3227184

Line 334: per_time_periods ptp

330: ,nvl(reduced_tax_credit,0)
331: ,nvl(reduced_standard_cutoff,0)
332: ,nvl(benefit_amount,0)
333: from pay_ie_social_benefits_f psb,
334: per_time_periods ptp
335: where psb.absence_start_date between ptp.start_date and ptp.end_date
336: and ptp.payroll_id = c_payroll_id
337: and psb.assignment_id = p_assignment_id
338: and calculation_option not in('IE_OPTION0','IE_OPTION1')

Line 352: PER_TIME_PERIODS PTP,

348: PAY_ELEMENT_TYPES_F TYPE,
349: PAY_ELEMENT_LINKS_F LINK,
350: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
351: PAY_ELEMENT_ENTRIES_F ENTRY,
352: PER_TIME_PERIODS PTP,
353: PAY_PAYROLL_ACTIONS PACT
354: -- ,FND_SESSIONS SESH
355: WHERE
356: PACT.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID AND

Line 674: from per_time_periods ptp,

670: ,p_payroll_type out nocopy varchar2) return number is
671:
672: cursor c_payroll_details is select ptp.period_num
673: ,ptp.period_type
674: from per_time_periods ptp,
675: pay_all_payrolls pap,
676: pay_payroll_actions ppa
677: where pap.payroll_id = ptp.payroll_id
678: and pap.payroll_id=p_payroll_id

Line 2084: FROM per_time_periods ptp

2080: --
2081: CURSOR get_period_dates IS
2082: SELECT ptp.start_date start_date
2083: ,ptp.end_date end_date
2084: FROM per_time_periods ptp
2085: WHERE ptp.payroll_id=p_payroll_id
2086: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
2087: --
2088: -- Cursor get_db

Line 2202: FROM per_time_periods

2198: l_num_periods NUMBER := 0;
2199:
2200: CURSOR csr_get_periods_between IS
2201: SELECT COUNT (*)
2202: FROM per_time_periods
2203: WHERE payroll_id = p_payroll_id
2204: AND regular_payment_date BETWEEN p_start_date AND p_end_date;
2205:
2206: BEGIN

Line 2248: from per_time_periods ptp,

2244: ,p_last_period_num out nocopy number
2245: ) return number is
2246:
2247: cursor c_last_pay_period is select max(ptp.period_num)
2248: from per_time_periods ptp,
2249: pay_all_payrolls pap,
2250: pay_payroll_actions ppa
2251: where pap.payroll_id = ptp.payroll_id
2252: and pap.payroll_id=p_payroll_id