DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on HR_API

Line 767: l_min_run_eff_date := hr_api.g_eot;

763: and paa.payroll_action_id = ppa.payroll_action_id
764: and ppa.action_type in ('Q', 'R', 'B', 'V');
765: --
766: if (l_min_run_eff_date is null) then
767: l_min_run_eff_date := hr_api.g_eot;
768: end if;
769: if (l_min_run_ear_date is null) then
770: l_min_run_ear_date := hr_api.g_eot;
771: end if;

Line 770: l_min_run_ear_date := hr_api.g_eot;

766: if (l_min_run_eff_date is null) then
767: l_min_run_eff_date := hr_api.g_eot;
768: end if;
769: if (l_min_run_ear_date is null) then
770: l_min_run_ear_date := hr_api.g_eot;
771: end if;
772: l_min_run_pro_date := least(l_min_run_eff_date, l_min_run_ear_date);
773: --
774: if (l_min_eff_date is null) then

Line 812: hr_api.g_eot,

808: if (p_adv_flag = 'N') then
809: --
810: open c_ele(p_assignment_id,
811: l_min_eff_date,
812: hr_api.g_eot,
813: p_event_group);
814: --
815: fetch c_ele bulk collect into
816: l_entry_id,

Line 824: hr_api.g_eot,

820: --
821: if (p_event_group is not null) then
822: open c_ele_adv(p_assignment_id,
823: l_min_eff_date,
824: hr_api.g_eot,
825: p_event_group);
826: --
827: fetch c_ele_adv bulk collect into
828: l_entry_id,

Line 837: hr_api.g_eot,

833: else
834: --
835: open c_ele_adv_neg(p_assignment_id,
836: l_min_eff_date,
837: hr_api.g_eot,
838: p_event_group);
839: --
840: fetch c_ele_adv_neg bulk collect into
841: l_entry_id,

Line 1238: l_start_date := hr_api.g_eot;

1234: and superseding_retro_asg_id is null;
1235: --
1236: exception
1237: when no_data_found then
1238: l_start_date := hr_api.g_eot;
1239: end;
1240: --
1241: pay_recorded_requests_pkg.get_recorded_date(
1242: p_process => 'RETRONOT_ASG',

Line 1252: if (l_min_creation_date = hr_api.g_sot) then

1248: /* If this process has never run before for this
1249: assignment then we need to find the earliest
1250: date to run from.
1251: */
1252: if (l_min_creation_date = hr_api.g_sot) then
1253: select min(creation_date)
1254: into l_min_creation_date
1255: from pay_process_events
1256: where assignment_id = p_assignment_id