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

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

2302: FROM pay_assignment_actions paa,
2303: pay_payroll_actions ppa,
2304: per_assignments_f paf
2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')
2308: AND fnd_date.canonical_to_date(''' ||
2309: fnd_date.date_to_canonical(ld_end_date) || ''')
2310: AND ppa.action_type IN (''U'',''P'',''B'')

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

2303: pay_payroll_actions ppa,
2304: per_assignments_f paf
2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')
2308: AND fnd_date.canonical_to_date(''' ||
2309: fnd_date.date_to_canonical(ld_end_date) || ''')
2310: AND ppa.action_type IN (''U'',''P'',''B'')
2311: AND DECODE(ppa.action_type,

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

2304: per_assignments_f paf
2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')
2308: AND fnd_date.canonical_to_date(''' ||
2309: fnd_date.date_to_canonical(ld_end_date) || ''')
2310: AND ppa.action_type IN (''U'',''P'',''B'')
2311: AND DECODE(ppa.action_type,
2312: ''B'', NVL(ppa.future_process_mode, ''Y''),

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

2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')
2308: AND fnd_date.canonical_to_date(''' ||
2309: fnd_date.date_to_canonical(ld_end_date) || ''')
2310: AND ppa.action_type IN (''U'',''P'',''B'')
2311: AND DECODE(ppa.action_type,
2312: ''B'', NVL(ppa.future_process_mode, ''Y''),
2313: ''N'') = ''N''

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

2495:
2496: lb_range_person BOOLEAN;
2497:
2498: BEGIN
2499: ld_effective_date := fnd_date.canonical_to_date('1900/12/31');
2500: lv_procedure_name := '.assignment_action_code';
2501:
2502: ln_step := 1;
2503: pay_emp_action_arch.gv_error_message := NULL;

Line 3418: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);

3414: FOR csr_rec in csr_asg_absences
3415: LOOP
3416: hr_utility.trace('Entered for loop');
3417:
3418: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
3419: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
3420:
3421: l_ovn := 1;
3422:

Line 3419: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

3415: LOOP
3416: hr_utility.trace('Entered for loop');
3417:
3418: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
3419: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
3420:
3421: l_ovn := 1;
3422:
3423: pay_action_information_api.create_action_information

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

3824: IF gv_act_param_val IS NOT NULL THEN
3825: IF gv_act_param_val = 'Y'
3826: THEN
3827: ld_last_xfr_eff_date := NULL;
3828: ELSIF fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date
3829: THEN
3830: ld_last_xfr_eff_date := NULL;
3831: END IF;
3832: END IF;