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_GB_P11D_ARCHIVE_SS dependencies on FND_DATE

Line 151: AND fnd_date.canonical_to_date(v_benefit_end_date)

147: org.org_information8 tax_office_phone_no, org.org_information3 employer_name,
148: org.org_information4 employer_address
149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )

Line 152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )

148: org.org_information4 employer_address
149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )
156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )

Line 153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )

149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )
156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )
157: AND ppf.business_group_id = org.organization_id AND org.org_information1 = flex.segment1

Line 154: AND fnd_date.canonical_to_date(v_benefit_end_date)

150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )
156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )
157: AND ppf.business_group_id = org.organization_id AND org.org_information1 = flex.segment1
158: AND org.org_information_context = 'Tax Details References' AND ppf.payroll_id = v_payroll_id;

Line 155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )

151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )
156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )
157: AND ppf.business_group_id = org.organization_id AND org.org_information1 = flex.segment1
158: AND org.org_information_context = 'Tax Details References' AND ppf.payroll_id = v_payroll_id;
159:

Line 156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )

152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
154: AND fnd_date.canonical_to_date(v_benefit_end_date)
155: BETWEEN NVL(ppf.effective_start_date, fnd_date.canonical_to_date(v_benefit_end_date) )
156: AND NVL(ppf.effective_end_date, fnd_date.canonical_to_date(v_benefit_end_date) )
157: AND ppf.business_group_id = org.organization_id AND org.org_information1 = flex.segment1
158: AND org.org_information_context = 'Tax Details References' AND ppf.payroll_id = v_payroll_id;
159:
160: PROCEDURE get_parameters(p_payroll_action_id IN NUMBER, p_token_name IN VARCHAR2, p_token_value OUT NOCOPY VARCHAR2)

Line 194: p_token_value := fnd_date.date_to_canonical(l_benefit_start_date);

190: THEN
191: p_token_value := l_business_group_id;
192: ELSIF p_token_name = 'BENEFIT_START_DATE'
193: THEN
194: p_token_value := fnd_date.date_to_canonical(l_benefit_start_date);
195: ELSIF p_token_name = 'BENEFIT_END_DATE'
196: THEN
197: p_token_value := fnd_date.date_to_canonical(l_benefit_end_date);
198: ELSE

Line 197: p_token_value := fnd_date.date_to_canonical(l_benefit_end_date);

193: THEN
194: p_token_value := fnd_date.date_to_canonical(l_benefit_start_date);
195: ELSIF p_token_name = 'BENEFIT_END_DATE'
196: THEN
197: p_token_value := fnd_date.date_to_canonical(l_benefit_end_date);
198: ELSE
199: p_token_value := l_token_value;
200: END IF;
201:

Line 222: and (fnd_date.canonical_to_date(p_end_date) between asg.effective_start_date and asg.effective_end_date

218: and pay.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
219: and (p_tax_ref is null
220: or
221: flex.segment1 = p_tax_ref)
222: and (fnd_date.canonical_to_date(p_end_date) between asg.effective_start_date and asg.effective_end_date
223: or
224: ( asg.effective_end_date = (select max(paa2.effective_end_date)
225: from per_assignments_f paa2
226: where paa2.assignment_id = p_assignment_id)

Line 227: and asg.effective_end_date < fnd_date.canonical_to_date(p_end_date)));

223: or
224: ( asg.effective_end_date = (select max(paa2.effective_end_date)
225: from per_assignments_f paa2
226: where paa2.assignment_id = p_assignment_id)
227: and asg.effective_end_date < fnd_date.canonical_to_date(p_end_date)));
228: BEGIN
229: l_ret := false;
230: open csr_check_asg;
231: fetch csr_check_asg into l_check;

Line 541: and fnd_date.canonical_to_date(l_benefit_end_date) between ppf.effective_start_date and ppf.effective_end_date; */

537: and ppf.payroll_id = nvl(l_payroll_id,ppf.payroll_id)
538: -- bug 7122883 added join condition with business_group_id
539: and ppf.business_group_id=l_business_group_id
540: -- Bug 6278134: Added effective date condition
541: and fnd_date.canonical_to_date(l_benefit_end_date) between ppf.effective_start_date and ppf.effective_end_date; */
542:
543: cursor csr_check_asg_set(p_asg_set_id number) is
544: select count(*)
545: from hr_assignment_set_amendments

Line 578: and (fnd_date.canonical_to_date(l_benefit_end_date)

574: pay_input_values_f piv,
575: pay_element_entries_f pee,
576: pay_element_entry_values_f peev
577: where paa.person_id between stperson AND endperson
578: and (fnd_date.canonical_to_date(l_benefit_end_date)
579: between paa.effective_start_date AND paa.effective_end_date
580: or
581: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
582: and paa.payroll_id = ppf.payroll_id

Line 581: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))

577: where paa.person_id between stperson AND endperson
578: and (fnd_date.canonical_to_date(l_benefit_end_date)
579: between paa.effective_start_date AND paa.effective_end_date
580: or
581: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
582: and paa.payroll_id = ppf.payroll_id
583: -- bug 7122883 added join condition with business_group_id
584: and ppf.business_group_id=l_business_group_id
585: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

Line 585: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

581: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
582: and paa.payroll_id = ppf.payroll_id
583: -- bug 7122883 added join condition with business_group_id
584: and ppf.business_group_id=l_business_group_id
585: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)
586: between ppf.effective_start_date and ppf.effective_end_date
587: and (l_payroll_id is null or ppf.payroll_id = l_payroll_id)
588: and (l_consolidation_set_id is null or ppf.consolidation_set_id = l_consolidation_set_id)
589: -- bug 7122883 removed the below join

Line 646: and (fnd_date.canonical_to_date(l_benefit_end_date)

642: pay_input_values_f piv,
643: pay_element_entries_f pee,
644: pay_element_entry_values_f peev
645: where paa.person_id between stperson AND endperson
646: and (fnd_date.canonical_to_date(l_benefit_end_date)
647: between paa.effective_start_date AND paa.effective_end_date
648: or
649: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
650: and paa.payroll_id = ppf.payroll_id

Line 649: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))

645: where paa.person_id between stperson AND endperson
646: and (fnd_date.canonical_to_date(l_benefit_end_date)
647: between paa.effective_start_date AND paa.effective_end_date
648: or
649: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
650: and paa.payroll_id = ppf.payroll_id
651: -- bug 7122883 added join condition with business_group_id
652: and ppf.business_group_id=l_business_group_id
653: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

Line 653: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

649: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
650: and paa.payroll_id = ppf.payroll_id
651: -- bug 7122883 added join condition with business_group_id
652: and ppf.business_group_id=l_business_group_id
653: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)
654: between ppf.effective_start_date and ppf.effective_end_date
655: and (l_payroll_id is null or ppf.payroll_id = l_payroll_id)
656: and (l_consolidation_set_id is null or ppf.consolidation_set_id = l_consolidation_set_id)
657: -- bug 7122883 removed the below join

Line 704: and (fnd_date.canonical_to_date(l_benefit_end_date)

700: pay_input_values_f piv,
701: pay_element_entries_f pee,
702: pay_element_entry_values_f peev
703: where paa.person_id between stperson AND endperson
704: and (fnd_date.canonical_to_date(l_benefit_end_date)
705: between paa.effective_start_date AND paa.effective_end_date
706: or
707: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
708: and paa.payroll_id = ppf.payroll_id

Line 707: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))

703: where paa.person_id between stperson AND endperson
704: and (fnd_date.canonical_to_date(l_benefit_end_date)
705: between paa.effective_start_date AND paa.effective_end_date
706: or
707: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
708: and paa.payroll_id = ppf.payroll_id
709: -- bug 7122883 added join condition with business_group_id
710: and ppf.business_group_id=l_business_group_id
711: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

Line 711: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)

707: paa.effective_end_date > fnd_date.canonical_to_date(l_benefit_start_date))
708: and paa.payroll_id = ppf.payroll_id
709: -- bug 7122883 added join condition with business_group_id
710: and ppf.business_group_id=l_business_group_id
711: and least(fnd_date.canonical_to_date(l_benefit_end_date),paa.effective_end_date)
712: between ppf.effective_start_date and ppf.effective_end_date
713: and (l_payroll_id is null or ppf.payroll_id = l_payroll_id)
714: and (l_consolidation_set_id is null or ppf.consolidation_set_id = l_consolidation_set_id)
715: -- bug 7122883 removed the below join

Line 771: fnd_date.date_to_canonical(start_date),

767: -- could not use the param parameters initialised in init procedure
768: -- as the action creation does not get called at all if i use them
769: select legislative_parameters,
770: business_group_id,
771: fnd_date.date_to_canonical(start_date),
772: fnd_date.date_to_canonical(effective_date)
773: into l_leg_param, l_business_group_id, l_benefit_start_date, l_benefit_end_date
774: from pay_payroll_actions
775: where payroll_action_id = pactid;

Line 772: fnd_date.date_to_canonical(effective_date)

768: -- as the action creation does not get called at all if i use them
769: select legislative_parameters,
770: business_group_id,
771: fnd_date.date_to_canonical(start_date),
772: fnd_date.date_to_canonical(effective_date)
773: into l_leg_param, l_business_group_id, l_benefit_start_date, l_benefit_end_date
774: from pay_payroll_actions
775: where payroll_action_id = pactid;
776:

Line 786: If fnd_date.canonical_to_date(l_benefit_start_date) <

782: l_rep_run := get_param_value('Rep_Run');
783: l_archive := TRUE;
784: -- Check to see if the conc program parameters are
785: -- correctly selected
786: If fnd_date.canonical_to_date(l_benefit_start_date) <
787: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
788: fnd_date.canonical_to_date(l_benefit_start_date) >
789: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
790: Then

Line 788: fnd_date.canonical_to_date(l_benefit_start_date) >

784: -- Check to see if the conc program parameters are
785: -- correctly selected
786: If fnd_date.canonical_to_date(l_benefit_start_date) <
787: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
788: fnd_date.canonical_to_date(l_benefit_start_date) >
789: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
790: Then
791: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
792: pay_core_utils.push_token('NAME', 'Benefit Start Date');

Line 804: If fnd_date.canonical_to_date(l_benefit_end_date) <

800: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
801: hr_utility.raise_error;
802: End if;
803:
804: If fnd_date.canonical_to_date(l_benefit_end_date) <
805: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
806: fnd_date.canonical_to_date(l_benefit_end_date) >
807: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
808: then

Line 806: fnd_date.canonical_to_date(l_benefit_end_date) >

802: End if;
803:
804: If fnd_date.canonical_to_date(l_benefit_end_date) <
805: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or
806: fnd_date.canonical_to_date(l_benefit_end_date) >
807: to_date('05-04-' ||l_rep_run,'dd-mm-yyyy')
808: then
809: pay_core_utils.push_message(800, 'HR_78076_P11D_DATE_PARAM_ERR', 'F');
810: pay_core_utils.push_token('NAME', 'Benefit End Date');

Line 1004: AND least(nvl(pps.ACTUAL_TERMINATION_DATE,fnd_date.canonical_to_date(g_param_benefit_end_date)),

1000: pay_all_payrolls_f pay,
1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id
1003: AND pps.PERIOD_OF_SERVICE_ID(+) = paa.PERIOD_OF_SERVICE_ID
1004: AND least(nvl(pps.ACTUAL_TERMINATION_DATE,fnd_date.canonical_to_date(g_param_benefit_end_date)),
1005: fnd_date.canonical_to_date(g_param_benefit_end_date))
1006: BETWEEN pap.effective_start_date AND pap.effective_end_date
1007: AND paa.assignment_id = p_assignment_id
1008: AND paa.payroll_id = pay.payroll_id

Line 1005: fnd_date.canonical_to_date(g_param_benefit_end_date))

1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id
1003: AND pps.PERIOD_OF_SERVICE_ID(+) = paa.PERIOD_OF_SERVICE_ID
1004: AND least(nvl(pps.ACTUAL_TERMINATION_DATE,fnd_date.canonical_to_date(g_param_benefit_end_date)),
1005: fnd_date.canonical_to_date(g_param_benefit_end_date))
1006: BETWEEN pap.effective_start_date AND pap.effective_end_date
1007: AND paa.assignment_id = p_assignment_id
1008: AND paa.payroll_id = pay.payroll_id
1009: AND least(fnd_date.canonical_to_date(g_param_benefit_end_date), paa.effective_end_date)

Line 1009: AND least(fnd_date.canonical_to_date(g_param_benefit_end_date), paa.effective_end_date)

1005: fnd_date.canonical_to_date(g_param_benefit_end_date))
1006: BETWEEN pap.effective_start_date AND pap.effective_end_date
1007: AND paa.assignment_id = p_assignment_id
1008: AND paa.payroll_id = pay.payroll_id
1009: AND least(fnd_date.canonical_to_date(g_param_benefit_end_date), paa.effective_end_date)
1010: between pay.effective_start_date and pay.effective_end_date
1011: AND pay.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
1012: AND (p_tax_ref is null
1013: OR

Line 1015: AND (fnd_date.canonical_to_date(g_param_benefit_end_date) between paa.effective_start_date AND paa.effective_end_date

1011: AND pay.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
1012: AND (p_tax_ref is null
1013: OR
1014: flex.segment1 = p_tax_ref)
1015: AND (fnd_date.canonical_to_date(g_param_benefit_end_date) between paa.effective_start_date AND paa.effective_end_date
1016: OR
1017: (
1018: paa.effective_end_date = (select max(paa2.effective_end_date)
1019: from per_assignments_f paa2

Line 1021: and paa.effective_end_date < fnd_date.canonical_to_date(g_param_benefit_end_date))

1017: (
1018: paa.effective_end_date = (select max(paa2.effective_end_date)
1019: from per_assignments_f paa2
1020: where paa2.assignment_id = p_assignment_id)
1021: and paa.effective_end_date < fnd_date.canonical_to_date(g_param_benefit_end_date))
1022: );
1023:
1024: CURSOR assignments_to_sum(p_person_id NUMBER, p_emp_ref VARCHAR2, p_emp_name VARCHAR2)
1025: IS

Line 1537: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1533: p_action_information_id => l_action_info_id,
1534: p_action_context_id => p_assactid,
1535: p_action_context_type => 'AAP',
1536: p_object_version_number => l_ovn,
1537: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1538: p_source_id => NULL,
1539: p_source_text => NULL,
1540: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1541: p_action_information1 => per_formula_functions.get_text('A_DESC'),

Line 1578: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1574: p_action_information_id => l_action_info_id,
1575: p_action_context_id => p_assactid,
1576: p_action_context_type => 'AAP',
1577: p_object_version_number => l_ovn,
1578: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1579: p_source_id => NULL,
1580: p_source_text => NULL,
1581: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1582: p_action_information1 => per_formula_functions.get_text('N_DESC'),

Line 1618: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1614: p_action_information_id => l_action_info_id,
1615: p_action_context_id => p_assactid,
1616: p_action_context_type => 'AAP',
1617: p_object_version_number => l_ovn,
1618: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1619: p_source_id => NULL,
1620: p_source_text => NULL,
1621: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1622: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),

Line 1653: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1649: p_action_information_id => l_action_info_id,
1650: p_action_context_id => p_assactid,
1651: p_action_context_type => 'AAP',
1652: p_object_version_number => l_ovn,
1653: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1654: p_source_id => NULL,
1655: p_source_text => NULL,
1656: p_action_information_category => 'GB P11D ASSIGNMENT RESULTA',
1657: p_action_information1 => per_formula_functions.get_text('A_DESC'),

Line 1695: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1691: p_action_information_id => l_action_info_id,
1692: p_action_context_id => p_assactid,
1693: p_action_context_type => 'AAP',
1694: p_object_version_number => l_ovn,
1695: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1696: p_source_id => NULL,
1697: p_source_text => NULL,
1698: p_action_information_category => 'GB P11D ASSIGNMENT RESULTB',
1699: p_action_information1 => per_formula_functions.get_text('M_DESC'),

Line 1736: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

1732: p_action_information_id => l_action_info_id,
1733: p_action_context_id => p_assactid,
1734: p_action_context_type => 'AAP',
1735: p_object_version_number => l_ovn,
1736: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
1737: p_source_id => NULL,
1738: p_source_text => NULL,
1739: p_action_information_category => 'GB P11D ASSIGNMENT RESULTC',
1740: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),

Line 2663: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2659: and paf.assignment_id = p_assid
2660: and paf.period_of_service_id = pps.period_of_service_id(+)
2661: and p_eff_date between paf.effective_start_date and paf.effective_end_date
2662: and least(nvl(pps.actual_termination_date,
2663: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2664: fnd_date.canonical_to_date(g_param_benefit_end_date))
2665: between ppf.effective_start_date and ppf.effective_end_date;
2666: begin
2667: open csr_ni;

Line 2664: fnd_date.canonical_to_date(g_param_benefit_end_date))

2660: and paf.period_of_service_id = pps.period_of_service_id(+)
2661: and p_eff_date between paf.effective_start_date and paf.effective_end_date
2662: and least(nvl(pps.actual_termination_date,
2663: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2664: fnd_date.canonical_to_date(g_param_benefit_end_date))
2665: between ppf.effective_start_date and ppf.effective_end_date;
2666: begin
2667: open csr_ni;
2668: fetch csr_ni into l_nat_number;

Line 2944: open csr_get_global('P11D_LOW_INT_LOAN_THRESHOLD', fnd_date.canonical_to_date(g_param_benefit_end_date));

2940: open csr_get_asg_end_date(l_assignment_id);
2941: fetch csr_get_asg_end_date into l_asg_max_end_date;
2942: close csr_get_asg_end_date;
2943:
2944: open csr_get_global('P11D_LOW_INT_LOAN_THRESHOLD', fnd_date.canonical_to_date(g_param_benefit_end_date));
2945: fetch csr_get_global into l_loan_threshold;
2946: close csr_get_global;
2947: -- default the value to 5000 for archive prior to 2006
2948: if l_loan_threshold is null then

Line 2972: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2968: p_assignment_id => l_assignment_id, -- current assignment_id
2969: p_curr_pymt_ass_act_id => NULL, -- prepayment assignment_action_id
2970: p_curr_eff_date => least(
2971: nvl(l_actual_termination_date,
2972: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2973: fnd_date.canonical_to_date(g_param_benefit_end_date)
2974: ), -- archive effective_date
2975: p_date_earned => least(
2976: nvl(l_actual_termination_date,

Line 2973: fnd_date.canonical_to_date(g_param_benefit_end_date)

2969: p_curr_pymt_ass_act_id => NULL, -- prepayment assignment_action_id
2970: p_curr_eff_date => least(
2971: nvl(l_actual_termination_date,
2972: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2973: fnd_date.canonical_to_date(g_param_benefit_end_date)
2974: ), -- archive effective_date
2975: p_date_earned => least(
2976: nvl(l_actual_termination_date,
2977: fnd_date.canonical_to_date(g_param_benefit_end_date)),

Line 2977: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2973: fnd_date.canonical_to_date(g_param_benefit_end_date)
2974: ), -- archive effective_date
2975: p_date_earned => least(
2976: nvl(l_actual_termination_date,
2977: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2978: fnd_date.canonical_to_date(g_param_benefit_end_date)
2979: ), -- payroll date_earned
2980: p_curr_pymt_eff_date => least(
2981: nvl(l_actual_termination_date,

Line 2978: fnd_date.canonical_to_date(g_param_benefit_end_date)

2974: ), -- archive effective_date
2975: p_date_earned => least(
2976: nvl(l_actual_termination_date,
2977: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2978: fnd_date.canonical_to_date(g_param_benefit_end_date)
2979: ), -- payroll date_earned
2980: p_curr_pymt_eff_date => least(
2981: nvl(l_actual_termination_date,
2982: fnd_date.canonical_to_date(g_param_benefit_end_date)),

Line 2982: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2978: fnd_date.canonical_to_date(g_param_benefit_end_date)
2979: ), -- payroll date_earned
2980: p_curr_pymt_eff_date => least(
2981: nvl(l_actual_termination_date,
2982: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2983: fnd_date.canonical_to_date(g_param_benefit_end_date)
2984: ), -- prepayment effective_date
2985: p_tax_unit_id => NULL, -- only required for US
2986: p_time_period_id => NULL, -- payroll time_period_id

Line 2983: fnd_date.canonical_to_date(g_param_benefit_end_date)

2979: ), -- payroll date_earned
2980: p_curr_pymt_eff_date => least(
2981: nvl(l_actual_termination_date,
2982: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2983: fnd_date.canonical_to_date(g_param_benefit_end_date)
2984: ), -- prepayment effective_date
2985: p_tax_unit_id => NULL, -- only required for US
2986: p_time_period_id => NULL, -- payroll time_period_id
2987: p_ppp_source_action_id => NULL);

Line 2995: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2991: validate_ni(
2992: p_assactid => p_assactid,
2993: p_assid => l_assignment_id,
2994: p_eff_date => least(nvl(l_actual_termination_date,
2995: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2996: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2997:
2998: hr_utility.set_location('Returned from NI Validation',30);
2999: open csr_assignment_det(l_assignment_id, g_param_tax_reference);

Line 2996: fnd_date.canonical_to_date(g_param_benefit_end_date)));

2992: p_assactid => p_assactid,
2993: p_assid => l_assignment_id,
2994: p_eff_date => least(nvl(l_actual_termination_date,
2995: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2996: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2997:
2998: hr_utility.set_location('Returned from NI Validation',30);
2999: open csr_assignment_det(l_assignment_id, g_param_tax_reference);
3000: fetch csr_assignment_det into

Line 3060: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

3056: p_action_information_id => l_action_info_id,
3057: p_action_context_id => p_assactid,
3058: p_action_context_type => 'AAP',
3059: p_object_version_number => l_ovn,
3060: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3061: p_source_id => NULL,
3062: p_source_text => NULL,
3063: p_action_information_category => 'EMEA PAYROLL INFO',
3064: p_action_information1 => g_pactid,

Line 3131: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

3127: p_action_information_id => l_action_info_id,
3128: p_action_context_id => p_assactid,
3129: p_action_context_type => 'AAP',
3130: p_object_version_number => l_ovn,
3131: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3132: p_source_id => NULL,
3133: p_source_text => NULL,
3134: p_action_information_category => 'GB EMPLOYEE DETAILS',
3135: p_action_information1 => NULL,

Line 3148: p_action_information15 => fnd_date.date_to_canonical(l_date_of_birth),

3144: p_action_information10 => l_person_id,
3145: p_action_information11 => l_assignment_number,
3146: p_action_information12 => l_ni_number,
3147: p_action_information13 => l_pay_info_tab(l_payroll_id).l_employers_ref_no,
3148: p_action_information15 => fnd_date.date_to_canonical(l_date_of_birth),
3149: p_action_information17 => l_sex);
3150:
3151: check_assignment_latest_info(
3152: p_assignment_id => l_assignment_id,

Line 3154: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

3150:
3151: check_assignment_latest_info(
3152: p_assignment_id => l_assignment_id,
3153: p_assignment_act_id => p_assactid,
3154: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3155: p_asg_end_date => least(nvl(l_actual_termination_date,
3156: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3157: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3158: validate_employee_address(p_assignment_action_id => p_assactid,

Line 3156: fnd_date.canonical_to_date(g_param_benefit_end_date)),

3152: p_assignment_id => l_assignment_id,
3153: p_assignment_act_id => p_assactid,
3154: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3155: p_asg_end_date => least(nvl(l_actual_termination_date,
3156: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3157: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3158: validate_employee_address(p_assignment_action_id => p_assactid,
3159: p_assignment_name => l_assignment_name,
3160: p_assignment_number => l_assignment_number);

Line 3157: fnd_date.canonical_to_date(g_param_benefit_end_date)));

3153: p_assignment_act_id => p_assactid,
3154: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3155: p_asg_end_date => least(nvl(l_actual_termination_date,
3156: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3157: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3158: validate_employee_address(p_assignment_action_id => p_assactid,
3159: p_assignment_name => l_assignment_name,
3160: p_assignment_number => l_assignment_number);
3161: END IF;

Line 3207: If fnd_date.canonical_to_date(l_benefit_start_date) <

3203: END IF;
3204: END LOOP;
3205:
3206: -- check if the ben st and ben end falls within the tax year
3207: If fnd_date.canonical_to_date(l_benefit_start_date) <
3208: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3209: fnd_date.canonical_to_date(l_benefit_start_date) >
3210: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3211: Then

Line 3209: fnd_date.canonical_to_date(l_benefit_start_date) >

3205:
3206: -- check if the ben st and ben end falls within the tax year
3207: If fnd_date.canonical_to_date(l_benefit_start_date) <
3208: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3209: fnd_date.canonical_to_date(l_benefit_start_date) >
3210: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3211: Then
3212: l_error_assignment := TRUE;
3213: l_error := '1';

Line 3221: If fnd_date.canonical_to_date(l_benefit_end_date) <

3217: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3218: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3219: End if;
3220:
3221: If fnd_date.canonical_to_date(l_benefit_end_date) <
3222: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3223: fnd_date.canonical_to_date(l_benefit_end_date) >
3224: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3225: then

Line 3223: fnd_date.canonical_to_date(l_benefit_end_date) >

3219: End if;
3220:
3221: If fnd_date.canonical_to_date(l_benefit_end_date) <
3222: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3223: fnd_date.canonical_to_date(l_benefit_end_date) >
3224: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3225: then
3226: l_error_assignment := TRUE;
3227: l_error := '1';

Line 3287: fnd_date.canonical_to_date(l_benefit_end_date),

3283: -- fetching the formula id the ff table is cached in memory and is
3284: -- referenced here
3285: l_formula_id := find_exec_formula(
3286: l_element_name,
3287: fnd_date.canonical_to_date(l_benefit_end_date),
3288: l_formula_effective_start_date);
3289: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3290:
3291: IF l_formula_id IS NOT NULL

Line 3640: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),

3636: p_action_context_type => 'AAP',
3637: p_object_version_number => l_ovn,
3638: p_source_id => NULL,
3639: p_source_text => NULL,
3640: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3641: p_action_information_category => SUBSTR(UPPER(l_element_name), 1, 30),
3642: p_action_information1 => g_tab_ben_detail(l_index).element_entry_id,
3643: p_action_information2 => g_tab_ben_detail(l_index).effective_start_date,
3644: p_action_information3 => l_col3_val,