APPS.PAY_IE_P35 dependencies on PAY_IE_PAYE_DETAILS_F

Line 1770: -- pay_ie_paye_details_f payef,

1766: pay_action_information pact_iedi,
1767: pay_action_information pact_ad,
1768: per_assignments_f paf,
1769: per_periods_of_service pps,
1770: -- pay_ie_paye_details_f payef,
1771: per_time_periods ptp,
1772: per_people_f ppf
1773: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'
1774: AND pact_iedi.action_context_type = 'AAP'

Line 2011: -- pay_ie_paye_details_f payef, --Bug 4154171

2007: per_people_f ppf,
2008: per_periods_of_service pps,
2009: per_assignments_f paf,
2010: per_addresses pad,
2011: -- pay_ie_paye_details_f payef, --Bug 4154171
2012: pay_all_payrolls_f papf,
2013: pay_payroll_actions ppa
2014: WHERE pai.locking_action_id = p_locked_action
2015: AND paa.assignment_action_id = pai.locked_action_id

Line 2248: -- pay_ie_paye_details_f payef,

2244: per_people_f ppf,
2245: per_periods_of_service pps,
2246: per_assignments_f paf,
2247: per_addresses pad,
2248: -- pay_ie_paye_details_f payef,
2249: pay_all_payrolls_f papf,
2250: pay_payroll_actions ppa
2251: WHERE paa.assignment_action_id = p_locked_action
2252: -- Added for bug 5874653

Line 2278: FROM pay_ie_paye_details_f paye

2274: AND paf.person_id = pps.person_id
2275: /* AND payef.assignment_id(+) = paa.assignment_id
2276: AND ( payef.effective_end_date =
2277: (SELECT MAX (paye.effective_end_date)
2278: FROM pay_ie_paye_details_f paye
2279: WHERE paye.assignment_id = paf.assignment_id
2280: AND paye.effective_start_date <= l_end_date
2281: AND paye.effective_end_date >= l_start_date)
2282: OR payef.effective_end_date IS NULL

Line 2328: pay_ie_paye_details_f paye

2324: /*( NVL(paye.weekly_tax_credit,0) +
2325: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
2326: FROM per_assignments_f paf,
2327: per_time_periods ptp,
2328: pay_ie_paye_details_f paye
2329: WHERE paf.assignment_id = p_assignment_id
2330: AND paye.assignment_id=paf.assignment_id
2331: AND p_term_date between paf.effective_start_date
2332: and paf.effective_end_date

Line 2378: FROM pay_ie_paye_details_f payef

2374: ),
2375: 0
2376: )
2377: ) -- ANNUAL_TAX_CREDIT
2378: FROM pay_ie_paye_details_f payef
2379: WHERE payef.assignment_id=p_assignment_id
2380: -- Bug 6774415 changed effective date to certificate date
2381: AND payef.certificate_start_date <= l_end_date
2382: AND NVL(payef.certificate_end_date,to_date('31/12/4712','DD/MM/YYYY')) >= l_start_date