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 703: and (fnd_date.canonical_to_date(l_benefit_end_date)

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

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

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

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

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

Line 770: fnd_date.date_to_canonical(start_date),

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

Line 771: fnd_date.date_to_canonical(effective_date)

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

Line 785: If fnd_date.canonical_to_date(l_benefit_start_date) <

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

Line 787: fnd_date.canonical_to_date(l_benefit_start_date) >

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

Line 803: If fnd_date.canonical_to_date(l_benefit_end_date) <

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

Line 805: fnd_date.canonical_to_date(l_benefit_end_date) >

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

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

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

Line 1004: fnd_date.canonical_to_date(g_param_benefit_end_date))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2597: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2593: and paf.assignment_id = p_assid
2594: and paf.period_of_service_id = pps.period_of_service_id(+)
2595: and p_eff_date between paf.effective_start_date and paf.effective_end_date
2596: and least(nvl(pps.actual_termination_date,
2597: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2598: fnd_date.canonical_to_date(g_param_benefit_end_date))
2599: between ppf.effective_start_date and ppf.effective_end_date;
2600: begin
2601: open csr_ni;

Line 2598: fnd_date.canonical_to_date(g_param_benefit_end_date))

2594: and paf.period_of_service_id = pps.period_of_service_id(+)
2595: and p_eff_date between paf.effective_start_date and paf.effective_end_date
2596: and least(nvl(pps.actual_termination_date,
2597: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2598: fnd_date.canonical_to_date(g_param_benefit_end_date))
2599: between ppf.effective_start_date and ppf.effective_end_date;
2600: begin
2601: open csr_ni;
2602: fetch csr_ni into l_nat_number;

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

2874: open csr_get_asg_end_date(l_assignment_id);
2875: fetch csr_get_asg_end_date into l_asg_max_end_date;
2876: close csr_get_asg_end_date;
2877:
2878: open csr_get_global('P11D_LOW_INT_LOAN_THRESHOLD', fnd_date.canonical_to_date(g_param_benefit_end_date));
2879: fetch csr_get_global into l_loan_threshold;
2880: close csr_get_global;
2881: -- default the value to 5000 for archive prior to 2006
2882: if l_loan_threshold is null then

Line 2906: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2902: p_assignment_id => l_assignment_id, -- current assignment_id
2903: p_curr_pymt_ass_act_id => NULL, -- prepayment assignment_action_id
2904: p_curr_eff_date => least(
2905: nvl(l_actual_termination_date,
2906: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2907: fnd_date.canonical_to_date(g_param_benefit_end_date)
2908: ), -- archive effective_date
2909: p_date_earned => least(
2910: nvl(l_actual_termination_date,

Line 2907: fnd_date.canonical_to_date(g_param_benefit_end_date)

2903: p_curr_pymt_ass_act_id => NULL, -- prepayment assignment_action_id
2904: p_curr_eff_date => least(
2905: nvl(l_actual_termination_date,
2906: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2907: fnd_date.canonical_to_date(g_param_benefit_end_date)
2908: ), -- archive effective_date
2909: p_date_earned => least(
2910: nvl(l_actual_termination_date,
2911: fnd_date.canonical_to_date(g_param_benefit_end_date)),

Line 2911: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2907: fnd_date.canonical_to_date(g_param_benefit_end_date)
2908: ), -- archive effective_date
2909: p_date_earned => least(
2910: nvl(l_actual_termination_date,
2911: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2912: fnd_date.canonical_to_date(g_param_benefit_end_date)
2913: ), -- payroll date_earned
2914: p_curr_pymt_eff_date => least(
2915: nvl(l_actual_termination_date,

Line 2912: fnd_date.canonical_to_date(g_param_benefit_end_date)

2908: ), -- archive effective_date
2909: p_date_earned => least(
2910: nvl(l_actual_termination_date,
2911: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2912: fnd_date.canonical_to_date(g_param_benefit_end_date)
2913: ), -- payroll date_earned
2914: p_curr_pymt_eff_date => least(
2915: nvl(l_actual_termination_date,
2916: fnd_date.canonical_to_date(g_param_benefit_end_date)),

Line 2916: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2912: fnd_date.canonical_to_date(g_param_benefit_end_date)
2913: ), -- payroll date_earned
2914: p_curr_pymt_eff_date => least(
2915: nvl(l_actual_termination_date,
2916: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2917: fnd_date.canonical_to_date(g_param_benefit_end_date)
2918: ), -- prepayment effective_date
2919: p_tax_unit_id => NULL, -- only required for US
2920: p_time_period_id => NULL, -- payroll time_period_id

Line 2917: fnd_date.canonical_to_date(g_param_benefit_end_date)

2913: ), -- payroll date_earned
2914: p_curr_pymt_eff_date => least(
2915: nvl(l_actual_termination_date,
2916: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2917: fnd_date.canonical_to_date(g_param_benefit_end_date)
2918: ), -- prepayment effective_date
2919: p_tax_unit_id => NULL, -- only required for US
2920: p_time_period_id => NULL, -- payroll time_period_id
2921: p_ppp_source_action_id => NULL);

Line 2929: fnd_date.canonical_to_date(g_param_benefit_end_date)),

2925: validate_ni(
2926: p_assactid => p_assactid,
2927: p_assid => l_assignment_id,
2928: p_eff_date => least(nvl(l_actual_termination_date,
2929: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2930: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2931:
2932: hr_utility.set_location('Returned from NI Validation',30);
2933: open csr_assignment_det(l_assignment_id, g_param_tax_reference);

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

2926: p_assactid => p_assactid,
2927: p_assid => l_assignment_id,
2928: p_eff_date => least(nvl(l_actual_termination_date,
2929: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2930: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2931:
2932: hr_utility.set_location('Returned from NI Validation',30);
2933: open csr_assignment_det(l_assignment_id, g_param_tax_reference);
2934: fetch csr_assignment_det into

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

2990: p_action_information_id => l_action_info_id,
2991: p_action_context_id => p_assactid,
2992: p_action_context_type => 'AAP',
2993: p_object_version_number => l_ovn,
2994: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
2995: p_source_id => NULL,
2996: p_source_text => NULL,
2997: p_action_information_category => 'EMEA PAYROLL INFO',
2998: p_action_information1 => g_pactid,

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

3061: p_action_information_id => l_action_info_id,
3062: p_action_context_id => p_assactid,
3063: p_action_context_type => 'AAP',
3064: p_object_version_number => l_ovn,
3065: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3066: p_source_id => NULL,
3067: p_source_text => NULL,
3068: p_action_information_category => 'GB EMPLOYEE DETAILS',
3069: p_action_information1 => NULL,

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

3078: p_action_information10 => l_person_id,
3079: p_action_information11 => l_assignment_number,
3080: p_action_information12 => l_ni_number,
3081: p_action_information13 => l_pay_info_tab(l_payroll_id).l_employers_ref_no,
3082: p_action_information15 => fnd_date.date_to_canonical(l_date_of_birth),
3083: p_action_information17 => l_sex);
3084:
3085: check_assignment_latest_info(
3086: p_assignment_id => l_assignment_id,

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

3084:
3085: check_assignment_latest_info(
3086: p_assignment_id => l_assignment_id,
3087: p_assignment_act_id => p_assactid,
3088: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3089: p_asg_end_date => least(nvl(l_actual_termination_date,
3090: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3091: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3092: validate_employee_address(p_assignment_action_id => p_assactid,

Line 3090: fnd_date.canonical_to_date(g_param_benefit_end_date)),

3086: p_assignment_id => l_assignment_id,
3087: p_assignment_act_id => p_assactid,
3088: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3089: p_asg_end_date => least(nvl(l_actual_termination_date,
3090: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3091: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3092: validate_employee_address(p_assignment_action_id => p_assactid,
3093: p_assignment_name => l_assignment_name,
3094: p_assignment_number => l_assignment_number);

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

3087: p_assignment_act_id => p_assactid,
3088: p_ben_end_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3089: p_asg_end_date => least(nvl(l_actual_termination_date,
3090: fnd_date.canonical_to_date(g_param_benefit_end_date)),
3091: fnd_date.canonical_to_date(g_param_benefit_end_date)));
3092: validate_employee_address(p_assignment_action_id => p_assactid,
3093: p_assignment_name => l_assignment_name,
3094: p_assignment_number => l_assignment_number);
3095: END IF;

Line 3141: If fnd_date.canonical_to_date(l_benefit_start_date) <

3137: END IF;
3138: END LOOP;
3139:
3140: -- check if the ben st and ben end falls within the tax year
3141: If fnd_date.canonical_to_date(l_benefit_start_date) <
3142: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3143: fnd_date.canonical_to_date(l_benefit_start_date) >
3144: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3145: Then

Line 3143: fnd_date.canonical_to_date(l_benefit_start_date) >

3139:
3140: -- check if the ben st and ben end falls within the tax year
3141: If fnd_date.canonical_to_date(l_benefit_start_date) <
3142: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3143: fnd_date.canonical_to_date(l_benefit_start_date) >
3144: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3145: Then
3146: l_error_assignment := TRUE;
3147: l_error := '1';

Line 3155: If fnd_date.canonical_to_date(l_benefit_end_date) <

3151: pay_core_utils.push_token('VAl1','06-APR-' ||to_char(to_number(g_param_rep_run)-1));
3152: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3153: End if;
3154:
3155: If fnd_date.canonical_to_date(l_benefit_end_date) <
3156: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3157: fnd_date.canonical_to_date(l_benefit_end_date) >
3158: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3159: then

Line 3157: fnd_date.canonical_to_date(l_benefit_end_date) >

3153: End if;
3154:
3155: If fnd_date.canonical_to_date(l_benefit_end_date) <
3156: to_date('06-04-' ||to_char(to_number(g_param_rep_run)-1),'dd-mm-yyyy') or
3157: fnd_date.canonical_to_date(l_benefit_end_date) >
3158: to_date('05-04-' ||g_param_rep_run,'dd-mm-yyyy')
3159: then
3160: l_error_assignment := TRUE;
3161: l_error := '1';

Line 3221: fnd_date.canonical_to_date(l_benefit_end_date),

3217: -- fetching the formula id the ff table is cached in memory and is
3218: -- referenced here
3219: l_formula_id := find_exec_formula(
3220: l_element_name,
3221: fnd_date.canonical_to_date(l_benefit_end_date),
3222: l_formula_effective_start_date);
3223: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3224:
3225: IF l_formula_id IS NOT NULL

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

3570: p_action_context_type => 'AAP',
3571: p_object_version_number => l_ovn,
3572: p_source_id => NULL,
3573: p_source_text => NULL,
3574: p_effective_date => fnd_date.canonical_to_date(g_param_benefit_end_date),
3575: p_action_information_category => SUBSTR(UPPER(l_element_name), 1, 30),
3576: p_action_information1 => g_tab_ben_detail(l_index).element_entry_id,
3577: p_action_information2 => g_tab_ben_detail(l_index).effective_start_date,
3578: p_action_information3 => l_col3_val,