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 843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

839: FROM pay_assignment_actions paa,
840: pay_payroll_actions ppa,
841: per_assignments_f paf
842: WHERE ppa.business_group_id = ' || ln_business_group_id || '
843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
844: fnd_date.date_to_canonical(ld_start_date) || ''')
845: AND fnd_date.canonical_to_date(''' ||
846: fnd_date.date_to_canonical(ld_end_date) || ''')
847: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

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

840: pay_payroll_actions ppa,
841: per_assignments_f paf
842: WHERE ppa.business_group_id = ' || ln_business_group_id || '
843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
844: fnd_date.date_to_canonical(ld_start_date) || ''')
845: AND fnd_date.canonical_to_date(''' ||
846: fnd_date.date_to_canonical(ld_end_date) || ''')
847: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
848: AND paa.action_status = ''C''

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

841: per_assignments_f paf
842: WHERE ppa.business_group_id = ' || ln_business_group_id || '
843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
844: fnd_date.date_to_canonical(ld_start_date) || ''')
845: AND fnd_date.canonical_to_date(''' ||
846: fnd_date.date_to_canonical(ld_end_date) || ''')
847: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
848: AND paa.action_status = ''C''
849: AND ppa.payroll_action_id = paa.payroll_action_id

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

842: WHERE ppa.business_group_id = ' || ln_business_group_id || '
843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
844: fnd_date.date_to_canonical(ld_start_date) || ''')
845: AND fnd_date.canonical_to_date(''' ||
846: fnd_date.date_to_canonical(ld_end_date) || ''')
847: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
848: AND paa.action_status = ''C''
849: AND ppa.payroll_action_id = paa.payroll_action_id
850: AND paa.source_action_id IS NULL

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

861: FROM pay_assignment_actions paa,
862: pay_payroll_actions ppa,
863: per_assignments_f paf
864: WHERE ppa.business_group_id = ' || ln_business_group_id || '
865: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
866: fnd_date.date_to_canonical(ld_start_date) || ''')
867: AND fnd_date.canonical_to_date(''' ||
868: fnd_date.date_to_canonical(ld_end_date) || ''')
869: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')

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

862: pay_payroll_actions ppa,
863: per_assignments_f paf
864: WHERE ppa.business_group_id = ' || ln_business_group_id || '
865: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
866: fnd_date.date_to_canonical(ld_start_date) || ''')
867: AND fnd_date.canonical_to_date(''' ||
868: fnd_date.date_to_canonical(ld_end_date) || ''')
869: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
870: AND paa.action_status = ''C''

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

863: per_assignments_f paf
864: WHERE ppa.business_group_id = ' || ln_business_group_id || '
865: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
866: fnd_date.date_to_canonical(ld_start_date) || ''')
867: AND fnd_date.canonical_to_date(''' ||
868: fnd_date.date_to_canonical(ld_end_date) || ''')
869: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
870: AND paa.action_status = ''C''
871: AND ppa.payroll_action_id = paa.payroll_action_id

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

864: WHERE ppa.business_group_id = ' || ln_business_group_id || '
865: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
866: fnd_date.date_to_canonical(ld_start_date) || ''')
867: AND fnd_date.canonical_to_date(''' ||
868: fnd_date.date_to_canonical(ld_end_date) || ''')
869: AND ppa.action_type IN (''Q'',''R'',''B'',''V'',''I'')
870: AND paa.action_status = ''C''
871: AND ppa.payroll_action_id = paa.payroll_action_id
872: AND paa.source_action_id IS NULL

Line 1192: fnd_date.date_to_canonical(ld_prev_arch_eff_date));

1188: -- period of service.
1189: --
1190:
1191: hr_utility.trace('Prev Arch Effective Date = ' ||
1192: fnd_date.date_to_canonical(ld_prev_arch_eff_date));
1193: hr_utility.trace('Prev Arch Asg Action ID = ' ||
1194: ln_prev_arch_aaid);
1195: hr_utility.set_location(gv_package ||
1196: lv_procedure_name, 80);

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

1541: ppf.per_information1 "Maternal Last Name",
1542: ppf.first_name || ' ' || ppf.middle_names,
1543: ppf.national_identifier "CURP",
1544: ppf.per_information2 "RFC ID",
1545: GREATEST(fnd_date.canonical_to_date(g_fiscal_year || '/01/01'),
1546: DECODE(TO_CHAR(pps.date_start, 'YYYY'),
1547: TO_CHAR(cp_effective_date, 'YYYY'),
1548: pps.date_start,
1549: fnd_date.canonical_to_date(g_fiscal_year ||

Line 1549: fnd_date.canonical_to_date(g_fiscal_year ||

1545: GREATEST(fnd_date.canonical_to_date(g_fiscal_year || '/01/01'),
1546: DECODE(TO_CHAR(pps.date_start, 'YYYY'),
1547: TO_CHAR(cp_effective_date, 'YYYY'),
1548: pps.date_start,
1549: fnd_date.canonical_to_date(g_fiscal_year ||
1550: '/01/01'))
1551: ),
1552:
1553: hr_mx_utility.get_seniority(paf.business_group_id,

Line 1631: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')

1627: AND hou.organization_id = paa.tax_unit_id
1628: AND hou.organization_id = hoi.organization_id
1629: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
1630: AND hl.location_id = paf.location_id
1631: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')
1632: AND p_effective_date
1633: AND ppa.action_type in ('Q','R','B','V','I')) per_det;
1634:
1635: -- Get Other ER info for ERs of the current year

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

1643: fnd_number.canonical_to_number(pei_information9) Exempt_Earnings
1644: FROM per_people_extra_info
1645: WHERE information_type = 'MX_PREV_EMPLOYMENT_INFO'
1646: AND person_id = cp_person_id
1647: AND TO_CHAR(fnd_date.canonical_to_date(pei_information4), 'YYYY') =
1648: TO_CHAR(cp_effective_date, 'YYYY')
1649: ORDER BY pei_information4 DESC;
1650:
1651: -- Get end date of Format 37 for the person

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

1654: pps.actual_termination_date, /*Bug 8402505*/
1655: NVL(pps.actual_termination_date,
1656: nvl(paf.effective_end_date, p_effective_date)) effective_date,
1657: NVL(pps.actual_termination_date,
1658: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
1659: )
1660: FROM per_people_f ppf,
1661: per_assignments_f paf,
1662: pay_assignment_actions paa,

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

1931:
1932: /*bug 11715919 */
1933: CURSOR c_get_max_arch_end_date ( cp_person_id NUMBER) IS
1934: SELECT NVL(max(actual_termination_date),
1935: fnd_date.canonical_to_date(g_fiscal_year || '/12/31'))
1936: FROM per_periods_of_service
1937: WHERE person_id = cp_person_id
1938: AND actual_termination_date
1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')

Line 1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')

1935: fnd_date.canonical_to_date(g_fiscal_year || '/12/31'))
1936: FROM per_periods_of_service
1937: WHERE person_id = cp_person_id
1938: AND actual_termination_date
1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')
1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');
1941: /* Bug 13093752 */
1942: CURSOR c_get_amends_amount IS
1943: SELECT nvl(fnd_number.canonical_to_number(value),0)

Line 1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');

1936: FROM per_periods_of_service
1937: WHERE person_id = cp_person_id
1938: AND actual_termination_date
1939: BETWEEN fnd_date.canonical_to_date(g_fiscal_year || '/01/01')
1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');
1941: /* Bug 13093752 */
1942: CURSOR c_get_amends_amount IS
1943: SELECT nvl(fnd_number.canonical_to_number(value),0)
1944: FROM ff_archive_items

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

2002: hr_utility.trace('ld_act_term_date: '||ld_act_term_date);
2003: hr_utility.trace('ld_effective_date: '||ld_effective_date);
2004: hr_utility.trace('ld_arch_end_date: '||ld_arch_end_date);
2005:
2006: IF ld_arch_end_date <> fnd_date.canonical_to_date(g_fiscal_year ||
2007: '/12/31') THEN
2008:
2009: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2010: lb_is_term_ee := TRUE;

Line 2012: ELSIF (ld_act_term_date IS NOT NULL) AND (ld_act_term_date = fnd_date.canonical_to_date

2008:
2009: hr_utility.set_location(gv_package || lv_procedure_name, 40);
2010: lb_is_term_ee := TRUE;
2011: hr_utility.trace('lb_is_term_ee= TRUE');
2012: ELSIF (ld_act_term_date IS NOT NULL) AND (ld_act_term_date = fnd_date.canonical_to_date
2013: (g_fiscal_year ||'/12/31')) THEN
2014: hr_utility.trace('ld_act_term_date: '||ld_act_term_date);
2015: hr_utility.set_location(gv_package || lv_procedure_name, 45);
2016: hr_utility.trace('Emp is terminated on last pay period');

Line 2027: fnd_date.date_to_canonical(p_effective_date));

2023: END IF;
2024:
2025: ln_step := 2;
2026: hr_utility.trace('Effective Date of archiver for the person: ' ||
2027: fnd_date.date_to_canonical(p_effective_date));
2028:
2029:
2030: ln_step := 3;
2031: ld_start_date := fnd_date.canonical_to_date(g_fiscal_year || '/01/01');

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

2027: fnd_date.date_to_canonical(p_effective_date));
2028:
2029:
2030: ln_step := 3;
2031: ld_start_date := fnd_date.canonical_to_date(g_fiscal_year || '/01/01');
2032:
2033: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2034:
2035: -- Fetch the YTD Assignment Action ID.

Line 2101: ld_max_arch_end_date := fnd_date.canonical_to_date(g_fiscal_year || '/12/31');

2097: hr_utility.trace('ld_PTU_date: = '|| ld_PTU_date);
2098: hr_utility.trace('ld_max_arch_end_date: ='|| ld_max_arch_end_date);
2099:
2100: IF ld_max_arch_end_date IS NULL THEN
2101: ld_max_arch_end_date := fnd_date.canonical_to_date(g_fiscal_year || '/12/31');
2102: END IF;
2103:
2104: hr_utility.trace('ld_max_arch_end_date: '||ld_max_arch_end_date);
2105:

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

2255: IF lv_ann_adj IS NULL THEN
2256: lv_ann_adj := 'N';
2257: END IF;
2258:
2259: /*ld_hire_date := fnd_date.canonical_to_date('1900/01/01');
2260:
2261: OPEN c_get_hire_date(ln_person_id,ld_effective_date); --Re-hire bug
2262: FETCH c_get_hire_date INTO ld_hire_date;
2263: CLOSE c_get_hire_date;

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

2357: OPEN c_fetch_Ann_adj(ln_person_id,p_effective_date);
2358: FETCH c_fetch_Ann_adj INTO lv_ann_adj;
2359: CLOSE c_fetch_Ann_adj;*/
2360:
2361: ld_hire_date := fnd_date.canonical_to_date('1900/01/01');
2362:
2363: OPEN c_get_hire_date(ln_person_id,ld_effective_date); --Re-hire bug
2364: FETCH c_get_hire_date INTO ld_hire_date;
2365: CLOSE c_get_hire_date;

Line 2408: fnd_date.date_to_canonical(ld_arch_start_date);

2404: pai_tab(ln_index).act_info3 := replace(pay_mx_rules.strip_spl_chars(lv_names),'/','N');
2405: pai_tab(ln_index).act_info4 := lv_CURP;
2406: pai_tab(ln_index).act_info5 := lv_RFC_ID;
2407: pai_tab(ln_index).act_info6 :=
2408: fnd_date.date_to_canonical(ld_arch_start_date);
2409: pai_tab(ln_index).act_info7 :=
2410: fnd_date.date_to_canonical(ld_arch_end_date);
2411:
2412: hr_utility.trace('lv_prev_arch_exists: '|| lv_prev_arch_exists);

Line 2410: fnd_date.date_to_canonical(ld_arch_end_date);

2406: pai_tab(ln_index).act_info5 := lv_RFC_ID;
2407: pai_tab(ln_index).act_info6 :=
2408: fnd_date.date_to_canonical(ld_arch_start_date);
2409: pai_tab(ln_index).act_info7 :=
2410: fnd_date.date_to_canonical(ld_arch_end_date);
2411:
2412: hr_utility.trace('lv_prev_arch_exists: '|| lv_prev_arch_exists);
2413: hr_utility.trace('lv_arch_for_ptu_only: '|| lv_arch_for_ptu_only);
2414: hr_utility.trace('lv_amends_amount: '|| lv_amends_amount);