APPS.PAY_IE_PAYE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 123: ,pay_payroll_actions ppa

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

Line 316: ,pay_payroll_actions ppa

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

Line 353: PAY_PAYROLL_ACTIONS PACT

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

Line 592: ,pay_payroll_actions ppa

588: ,nvl(usc_mthly_cutoff_4 ,0)
589: ,nvl(usc_wkly_cutoff_4 ,0)
590: ,nvl(usc_rate_5 ,0)
591: from pay_ie_paye_details_f pipd
592: ,pay_payroll_actions ppa
593: where pipd.assignment_id = p_assignment_id
594: and ppa.payroll_action_id = p_payroll_action_id
595: and ppa.effective_date between pipd.effective_start_date and
596: nvl(pipd.effective_end_date,to_date('31-12-4712','DD-MM-YYYY'))

Line 676: pay_payroll_actions ppa

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

Line 744: ,pay_payroll_actions ppa

740: Cursor csr_pps_number IS
741: SELECT nvl(pap.national_identifier, 'X')
742: FROM per_all_people_f pap
743: ,per_all_assignments_f paa
744: ,pay_payroll_actions ppa
745: WHERE ppa.payroll_action_id = p_payroll_action_id
746: and paa.assignment_id = p_assignment_id
747: and ppa.effective_date between paa.effective_start_date and paa.effective_end_date
748: and paa.person_id = pap.person_id

Line 754: pay_payroll_actions ppa

750:
751: Cursor csr_emer_no_pps_basis IS
752: SELECT nvl(pipd.tax_basis, 'X')
753: from pay_ie_paye_details_f pipd,
754: pay_payroll_actions ppa
755: WHERE ppa.payroll_action_id = p_payroll_action_id
756: and pipd.assignment_id = p_assignment_id
757: and ppa.effective_date between pipd.effective_start_date and pipd.effective_end_date;
758: --

Line 2150: FROM pay_payroll_actions

2146: -- Cursor get_period_dates
2147: --
2148: CURSOR get_period_dates IS
2149: SELECT effective_date
2150: FROM pay_payroll_actions
2151: WHERE payroll_action_id = p_payroll_action_id;
2152: --
2153: -- Cursor get_db
2154: --

Line 2250: pay_payroll_actions ppa

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