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 PER_ASSIGNMENTS_F

Line 66: and replaced it with per_assignments_f. Replaced the

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.
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: ********************************************************************************************/

Line 270: FROM per_assignments_f paf

266: hr_utility.set_location(l_package||l_function, 10);
267:
268: SELECT 'Y'
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;

Line 799: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;

795: l_date DATE;
796: l_ytd_id number(9);
797: l_qtd_id number(9);
798: l_mtd_id number(9);
799: l_temp_assignment_id per_assignments_f.assignment_id%TYPE;
800: l_function varchar2(9);
801: l_value number := NULL;
802:
803: BEGIN

Line 821: FROM per_assignments_f paf,

817: when the localization is based on Tax Unit Id architecture.
818: */
819: SELECT paf.assignment_id
820: INTO l_temp_assignment_id
821: FROM per_assignments_f paf,
822: hr_soft_coding_keyflex hsk
823: WHERE paf.assignment_id = p_assignment_id
824: AND paf.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id
825: AND p_session_date BETWEEN paf.effective_start_date

Line 835: FROM per_assignments_f paf

831: when the localization is not based on Tax Unit Id architecture.
832: */
833: SELECT paf.assignment_id
834: INTO l_temp_assignment_id
835: FROM per_assignments_f paf
836: WHERE paf.assignment_id = p_assignment_id
837: AND paf.business_group_id = p_business_group_id
838: AND p_session_date BETWEEN paf.effective_start_date
839: AND paf.effective_end_date;

Line 856: FROM per_assignments_f paf1,

852: hr_utility.set_location(l_package||l_function, 40);
853:
854: SELECT paf2.assignment_id
855: INTO l_temp_assignment_id
856: FROM per_assignments_f paf1,
857: per_assignments_f paf2,
858: hr_soft_coding_keyflex hsk
859: WHERE paf1.assignment_id = p_assignment_id
860: AND paf2.person_id = paf1.person_id

Line 857: per_assignments_f paf2,

853:
854: SELECT paf2.assignment_id
855: INTO l_temp_assignment_id
856: FROM per_assignments_f paf1,
857: per_assignments_f paf2,
858: hr_soft_coding_keyflex hsk
859: WHERE paf1.assignment_id = p_assignment_id
860: AND paf2.person_id = paf1.person_id
861: AND paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 872: FROM per_assignments_f paf1,

868: when the localization is not based on the Tax Unit Id architecture.
869: */
870: SELECT paf2.assignment_id
871: INTO l_temp_assignment_id
872: FROM per_assignments_f paf1,
873: per_assignments_f paf2
874: WHERE paf1.assignment_id = p_assignment_id
875: AND paf2.person_id = paf1.person_id
876: AND paf2.business_group_id = p_business_group_id

Line 873: per_assignments_f paf2

869: */
870: SELECT paf2.assignment_id
871: INTO l_temp_assignment_id
872: FROM per_assignments_f paf1,
873: per_assignments_f paf2
874: WHERE paf1.assignment_id = p_assignment_id
875: AND paf2.person_id = paf1.person_id
876: AND paf2.business_group_id = p_business_group_id
877: AND p_session_date BETWEEN paf2.effective_start_date

Line 893: FROM per_assignments_f paf1,

889: */
890: hr_utility.set_location(l_package||l_function, 60);
891: SELECT paf2.assignment_id
892: INTO l_temp_assignment_id
893: FROM per_assignments_f paf1,
894: per_assignments_f paf2,
895: hr_soft_coding_keyflex hsk
896: WHERE paf1.assignment_id = p_assignment_id
897: AND paf2.person_id = paf1.person_id

Line 894: per_assignments_f paf2,

890: hr_utility.set_location(l_package||l_function, 60);
891: SELECT paf2.assignment_id
892: INTO l_temp_assignment_id
893: FROM per_assignments_f paf1,
894: per_assignments_f paf2,
895: hr_soft_coding_keyflex hsk
896: WHERE paf1.assignment_id = p_assignment_id
897: AND paf2.person_id = paf1.person_id
898: AND paf2.soft_coding_keyflex_id = hsk.soft_coding_keyflex_id

Line 904: FROM per_assignments_f paf3

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
906: AND paf3.effective_end_date < p_session_date
907: )
908: AND rownum=1;

Line 916: FROM per_assignments_f paf1,

912: when the localization is not based on Tax Unit Id architecture.
913: */
914: SELECT paf2.assignment_id
915: INTO l_temp_assignment_id
916: FROM per_assignments_f paf1,
917: per_assignments_f paf2
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

Line 917: per_assignments_f paf2

913: */
914: SELECT paf2.assignment_id
915: INTO l_temp_assignment_id
916: FROM per_assignments_f paf1,
917: per_assignments_f paf2
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

Line 925: FROM per_assignments_f paf3

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
927: AND paf3.effective_end_date < p_session_date
928: )
929: AND rownum=1;

Line 1465: FROM per_assignments_f paf,

1461: l_action_date := payvwele.get_action_date(p_assignment_action_id);
1462:
1463: SELECT MIN(ptp.start_date) first_period_start_date
1464: INTO l_pay_start_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));