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

Line 114: ,per_time_periods ptp

110: -- cursor to fetch tax basis
111: cursor c_paye_tax_basis is select tax_basis
112: from pay_ie_paye_details_f pipd
113: ,pay_payroll_actions ppa
114: ,per_time_periods ptp
115: where pipd.assignment_id = p_assignment_id
116: and ppa.payroll_action_id = p_payroll_action_id
117: and ppa.effective_date between pipd.effective_start_date and --Bug Fix 3227184
118: nvl(pipd.effective_end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 166: ,per_time_periods ptp

162: -- Cursor to check whether multiple assignment has a different tax basis
163: CURSOR chk_multi_asgn_tax_basis IS
164: SELECT 1
165: FROM per_all_assignments_f paaf
166: ,per_time_periods ptp
167: ,pay_ie_paye_details_f pipd
168: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
169: AND paaf.assignment_id <> p_assignment_id
170: AND pipd.assignment_id(+) = paaf.assignment_id

Line 216: ,per_time_periods ptp

212: -- Cursor to check whether multiple assignment has a different tax basis
213: CURSOR chk_multi_asgn_tax_basis IS
214: SELECT 1
215: FROM per_all_assignments_f paaf
216: ,per_time_periods ptp
217: ,pay_ie_paye_details_f pipd
218: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
219: AND paaf.assignment_id <> p_assignment_id
220: AND pipd.assignment_id(+) = paaf.assignment_id

Line 307: ,per_time_periods ptp

303: ,nvl(pipd.certificate_issue_date,to_date('01-01-0001','DD-MM-YYYY'))
304: ,ptp.period_type
305: from pay_ie_paye_details_f pipd
306: ,pay_payroll_actions ppa
307: ,per_time_periods ptp
308: where pipd.assignment_id = p_assignment_id
309: and ppa.payroll_action_id = p_payroll_action_id
310: -- and ppa.date_earned between pipd.effective_start_date and
311: and ppa.effective_date between pipd.effective_start_date and --Bug Fix 3227184

Line 324: per_time_periods ptp

320: ,nvl(reduced_tax_credit,0)
321: ,nvl(reduced_standard_cutoff,0)
322: ,nvl(benefit_amount,0)
323: from pay_ie_social_benefits_f psb,
324: per_time_periods ptp
325: where psb.absence_start_date between ptp.start_date and ptp.end_date
326: and ptp.payroll_id = c_payroll_id
327: and psb.assignment_id = p_assignment_id
328: and calculation_option not in('IE_OPTION0','IE_OPTION1')

Line 342: PER_TIME_PERIODS PTP,

338: PAY_ELEMENT_TYPES_F TYPE,
339: PAY_ELEMENT_LINKS_F LINK,
340: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
341: PAY_ELEMENT_ENTRIES_F ENTRY,
342: PER_TIME_PERIODS PTP,
343: PAY_PAYROLL_ACTIONS PACT
344: -- ,FND_SESSIONS SESH
345: WHERE
346: PACT.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID AND

Line 542: from per_time_periods ptp,

538: ,p_payroll_type out nocopy varchar2) return number is
539:
540: cursor c_payroll_details is select ptp.period_num
541: ,ptp.period_type
542: from per_time_periods ptp,
543: pay_all_payrolls pap,
544: pay_payroll_actions ppa
545: where pap.payroll_id = ptp.payroll_id
546: and pap.payroll_id=p_payroll_id