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 PAY_PAYROLL_ACTIONS

Line 113: ,pay_payroll_actions ppa

109:
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

Line 306: ,pay_payroll_actions ppa

302: ,pipd.tax_assess_basis
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

Line 343: PAY_PAYROLL_ACTIONS PACT

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
347: --PTP.TIME_PERIOD_ID = PACT.TIME_PERIOD_ID AND -- Bug 5070091 Offset payroll change

Line 544: pay_payroll_actions ppa

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
547: and ppa.payroll_id=pap.payroll_id
548: and ppa.payroll_action_id=p_payroll_action_id

Line 612: ,pay_payroll_actions ppa

608: Cursor csr_pps_number IS
609: SELECT nvl(pap.national_identifier, 'X')
610: FROM per_all_people_f pap
611: ,per_all_assignments_f paa
612: ,pay_payroll_actions ppa
613: WHERE ppa.payroll_action_id = p_payroll_action_id
614: and paa.assignment_id = p_assignment_id
615: and ppa.effective_date between paa.effective_start_date and paa.effective_end_date
616: and paa.person_id = pap.person_id

Line 622: pay_payroll_actions ppa

618:
619: Cursor csr_emer_no_pps_basis IS
620: SELECT nvl(pipd.tax_basis, 'X')
621: from pay_ie_paye_details_f pipd,
622: pay_payroll_actions ppa
623: WHERE ppa.payroll_action_id = p_payroll_action_id
624: and pipd.assignment_id = p_assignment_id
625: and ppa.effective_date between pipd.effective_start_date and pipd.effective_end_date;
626: --