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 885: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date

881: --
882: -- Cursor to find last date after assignment's termination date until which
883: -- aggregation flag has remained Y - assuming flag is Y at the termination date
884: CURSOR get_aggregation_end IS
885: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
886: FROM per_all_people_f
887: WHERE person_id = X_PERSON_ID
888: AND effective_start_date > X_ASSIGNMENT_END_DATE
889: AND nvl(per_information10, 'N') = 'N';

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

1059: -- Bug 2332796. Use the least of date paid and override
1060: -- date to get the time period for EOY expiry check.
1061: --
1062: l_taxable_update_date :=
1063: least(l_effective_date,nvl(l_override_date,hr_general.end_of_time));
1064: open c_ptp(l_taxable_update_payroll,
1065: nvl(l_taxable_update_date, X_ASSIGNMENT_END_DATE));
1066: fetch c_ptp into l_ptp;
1067: l_found := c_ptp%found;

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

1213: X_ASSIGNMENT_END_DATE,
1214: X_ASSIGNMENT_ACTION_ID,
1215: X_DATE_EARNED,
1216: X_PAYROLL_ACTION_ID,
1217: nvl(X_TRANSFER_DATE,hr_general.end_of_time),
1218: X_PERSON_ID,
1219: l_tax_reference);
1220:
1221: end get_data;

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

1277: X_ASSIGNMENT_END_DATE,
1278: X_ASSIGNMENT_ACTION_ID,
1279: X_DATE_EARNED,
1280: X_PAYROLL_ACTION_ID,
1281: nvl(X_TRANSFER_DATE,hr_general.end_of_time),
1282: X_PERSON_ID, l_tax_reference);
1283:
1284: get_employer_address(X_ASSIGNMENT_ID,
1285: X_ASSIGNMENT_END_DATE,

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

2184: -- per_assignment_status_types past
2185: -- where asg2.assignment_id = a.assignment_id
2186: -- and asg2.assignment_status_type_id =past.assignment_status_type_id
2187: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2188: -- and asg2.effective_end_date <> hr_general.end_of_time)
2189: AND a.assignment_status_type_id =past.assignment_status_type_id
2190: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2191: AND a.effective_end_date <> hr_general.end_of_time
2192: AND a.person_id = p.person_id

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

2187: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2188: -- and asg2.effective_end_date <> hr_general.end_of_time)
2189: AND a.assignment_status_type_id =past.assignment_status_type_id
2190: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2191: AND a.effective_end_date <> hr_general.end_of_time
2192: AND a.person_id = p.person_id
2193: AND a.effective_end_date between p.effective_start_date and p.effective_end_date
2194: GROUP BY a.assignment_id, a.assignment_number, a.period_of_service_id,
2195: p.person_id, decode(p.per_information10,'Y','Y',NULL),

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

2243: -- where asg2.assignment_id = a.assignment_id
2244: -- and asg2.assignment_status_type_id =
2245: -- past.assignment_status_type_id
2246: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2247: -- and asg2.effective_end_date <> hr_general.end_of_time)
2248: AND a.assignment_status_type_id =past.assignment_status_type_id
2249: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2250: AND a.effective_end_date <> hr_general.end_of_time
2251: AND a.person_id = p.person_id

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

2246: -- and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2247: -- and asg2.effective_end_date <> hr_general.end_of_time)
2248: AND a.assignment_status_type_id =past.assignment_status_type_id
2249: AND past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2250: AND a.effective_end_date <> hr_general.end_of_time
2251: AND a.person_id = p.person_id
2252: AND a.effective_end_date between p.effective_start_date and p.effective_end_date
2253: GROUP BY a.assignment_id, a.assignment_number, a.period_of_service_id,
2254: p.person_id, decode(p.per_information10,'Y','Y',NULL),

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

2256: -------------------------------------------------------------------------------------
2257: -- Cursor to find last date after assignment's termination date until which
2258: -- aggregation flag has remained Y - assuming flag is Y at the termination date
2259: CURSOR get_agg_end(p_person_id NUMBER, p_term_date DATE) IS
2260: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
2261: FROM per_all_people_f
2262: WHERE person_id = p_person_id
2263: AND effective_start_date > p_term_date
2264: AND nvl(per_information10, 'N') = 'N';

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

2263: AND effective_start_date > p_term_date
2264: AND nvl(per_information10, 'N') = 'N';
2265: --
2266: CURSOR get_agg_start(p_person_id NUMBER, p_term_date DATE) IS
2267: SELECT nvl((max(effective_end_date)+1), hr_general.start_of_time) agg_start_date
2268: FROM per_all_people_f
2269: WHERE person_id = p_person_id
2270: AND effective_end_date < p_term_date
2271: AND nvl(per_information10, 'N') = 'N';

Line 2484: rec_asg.asg_end_date, hr_general.start_of_time,

2480: IF rec_asg.agg_paye_flag = 'Y' then
2481: hr_utility.set_location(l_proc,80);
2482: for rec_all_aggs in csr_person_agg_asg(rec_asg.person_id, g_tax_ref,
2483: rec_asg.assignment_id, rec_asg.period_of_service_id,
2484: rec_asg.asg_end_date, hr_general.start_of_time,
2485: hr_general.end_of_time) loop
2486: if rec_asg.asg_end_date < rec_all_aggs.effective_end_date then
2487: -- Asg exists that is not ended as of the effective end
2488: -- of the current assignment, and is ACTIVE

Line 2485: hr_general.end_of_time) loop

2481: hr_utility.set_location(l_proc,80);
2482: for rec_all_aggs in csr_person_agg_asg(rec_asg.person_id, g_tax_ref,
2483: rec_asg.assignment_id, rec_asg.period_of_service_id,
2484: rec_asg.asg_end_date, hr_general.start_of_time,
2485: hr_general.end_of_time) loop
2486: if rec_asg.asg_end_date < rec_all_aggs.effective_end_date then
2487: -- Asg exists that is not ended as of the effective end
2488: -- of the current assignment, and is ACTIVE
2489: l_non_p45_message := 'TFR: Agg: asg exists not ended: '||

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

2637: FETCH csr_parameter_info INTO g_payroll_id,
2638: l_do_edi_validation,
2639: l_effective_date;
2640: CLOSE csr_parameter_info;
2641: g_do_edi_validation := hr_general.char_to_bool(l_do_edi_validation);
2642: -- cache User entity Ids
2643: OPEN csr_user_entity('X_ADDRESS_LINE1');
2644: FETCH csr_user_entity INTO g_address_line1_eid;
2645: CLOSE csr_user_entity;

Line 2844: nvl(serv.final_process_date, hr_general.start_of_time),

2840: SELECT ass.assignment_number,
2841: ass.person_id,
2842: ass.effective_end_date asg_effective_end_date,
2843: serv.last_standard_process_date,
2844: nvl(serv.final_process_date, hr_general.start_of_time),
2845: ass.period_of_service_id,
2846: decode(serv.leaving_reason,'D','D') deceased_flag,
2847: org.name org_name,
2848: upper(p.last_name) , p.title ,

Line 3027: l_transfer_date := hr_general.end_of_time;

3023: ELSE
3024: -- 5144323: for transfer cases actions from old PAYE Ref (before transfer date)
3025: -- need to be fetched but assignment/employee termination cases there
3026: -- should be no time limit hence transfer date is set to end of time
3027: l_transfer_date := hr_general.end_of_time;
3028: END IF;
3029: --
3030: hr_utility.trace(l_last_name||' '||to_char(l_asg_effective_end_date)||
3031: to_char(l_assignment_id)||' '||to_char(l_termination_date)||

Line 3453: save_output => hr_general.char_to_bool

3449: l_print_return := fnd_request.set_print_options
3450: (printer => rec_print_options.printer,
3451: style => rec_print_options.print_style,
3452: copies => l_number_of_copies,
3453: save_output => hr_general.char_to_bool
3454: (rec_print_options.save_output),
3455: print_together => l_print_together);
3456: hr_utility.trace('Print options set call returned: '||
3457: hr_general.bool_to_char(l_print_return));

Line 3457: hr_general.bool_to_char(l_print_return));

3453: save_output => hr_general.char_to_bool
3454: (rec_print_options.save_output),
3455: print_together => l_print_together);
3456: hr_utility.trace('Print options set call returned: '||
3457: hr_general.bool_to_char(l_print_return));
3458: -- Submit report
3459: l_request_id := fnd_request.submit_request
3460: (application => 'PAY',
3461: program => l_report_short_name,