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: FROM per_all_assignments_f asg
580: ,hr_soft_coding_keyflex scl

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

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

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

2455: AND hou.business_group_id = g_bg_id
2456: AND pep.person_id = hoi.org_information1
2457: AND pep.business_group_id = hou.business_group_id
2458: AND p_effective_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2459: AND p_effective_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2460: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2461: AND p_effective_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2462:
2463: CURSOR c_rep_address(p_person_id NUMBER)

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

2456: AND pep.person_id = hoi.org_information1
2457: AND pep.business_group_id = hou.business_group_id
2458: AND p_effective_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2459: AND p_effective_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2460: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2461: AND p_effective_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2462:
2463: CURSOR c_rep_address(p_person_id NUMBER)
2464: IS

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

2720:
2721: --This cursor determines termination date of an assignment.
2722: CURSOR c_termination_check(p_assignment_id NUMBER)
2723: IS
2724: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2725: FROM per_all_assignments_f asg
2726: ,per_periods_of_service pos
2727: WHERE asg.person_id = pos.person_id
2728: AND asg.assignment_id = p_assignment_id

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

2902: ,p_arc_payroll_act_id => l_arc_pay_action_id
2903: ,p_prepayment_date => l_pre_effective_date
2904: ,p_assignment_id => l_assignment_id
2905: ,p_gre_id => g_asg_tab(i).gre_id
2906: ,p_payroll_run_date => fnd_date.date_to_canonical(l_run_date_earned)
2907: ,p_effective_start_date => g_asg_tab(i).start_date
2908: ,p_effective_end_date => LEAST(g_asg_tab(i).end_date,l_end_date)
2909: );
2910: pay_in_utils.set_location(g_debug,l_procedure, 110);