APPS.PAY_IE_P35 dependencies on PAY_IE_PAYE_DETAILS_F

Line 1431: -- pay_ie_paye_details_f payef,

1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,
1432: per_time_periods ptp,
1433: per_people_f ppf
1434: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'
1435: AND pact_iedi.action_context_type = 'AAP'

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

1634: per_people_f ppf,
1635: per_periods_of_service pps,
1636: per_assignments_f paf,
1637: per_addresses pad,
1638: -- pay_ie_paye_details_f payef, --Bug 4154171
1639: pay_all_payrolls_f papf,
1640: pay_payroll_actions ppa
1641: WHERE pai.locking_action_id = p_locked_action
1642: AND paa.assignment_action_id = pai.locked_action_id

Line 1841: -- pay_ie_paye_details_f payef,

1837: per_people_f ppf,
1838: per_periods_of_service pps,
1839: per_assignments_f paf,
1840: per_addresses pad,
1841: -- pay_ie_paye_details_f payef,
1842: pay_all_payrolls_f papf,
1843: pay_payroll_actions ppa
1844: WHERE paa.assignment_action_id = p_locked_action
1845: -- Added for bug 5874653

Line 1871: FROM pay_ie_paye_details_f paye

1867: AND paf.person_id = pps.person_id
1868: /* AND payef.assignment_id(+) = paa.assignment_id
1869: AND ( payef.effective_end_date =
1870: (SELECT MAX (paye.effective_end_date)
1871: FROM pay_ie_paye_details_f paye
1872: WHERE paye.assignment_id = paf.assignment_id
1873: AND paye.effective_start_date <= l_end_date
1874: AND paye.effective_end_date >= l_start_date)
1875: OR payef.effective_end_date IS NULL

Line 1917: pay_ie_paye_details_f paye

1913: /*( NVL(paye.weekly_tax_credit,0) +
1914: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
1915: FROM per_assignments_f paf,
1916: per_time_periods ptp,
1917: pay_ie_paye_details_f paye
1918: WHERE paf.assignment_id = p_assignment_id
1919: AND paye.assignment_id=paf.assignment_id
1920: AND p_term_date between paf.effective_start_date
1921: and paf.effective_end_date

Line 1963: FROM pay_ie_paye_details_f payef

1959: ),
1960: 0
1961: )
1962: ) -- ANNUAL_TAX_CREDIT
1963: FROM pay_ie_paye_details_f payef
1964: WHERE payef.assignment_id=p_assignment_id
1965: -- Bug 6774415 changed effective date to certificate date
1966: AND payef.certificate_start_date <= l_end_date
1967: AND NVL(payef.certificate_end_date,to_date('31/12/4712','DD/MM/YYYY')) >= l_start_date