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

Line 630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

626: FROM pay_assignment_actions paa,
627: pay_payroll_actions ppa,
628: per_assignments_f paf
629: WHERE ppa.business_group_id = ' || ln_business_group_id || '
630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
631: fnd_date.date_to_canonical(ld_start_date) || ''')
632: AND fnd_date.canonical_to_date(''' ||
633: fnd_date.date_to_canonical(ld_end_date) || ''')
634: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

Line 631: fnd_date.date_to_canonical(ld_start_date) || ''')

627: pay_payroll_actions ppa,
628: per_assignments_f paf
629: WHERE ppa.business_group_id = ' || ln_business_group_id || '
630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
631: fnd_date.date_to_canonical(ld_start_date) || ''')
632: AND fnd_date.canonical_to_date(''' ||
633: fnd_date.date_to_canonical(ld_end_date) || ''')
634: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
635: AND paa.action_status = ''C''

Line 632: AND fnd_date.canonical_to_date(''' ||

628: per_assignments_f paf
629: WHERE ppa.business_group_id = ' || ln_business_group_id || '
630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
631: fnd_date.date_to_canonical(ld_start_date) || ''')
632: AND fnd_date.canonical_to_date(''' ||
633: fnd_date.date_to_canonical(ld_end_date) || ''')
634: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
635: AND paa.action_status = ''C''
636: AND ppa.payroll_action_id = paa.payroll_action_id

Line 633: fnd_date.date_to_canonical(ld_end_date) || ''')

629: WHERE ppa.business_group_id = ' || ln_business_group_id || '
630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
631: fnd_date.date_to_canonical(ld_start_date) || ''')
632: AND fnd_date.canonical_to_date(''' ||
633: fnd_date.date_to_canonical(ld_end_date) || ''')
634: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
635: AND paa.action_status = ''C''
636: AND ppa.payroll_action_id = paa.payroll_action_id
637: AND paa.source_action_id IS NULL

Line 652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

648: FROM pay_assignment_actions paa,
649: pay_payroll_actions ppa,
650: per_assignments_f paf
651: WHERE ppa.business_group_id = ' || ln_business_group_id || '
652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
653: fnd_date.date_to_canonical(ld_start_date) || ''')
654: AND fnd_date.canonical_to_date(''' ||
655: fnd_date.date_to_canonical(ld_end_date) || ''')
656: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

Line 653: fnd_date.date_to_canonical(ld_start_date) || ''')

649: pay_payroll_actions ppa,
650: per_assignments_f paf
651: WHERE ppa.business_group_id = ' || ln_business_group_id || '
652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
653: fnd_date.date_to_canonical(ld_start_date) || ''')
654: AND fnd_date.canonical_to_date(''' ||
655: fnd_date.date_to_canonical(ld_end_date) || ''')
656: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
657: AND paa.action_status = ''C''

Line 654: AND fnd_date.canonical_to_date(''' ||

650: per_assignments_f paf
651: WHERE ppa.business_group_id = ' || ln_business_group_id || '
652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
653: fnd_date.date_to_canonical(ld_start_date) || ''')
654: AND fnd_date.canonical_to_date(''' ||
655: fnd_date.date_to_canonical(ld_end_date) || ''')
656: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
657: AND paa.action_status = ''C''
658: AND ppa.payroll_action_id = paa.payroll_action_id

Line 655: fnd_date.date_to_canonical(ld_end_date) || ''')

651: WHERE ppa.business_group_id = ' || ln_business_group_id || '
652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
653: fnd_date.date_to_canonical(ld_start_date) || ''')
654: AND fnd_date.canonical_to_date(''' ||
655: fnd_date.date_to_canonical(ld_end_date) || ''')
656: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
657: AND paa.action_status = ''C''
658: AND ppa.payroll_action_id = paa.payroll_action_id
659: AND paa.source_action_id IS NULL

Line 972: fnd_date.date_to_canonical(ld_prev_arch_eff_date));

968: -- period of service.
969: --
970:
971: hr_utility.trace('Prev Arch Effective Date = ' ||
972: fnd_date.date_to_canonical(ld_prev_arch_eff_date));
973: hr_utility.trace('Prev Arch Asg Action ID = ' ||
974: ln_prev_arch_aaid);
975: hr_utility.set_location(gv_package ||
976: lv_procedure_name, 80);

Line 1307: GREATEST(fnd_date.canonical_to_date(g_fiscal_year || '/01/01'),

1303: ppf.per_information1 "Maternal Last Name",
1304: ppf.first_name || ' ' || ppf.middle_names,
1305: ppf.national_identifier "CURP",
1306: ppf.per_information2 "RFC ID",
1307: GREATEST(fnd_date.canonical_to_date(g_fiscal_year || '/01/01'),
1308: DECODE(TO_CHAR(pps.date_start, 'YYYY'),
1309: TO_CHAR(cp_effective_date, 'YYYY'),
1310: pps.date_start,
1311: fnd_date.canonical_to_date(g_fiscal_year ||

Line 1311: fnd_date.canonical_to_date(g_fiscal_year ||

1307: GREATEST(fnd_date.canonical_to_date(g_fiscal_year || '/01/01'),
1308: DECODE(TO_CHAR(pps.date_start, 'YYYY'),
1309: TO_CHAR(cp_effective_date, 'YYYY'),
1310: pps.date_start,
1311: fnd_date.canonical_to_date(g_fiscal_year ||
1312: '/01/01'))
1313: ),
1314:
1315: hr_mx_utility.get_seniority(paf.business_group_id,

Line 1405: AND TO_CHAR(fnd_date.canonical_to_date(pei_information4), 'YYYY') =

1401: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1402: FROM per_people_extra_info
1403: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1404: AND person_id = cp_person_id
1405: AND TO_CHAR(fnd_date.canonical_to_date(pei_information4), 'YYYY') =
1406: TO_CHAR(cp_effective_date, 'YYYY')
1407: ORDER BY pei_information4 DESC;
1408:
1409: -- Get end date of Format 37 for the person

Line 1415: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')

1411: SELECT DISTINCT
1412: NVL(pps.actual_termination_date,
1413: nvl(paf.effective_end_date, p_effective_date)),
1414: NVL(pps.actual_termination_date,
1415: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
1416: )
1417: FROM per_people_f ppf,
1418: per_assignments_f paf,
1419: pay_assignment_actions paa,

Line 1733: IF ld_arch_end_date <> fnd_date.canonical_to_date(g_fiscal_year ||

1729:
1730: hr_utility.trace('ld_effective_date: '||ld_effective_date);
1731: hr_utility.trace('ld_arch_end_date: '||ld_arch_end_date);
1732:
1733: IF ld_arch_end_date <> fnd_date.canonical_to_date(g_fiscal_year ||
1734: '/12/31') THEN
1735:
1736: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1737: lb_is_term_ee := TRUE;

Line 1747: fnd_date.date_to_canonical(p_effective_date));

1743: END IF;
1744:
1745: ln_step := 2;
1746: hr_utility.trace('Effective Date of archiver for the person: ' ||
1747: fnd_date.date_to_canonical(p_effective_date));
1748:
1749:
1750: ln_step := 3;
1751: ld_start_date := fnd_date.canonical_to_date(g_fiscal_year || '/01/01');

Line 1751: ld_start_date := fnd_date.canonical_to_date(g_fiscal_year || '/01/01');

1747: fnd_date.date_to_canonical(p_effective_date));
1748:
1749:
1750: ln_step := 3;
1751: ld_start_date := fnd_date.canonical_to_date(g_fiscal_year || '/01/01');
1752:
1753: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1754:
1755: -- EE details need to be fetched as on the Actual

Line 1926: ld_hire_date := fnd_date.canonical_to_date('1900/01/01');

1922: OPEN c_fetch_Ann_adj(ln_person_id,p_effective_date);
1923: FETCH c_fetch_Ann_adj INTO lv_ann_adj;
1924: CLOSE c_fetch_Ann_adj;
1925:
1926: ld_hire_date := fnd_date.canonical_to_date('1900/01/01');
1927:
1928: OPEN c_get_hire_date(ln_person_id,p_effective_date);
1929: FETCH c_get_hire_date INTO ld_hire_date;
1930: CLOSE c_get_hire_date;

Line 1965: fnd_date.date_to_canonical(ld_arch_start_date);

1961: pai_tab(ln_index).act_info3 := lv_names;
1962: pai_tab(ln_index).act_info4 := lv_CURP;
1963: pai_tab(ln_index).act_info5 := lv_RFC_ID;
1964: pai_tab(ln_index).act_info6 :=
1965: fnd_date.date_to_canonical(ld_arch_start_date);
1966: pai_tab(ln_index).act_info7 :=
1967: fnd_date.date_to_canonical(ld_arch_end_date);
1968:
1969: IF lb_is_term_ee AND lv_prev_arch_exists = 'N' AND

Line 1967: fnd_date.date_to_canonical(ld_arch_end_date);

1963: pai_tab(ln_index).act_info5 := lv_RFC_ID;
1964: pai_tab(ln_index).act_info6 :=
1965: fnd_date.date_to_canonical(ld_arch_start_date);
1966: pai_tab(ln_index).act_info7 :=
1967: fnd_date.date_to_canonical(ld_arch_end_date);
1968:
1969: IF lb_is_term_ee AND lv_prev_arch_exists = 'N' AND
1970: lv_arch_for_ptu_only = 'N' THEN
1971: