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.PYUDET dependencies on FND_DATE

Line 1530: if p_paye_rec.tax_code_sv not in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00') then --Bug 8785270: Paye 2009-2010 Changes

1526: p_aggregate_flag varchar2)
1527: IS
1528: BEGIN
1529: if p_aggregate_flag ='Y' then
1530: if p_paye_rec.tax_code_sv not in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00') then --Bug 8785270: Paye 2009-2010 Changes
1531: if p_asg_typ in ('ACTIVE_ASSIGN','ACTIVE_APL','SUSP_ASSIGN','TERM_ASSIGN') and g_cpe_flag ='Y' then
1532: if p_paye_rec.tax_basis_sv = 'Non Cumulative' THEN /*Added terminated for soy 08-09*/
1533: p_paye_rec.tax_basis_sv := 'Cumulative';
1534: p_paye_rec.tax_basis_amended := TRUE;

Line 1540: if p_paye_rec.tax_code_sv not in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00') then --Bug 8785270: Paye 2009-2010 Changes

1536: end if;
1537: end if;
1538: end if;
1539: elsif p_aggregate_flag ='N' then
1540: if p_paye_rec.tax_code_sv not in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00') then --Bug 8785270: Paye 2009-2010 Changes
1541: if p_asg_typ in ('ACTIVE_ASSIGN','ACTIVE_APL','SUSP_ASSIGN') then
1542: if p_paye_rec.tax_basis_sv = 'Non Cumulative' then
1543: p_paye_rec.tax_basis_sv := 'Cumulative';
1544: p_paye_rec.tax_basis_amended := TRUE;

Line 1715: --(p_paye_rec.tax_code_sv in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00')) then

1711: --Bug 8785270: Paye 2009-2010 Changes Start
1712: if p_paye_rec.tax_basis_sv <> 'Non Cumulative' AND
1713: -- Bug:9215663 - Modified the code to ensure that the P6/P9 process changes the tax bais form
1714: -- Non Cumulative to Cumulative after 6th Apr 2010.
1715: --(p_paye_rec.tax_code_sv in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00')) then
1716: (p_paye_rec.tax_code_sv in ('D0','SD0') AND p_m34_rec.effective_date < fnd_date.canonical_to_date('2010/04/06 00:00:00')) then
1717: p_paye_rec.tax_basis_sv := 'Non Cumulative';
1718: p_paye_rec.tax_basis_amended := TRUE;
1719: end if;

Line 1716: (p_paye_rec.tax_code_sv in ('D0','SD0') AND p_m34_rec.effective_date < fnd_date.canonical_to_date('2010/04/06 00:00:00')) then

1712: if p_paye_rec.tax_basis_sv <> 'Non Cumulative' AND
1713: -- Bug:9215663 - Modified the code to ensure that the P6/P9 process changes the tax bais form
1714: -- Non Cumulative to Cumulative after 6th Apr 2010.
1715: --(p_paye_rec.tax_code_sv in ('D0','SD0') OR g_effective_date >= fnd_date.canonical_to_date('2010/04/06 00:00:00')) then
1716: (p_paye_rec.tax_code_sv in ('D0','SD0') AND p_m34_rec.effective_date < fnd_date.canonical_to_date('2010/04/06 00:00:00')) then
1717: p_paye_rec.tax_basis_sv := 'Non Cumulative';
1718: p_paye_rec.tax_basis_amended := TRUE;
1719: end if;
1720: --Bug 8785270: Paye 2009-2010 Changes End

Line 2436: p_entry_information1 => fnd_date.date_to_canonical(l_issue_date),

2432: p_num_entry_values => l_num_entry_values,
2433: p_input_value_id_tbl => l_input_value_id_tbl,
2434: p_entry_value_tbl => l_entry_value_tbl,
2435: p_entry_information_category => 'GB_PAYE',
2436: p_entry_information1 => fnd_date.date_to_canonical(l_issue_date),
2437: p_entry_information2 => fnd_date.date_to_canonical(l_message_date));
2438:
2439: -- For bug 8485686
2440: pqp_gb_ad_ee.g_global_paye_validation := 'Y';

Line 2437: p_entry_information2 => fnd_date.date_to_canonical(l_message_date));

2433: p_input_value_id_tbl => l_input_value_id_tbl,
2434: p_entry_value_tbl => l_entry_value_tbl,
2435: p_entry_information_category => 'GB_PAYE',
2436: p_entry_information1 => fnd_date.date_to_canonical(l_issue_date),
2437: p_entry_information2 => fnd_date.date_to_canonical(l_message_date));
2438:
2439: -- For bug 8485686
2440: pqp_gb_ad_ee.g_global_paye_validation := 'Y';
2441:

Line 2606: AND p_m34_rec.effective_date >= fnd_date.canonical_to_date(PCV_INFORMATION2);

2602: FROM pqp_configuration_values
2603: WHERE business_group_id = g_business_group_id
2604: AND pcv_information_category = 'PAY_GB_RTI_FPS_BACS'
2605: AND pcv_information1 = p_m34_rec.paye_ref
2606: AND p_m34_rec.effective_date >= fnd_date.canonical_to_date(PCV_INFORMATION2);
2607:
2608: l_m34_rec.assignment_number := null;
2609: open csr_get_asg_num;
2610: fetch csr_get_asg_num into l_m34_rec.assignment_number,l_asg_id,l_paye_agg;