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_P45_PKG dependencies on HR_GENERAL

Line 963: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date

959: --
960: -- Cursor to find last date after assignment's termination date until which
961: -- aggregation flag has remained Y - assuming flag is Y at the termination date
962: CURSOR get_aggregation_end IS
963: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
964: FROM per_all_people_f
965: WHERE person_id = X_PERSON_ID
966: AND effective_start_date > X_ASSIGNMENT_END_DATE
967: AND nvl(per_information10, 'N') = 'N';

Line 1170: least(l_effective_date,nvl(l_override_date,hr_general.end_of_time));

1166: -- Bug 2332796. Use the least of date paid and override
1167: -- date to get the time period for EOY expiry check.
1168: --
1169: l_taxable_update_date :=
1170: least(l_effective_date,nvl(l_override_date,hr_general.end_of_time));
1171: open c_ptp(l_taxable_update_payroll,
1172: nvl(l_taxable_update_date, X_ASSIGNMENT_END_DATE));
1173: fetch c_ptp into l_ptp;
1174: l_found := c_ptp%found;

Line 1325: nvl(X_TRANSFER_DATE,hr_general.end_of_time),

1321: X_ASSIGNMENT_END_DATE,
1322: X_ASSIGNMENT_ACTION_ID,
1323: X_DATE_EARNED,
1324: X_PAYROLL_ACTION_ID,
1325: nvl(X_TRANSFER_DATE,hr_general.end_of_time),
1326: X_PERSON_ID,
1327: l_tax_reference);
1328:
1329: end get_data;

Line 1390: nvl(X_TRANSFER_DATE,hr_general.end_of_time),

1386: X_ASSIGNMENT_END_DATE,
1387: X_ASSIGNMENT_ACTION_ID,
1388: X_DATE_EARNED,
1389: X_PAYROLL_ACTION_ID,
1390: nvl(X_TRANSFER_DATE,hr_general.end_of_time),
1391: X_PERSON_ID, l_tax_reference);
1392:
1393: get_employer_address(X_ASSIGNMENT_ID,
1394: X_ASSIGNMENT_END_DATE,

Line 2316: -- and asg2.effective_end_date <> hr_general.end_of_time)

2312: -- per_assignment_status_types past
2313: -- where asg2.assignment_id = a.assignment_id
2314: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2315: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2316: -- and asg2.effective_end_date <> hr_general.end_of_time)
2317: AND a.assignment_status_type_id =past.assignment_status_type_id
2318: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2319: AND a.effective_end_date <> hr_general.end_of_time
2320: AND a.person_id = p.person_id

Line 2319: AND a.effective_end_date <> hr_general.end_of_time

2315: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2316: -- and asg2.effective_end_date <> hr_general.end_of_time)
2317: AND a.assignment_status_type_id =past.assignment_status_type_id
2318: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2319: AND a.effective_end_date <> hr_general.end_of_time
2320: AND a.person_id = p.person_id
2321: AND a.effective_end_date between p.effective_start_date and p.effective_end_date
2322: GROUP BY a.assignment_id, a.assignment_number, a.period_of_service_id,
2323: p.person_id, decode(p.per_information10,'Y','Y',NULL),

Line 2379: -- and asg2.effective_end_date <> hr_general.end_of_time)

2375: -- where asg2.assignment_id = a.assignment_id
2376: -- and asg2.assignment_status_type_id =
2377: -- past.assignment_status_type_id
2378: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2379: -- and asg2.effective_end_date <> hr_general.end_of_time)
2380: AND a.assignment_status_type_id =past.assignment_status_type_id
2381: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2382: AND a.effective_end_date <> hr_general.end_of_time
2383: AND a.person_id = p.person_id

Line 2382: AND a.effective_end_date <> hr_general.end_of_time

2378: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2379: -- and asg2.effective_end_date <> hr_general.end_of_time)
2380: AND a.assignment_status_type_id =past.assignment_status_type_id
2381: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2382: AND a.effective_end_date <> hr_general.end_of_time
2383: AND a.person_id = p.person_id
2384: AND a.effective_end_date between p.effective_start_date and p.effective_end_date
2385: GROUP BY a.assignment_id, a.assignment_number, a.period_of_service_id,
2386: p.person_id, decode(p.per_information10,'Y','Y',NULL),

Line 2396: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date

2392: -------------------------------------------------------------------------------------
2393: -- Cursor to find last date after assignment's termination date until which
2394: -- aggregation flag has remained Y - assuming flag is Y at the termination date
2395: CURSOR get_agg_end(p_person_id NUMBER, p_term_date DATE) IS
2396: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
2397: FROM per_all_people_f
2398: WHERE person_id = p_person_id
2399: AND effective_start_date > p_term_date
2400: AND nvl(per_information10, 'N') = 'N';

Line 2403: SELECT nvl((max(effective_end_date)+1), hr_general.start_of_time) agg_start_date

2399: AND effective_start_date > p_term_date
2400: AND nvl(per_information10, 'N') = 'N';
2401: --
2402: CURSOR get_agg_start(p_person_id NUMBER, p_term_date DATE) IS
2403: SELECT nvl((max(effective_end_date)+1), hr_general.start_of_time) agg_start_date
2404: FROM per_all_people_f
2405: WHERE person_id = p_person_id
2406: AND effective_end_date < p_term_date
2407: AND nvl(per_information10, 'N') = 'N';

Line 2620: rec_asg.asg_end_date, hr_general.start_of_time,

2616: IF rec_asg.agg_paye_flag = 'Y' then
2617: hr_utility.set_location(l_proc,80);
2618: for rec_all_aggs in csr_person_agg_asg(rec_asg.person_id, g_tax_ref,
2619: rec_asg.assignment_id, rec_asg.period_of_service_id,
2620: rec_asg.asg_end_date, hr_general.start_of_time,
2621: hr_general.end_of_time) loop
2622: if rec_asg.asg_end_date < rec_all_aggs.effective_end_date then
2623: -- Asg exists that is not ended as of the effective end
2624: -- of the current assignment, and is ACTIVE

Line 2621: hr_general.end_of_time) loop

2617: hr_utility.set_location(l_proc,80);
2618: for rec_all_aggs in csr_person_agg_asg(rec_asg.person_id, g_tax_ref,
2619: rec_asg.assignment_id, rec_asg.period_of_service_id,
2620: rec_asg.asg_end_date, hr_general.start_of_time,
2621: hr_general.end_of_time) loop
2622: if rec_asg.asg_end_date < rec_all_aggs.effective_end_date then
2623: -- Asg exists that is not ended as of the effective end
2624: -- of the current assignment, and is ACTIVE
2625: l_non_p45_message := 'TFR: Agg: asg exists not ended: '||

Line 2971: g_do_edi_validation := hr_general.char_to_bool(l_do_edi_validation);

2967: FETCH csr_parameter_info INTO g_payroll_id,
2968: l_do_edi_validation,
2969: l_effective_date;
2970: CLOSE csr_parameter_info;
2971: g_do_edi_validation := hr_general.char_to_bool(l_do_edi_validation);
2972: OPEN csr_version_info(p_payroll_action_id);
2973: FETCH csr_version_info INTO l_edi_ver;
2974: CLOSE csr_version_info;
2975: g_edi_ver := l_edi_ver;

Line 3210: nvl(serv.final_process_date, hr_general.end_of_time), -- For bug 9071978

3206: SELECT ass.assignment_number,
3207: ass.person_id,
3208: ass.effective_end_date asg_effective_end_date,
3209: serv.last_standard_process_date,
3210: nvl(serv.final_process_date, hr_general.end_of_time), -- For bug 9071978
3211: ass.period_of_service_id,
3212: decode(serv.leaving_reason,'D','D') deceased_flag,
3213: org.name org_name,
3214: upper(p.last_name) , p.title ,

Line 3412: l_transfer_date := hr_general.end_of_time;

3408: ELSE
3409: -- 5144323: for transfer cases actions from old PAYE Ref (before transfer date)
3410: -- need to be fetched but assignment/employee termination cases there
3411: -- should be no time limit hence transfer date is set to end of time
3412: l_transfer_date := hr_general.end_of_time;
3413: END IF;
3414: --
3415: hr_utility.trace(l_last_name||' '||to_char(l_asg_effective_end_date)||
3416: to_char(l_assignment_id)||' '||to_char(l_termination_date)||

Line 4176: save_output => hr_general.char_to_bool

4172: l_print_return := fnd_request.set_print_options
4173: (printer => rec_print_options.printer,
4174: style => l_printer_style,
4175: copies => l_number_of_copies,
4176: save_output => hr_general.char_to_bool
4177: (rec_print_options.save_output),
4178: print_together => l_print_together);
4179: hr_utility.trace('Print options set call returned: '||
4180: hr_general.bool_to_char(l_print_return));

Line 4180: hr_general.bool_to_char(l_print_return));

4176: save_output => hr_general.char_to_bool
4177: (rec_print_options.save_output),
4178: print_together => l_print_together);
4179: hr_utility.trace('Print options set call returned: '||
4180: hr_general.bool_to_char(l_print_return));
4181:
4182: -- Submit report
4183: /*P45 A4 2008-09 changes */
4184: /*l_request_id := fnd_request.submit_request