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_IP_EMPLOYEE_BALANCES dependencies on PAY_IP_ROUTE_SUPPORT

Line 60: 6) Made use of pay_ip_route_support to correctly

56: pattern.
57: 5) Modified the Assignment
58: validation code in the function
59: validate_assignment.
60: 6) Made use of pay_ip_route_support to correctly
61: fetch the tax_year and tax_quarter.
62: 03-Apr-2012 vvijayku 120.4 13902938 Changed the code that fetches the l_pay_start_date
63: to make use of the beginning of Tax Year instead
64: of the beginning of the Calendar Year.

Line 68: the use of Tax Year using pay_ip_route_support.tax_year

64: of the beginning of the Calendar Year.
65: 06-Apr-2012 vvijayku 120.5 13902938 Removed all the occurrences of per_all_assignments_f
66: and replaced it with per_assignments_f. Replaced the
67: use of trunc(p_session_date,'YYYY') to
68: the use of Tax Year using pay_ip_route_support.tax_year
69: function.
70: ********************************************************************************************/
71:
72: /*******************************************************************************************

Line 273: AND paf.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,to_date(p_effective_date,'YYYY-MM-DD'))

269: INTO l_valid_asg
270: FROM per_assignments_f paf
271: WHERE paf.assignment_id = p_assignment_id
272: AND paf.effective_start_date <= to_date(p_effective_date,'YYYY-MM-DD')
273: AND paf.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,to_date(p_effective_date,'YYYY-MM-DD'))
274: AND rownum=1;
275:
276: RETURN l_valid_asg;
277:

Line 887: and greater than pay_ip_route_support.tax_year(p_business_group_id,p_session_date)

883: WHEN NO_DATA_FOUND THEN
884: BEGIN
885: IF p_tax_unit_id <> -1 THEN
886: /* Attempt to find an assignment id for the person with end date < p_session_date
887: and greater than pay_ip_route_support.tax_year(p_business_group_id,p_session_date)
888: when the localization is based on Tax Unit Id architecture.
889: */
890: hr_utility.set_location(l_package||l_function, 60);
891: SELECT paf2.assignment_id

Line 901: AND paf2.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,p_session_date)

897: AND paf2.person_id = paf1.person_id
898: AND paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
899: AND hsk.segment1 = to_char(p_tax_unit_id)
900: AND paf2.effective_end_date < p_session_date
901: AND paf2.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,p_session_date)
902: AND paf2.effective_end_date =
903: (SELECT MAX(paf3.effective_end_date)
904: FROM per_assignments_f paf3
905: WHERE paf3.person_id = paf1.person_id

Line 911: and greater than pay_ip_route_support.tax_year(p_business_group_id,p_session_date)

907: )
908: AND rownum=1;
909: ELSE
910: /* Attempt to find an assignment id for the person with end date < p_session_date
911: and greater than pay_ip_route_support.tax_year(p_business_group_id,p_session_date)
912: when the localization is not based on Tax Unit Id architecture.
913: */
914: SELECT paf2.assignment_id
915: INTO l_temp_assignment_id

Line 922: AND paf2.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,p_session_date)

918: WHERE paf1.assignment_id = p_assignment_id
919: AND paf2.person_id = paf1.person_id
920: AND paf2.business_group_id = p_business_group_id
921: AND paf2.effective_end_date < p_session_date
922: AND paf2.effective_end_date >= pay_ip_route_support.tax_year(p_business_group_id,p_session_date)
923: AND paf2.effective_end_date =
924: (SELECT MAX(paf3.effective_end_date)
925: FROM per_assignments_f paf3
926: WHERE paf3.person_id = paf1.person_id

Line 966: ELSIF l_date < pay_ip_route_support.tax_year(p_business_group_id,p_session_date) THEN

962: IF l_date IS NULL THEN
963: l_date := p_session_date; -- Current Employee
964: ELSIF l_date >= p_session_date THEN
965: l_date := p_session_date; -- Current Employee
966: ELSIF l_date < pay_ip_route_support.tax_year(p_business_group_id,p_session_date) THEN
967: -- Assignment terminated before this year so no balances for this year
968: l_date := to_date('31-12-4712','DD-MM-YYYY');
969: ELSIF l_date < trunc(p_session_date, 'MONTH') THEN
970: -- Assignment terminated this year but before this month

Line 971: IF l_date >= pay_ip_route_support.tax_quarter(p_business_group_id,p_session_date) THEN

967: -- Assignment terminated before this year so no balances for this year
968: l_date := to_date('31-12-4712','DD-MM-YYYY');
969: ELSIF l_date < trunc(p_session_date, 'MONTH') THEN
970: -- Assignment terminated this year but before this month
971: IF l_date >= pay_ip_route_support.tax_quarter(p_business_group_id,p_session_date) THEN
972: -- Assignment terminated this quarter, show QTD and YTD balances
973: IF l_ytd_id = p_defbal_id OR l_qtd_id = p_defbal_id THEN
974: l_date := l_last_process_date;
975: ELSE

Line 1469: AND ptp.regular_payment_date >= pay_ip_route_support.tax_year(p_business_group_id,nvl(l_action_date, p_session_date));

1465: FROM per_assignments_f paf,
1466: per_time_periods ptp
1467: WHERE paf.assignment_id = p_assignment_id
1468: AND ptp.payroll_id = paf.payroll_id
1469: AND ptp.regular_payment_date >= pay_ip_route_support.tax_year(p_business_group_id,nvl(l_action_date, p_session_date));
1470:
1471: hr_utility.trace('l_action_date: '||to_char(l_action_date));
1472: hr_utility.trace('l_pay_start_date: '||to_char(l_pay_start_date));
1473: