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_CC_PROCESS_UTILS dependencies on HR_API

Line 146: select nvl(min(ppe.effective_date), hr_api.g_eot)

142: procedure archive_data(p_assactid in number, p_effective_date in date) is
143: --
144: --
145: cursor get_dates (assact_id number, p_change_type varchar2) is
146: select nvl(min(ppe.effective_date), hr_api.g_eot)
147: effective_date
148: from pay_process_events ppe,
149: pay_assignment_actions paa
150: where paa.assignment_action_id = assact_id

Line 366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding

362: l_max_date DATE;
363: l_run_date DATE;
364: l_payroll_id NUMBER;
365: l_assignment_id NUMBER;
366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding
367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types

Line 367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED

363: l_run_date DATE;
364: l_payroll_id NUMBER;
365: l_assignment_id NUMBER;
366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding
367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates

Line 368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for

364: l_payroll_id NUMBER;
365: l_assignment_id NUMBER;
366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding
367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;

Line 369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --

365: l_assignment_id NUMBER;
366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding
367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;
373: paydate DATE := hr_api.g_eot;

Line 370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types

366: l_ee_min_dedate DATE := hr_api.g_eot; --Interim placeholders holding
367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;
373: paydate DATE := hr_api.g_eot;
374:

Line 371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates

367: l_ee_min_dpdate DATE := hr_api.g_eot; --min of ee's events type DATE_EARNED and DATE_PROCESSED
368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;
373: paydate DATE := hr_api.g_eot;
374:
375: -- Holders for results from the interpreter package

Line 372: rundate DATE := hr_api.g_eot;

368: l_aact_min_dedate DATE := hr_api.g_eot; --Interim placeholders for
369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;
373: paydate DATE := hr_api.g_eot;
374:
375: -- Holders for results from the interpreter package
376: l_de_det_tab_out pay_interpreter_pkg.t_detailed_output_table_type;

Line 373: paydate DATE := hr_api.g_eot;

369: l_aact_min_dedate_eff DATE := hr_api.g_eot; --
370: l_aact_min_dpdate DATE := hr_api.g_eot; --Overall min for asg action events types
371: cstdate DATE := hr_api.g_eot; -- Final placeholders for the final dates
372: rundate DATE := hr_api.g_eot;
373: paydate DATE := hr_api.g_eot;
374:
375: -- Holders for results from the interpreter package
376: l_de_det_tab_out pay_interpreter_pkg.t_detailed_output_table_type;
377: l_de_date_out pay_interpreter_pkg.t_proration_dates_table_type;

Line 536: select nvl(min(ppa.effective_date), hr_api.g_eot)

532: -->>> PHASE 4: We are only interested in 'effective dates' and although DATE_PROCESSED
533: --records eff_date in PPE, date_earned does exactly what it says on the tin.
534: --So we now fish out the eff_date corresponding to this date_earned.
535:
536: select nvl(min(ppa.effective_date), hr_api.g_eot)
537: into l_aact_min_dedate_eff
538: from pay_payroll_actions ppa,
539: pay_assignment_actions paa,
540: pay_assignment_actions paa_arch

Line 1392: if (l_date = hr_api.g_sot) then

1388: --
1389: -- bug 3265814
1390: --If looks like CC not in use then dont bother to look for modified
1391: --better to have global payroll level switch, but now compare date
1392: if (l_date = hr_api.g_sot) then
1393: -- l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1394: -- Bug 3576520: Repeating the special case for the Cheque Writer.
1395: if ( p_action_type in ('M', 'H' )) then
1396: open c_is_voided( p_assignment_action_id ) ;