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

Line 200: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');

196: WHERE session_id = USERENV('sessionid');
197:
198: pay_in_utils.set_location(g_debug,l_procedure, 20);
199:
200: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
201: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
202:
203: g_start_date := ADD_MONTHS(g_start_date,-12);
204: g_end_date := ADD_MONTHS(g_end_date,-12);

Line 201: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');

197:
198: pay_in_utils.set_location(g_debug,l_procedure, 20);
199:
200: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
201: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
202:
203: g_start_date := ADD_MONTHS(g_start_date,-12);
204: g_end_date := ADD_MONTHS(g_end_date,-12);
205:

Line 250: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

246: IS
247: --This cursor determines termination date of an assignment.
248: CURSOR c_termination_check
249: IS
250: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
251: FROM per_all_assignments_f asg
252: ,per_periods_of_service pos
253: WHERE asg.person_id = pos.person_id
254: AND asg.assignment_id = p_assignment_id

Line 484: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');

480: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
481: INTO g_bg_id
482: FROM dual;
483:
484: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
485: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
486:
487: g_start_date := ADD_MONTHS(g_start_date,-12);
488: g_end_date := ADD_MONTHS(g_end_date,-12);

Line 485: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');

481: INTO g_bg_id
482: FROM dual;
483:
484: g_start_date := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
485: g_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
486:
487: g_start_date := ADD_MONTHS(g_start_date,-12);
488: g_end_date := ADD_MONTHS(g_end_date,-12);
489:

Line 576: ,fnd_date.date_to_canonical(pep.date_of_birth) dob

572: ,DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
573: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
574: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
575: ,pep.title title
576: ,fnd_date.date_to_canonical(pep.date_of_birth) dob
577: ,pep.sex gender
578: ,pep.per_information7 residential_status
579: ,pep.email_address emailAddr
580: FROM per_all_assignments_f asg

Line 722: l_effective_end_date := fnd_date.string_to_date('31-MAR-' || TO_CHAR(add_months(p_effective_start_date,12),'YYYY'),'DD-MM-YYYY');

718: --
719: -- Bug 4621622 : Added this code to handle termination case
720: --
721: IF p_effective_start_date > p_effective_end_date THEN
722: l_effective_end_date := fnd_date.string_to_date('31-MAR-' || TO_CHAR(add_months(p_effective_start_date,12),'YYYY'),'DD-MM-YYYY');
723: ELSE
724: l_effective_end_date := p_effective_end_date;
725: END IF;
726: --

Line 2525: AND p_effective_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

2521: AND hou.business_group_id = g_bg_id
2522: AND pep.person_id = hoi.org_information1
2523: AND pep.business_group_id = hou.business_group_id
2524: AND p_effective_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2525: AND p_effective_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2526: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2527: AND p_effective_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2528:
2529: CURSOR c_rep_address(p_person_id NUMBER)

Line 2526: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))

2522: AND pep.person_id = hoi.org_information1
2523: AND pep.business_group_id = hou.business_group_id
2524: AND p_effective_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2525: AND p_effective_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2526: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2527: AND p_effective_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2528:
2529: CURSOR c_rep_address(p_person_id NUMBER)
2530: IS

Line 2819: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

2815:
2816: --This cursor determines termination date of an assignment.
2817: CURSOR c_termination_check(p_assignment_id NUMBER)
2818: IS
2819: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2820: FROM per_all_assignments_f asg
2821: ,per_periods_of_service pos
2822: WHERE asg.person_id = pos.person_id
2823: AND asg.assignment_id = p_assignment_id

Line 3001: ,p_payroll_run_date => fnd_date.date_to_canonical(l_run_date_earned)

2997: ,p_arc_payroll_act_id => l_arc_pay_action_id
2998: ,p_prepayment_date => l_pre_effective_date
2999: ,p_assignment_id => l_assignment_id
3000: ,p_gre_id => g_asg_tab(i).gre_id
3001: ,p_payroll_run_date => fnd_date.date_to_canonical(l_run_date_earned)
3002: ,p_effective_start_date => g_asg_tab(i).start_date
3003: ,p_effective_end_date => LEAST(g_asg_tab(i).end_date,l_end_date)
3004: );
3005: pay_in_utils.set_location(g_debug,l_procedure, 110);