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

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

2241: FROM pay_assignment_actions paa,
2242: pay_payroll_actions ppa,
2243: per_assignments_f paf
2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')
2247: AND fnd_date.canonical_to_date(''' ||
2248: fnd_date.date_to_canonical(ld_end_date) || ''')
2249: AND ppa.action_type IN (''U'',''P'',''B'',''V'')

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

2242: pay_payroll_actions ppa,
2243: per_assignments_f paf
2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')
2247: AND fnd_date.canonical_to_date(''' ||
2248: fnd_date.date_to_canonical(ld_end_date) || ''')
2249: AND ppa.action_type IN (''U'',''P'',''B'',''V'')
2250: AND DECODE(ppa.action_type,

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

2243: per_assignments_f paf
2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')
2247: AND fnd_date.canonical_to_date(''' ||
2248: fnd_date.date_to_canonical(ld_end_date) || ''')
2249: AND ppa.action_type IN (''U'',''P'',''B'',''V'')
2250: AND DECODE(ppa.action_type,
2251: ''B'', NVL(ppa.future_process_mode, ''Y''),

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

2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')
2247: AND fnd_date.canonical_to_date(''' ||
2248: fnd_date.date_to_canonical(ld_end_date) || ''')
2249: AND ppa.action_type IN (''U'',''P'',''B'',''V'')
2250: AND DECODE(ppa.action_type,
2251: ''B'', NVL(ppa.future_process_mode, ''Y''),
2252: ''N'') = ''N''

Line 2437: ld_effective_date := fnd_date.canonical_to_date('1900/12/31');

2433:
2434: lb_range_person BOOLEAN;
2435:
2436: BEGIN
2437: ld_effective_date := fnd_date.canonical_to_date('1900/12/31');
2438: lv_procedure_name := '.assignment_action_code';
2439:
2440: ln_step := 1;
2441: pay_emp_action_arch.gv_error_message := NULL;

Line 3143: fnd_date.date_to_canonical(ld_effective_date));

3139:
3140:
3141: hr_utility.trace('Action_info_id = ' || ln_action_information_id);
3142: hr_utility.trace('ld_eff_date = ' ||
3143: fnd_date.date_to_canonical(ld_effective_date));
3144:
3145: OPEN c_get_employee_info(p_assignment_id, ld_effective_date);
3146: FETCH c_get_employee_info INTO lv_employee_name;
3147: CLOSE c_get_employee_info;

Line 3651: ELSIF fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date

3647: IF gv_act_param_val IS NOT NULL THEN
3648: IF gv_act_param_val = 'Y'
3649: THEN
3650: ld_last_xfr_eff_date := NULL;
3651: ELSIF fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date
3652: THEN
3653: ld_last_xfr_eff_date := NULL;
3654: END IF;
3655: END IF;