DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on HR_API

Line 832: l_min_run_eff_date := hr_api.g_eot;

828: /*Modified the code for the bug 12695674*/
829: /*Introduced the above begin end block for 14292634*/
830: --
831: if (l_min_run_eff_date is null) then
832: l_min_run_eff_date := hr_api.g_eot;
833: end if;
834: if (l_min_run_ear_date is null) then
835: l_min_run_ear_date := hr_api.g_eot;
836: end if;

Line 835: l_min_run_ear_date := hr_api.g_eot;

831: if (l_min_run_eff_date is null) then
832: l_min_run_eff_date := hr_api.g_eot;
833: end if;
834: if (l_min_run_ear_date is null) then
835: l_min_run_ear_date := hr_api.g_eot;
836: end if;
837: l_min_run_pro_date := least(l_min_run_eff_date, l_min_run_ear_date);
838: --
839: if (l_min_eff_date is null) then

Line 877: hr_api.g_eot,

873: if (p_adv_flag = 'N') then
874: --
875: open c_ele(p_assignment_id,
876: l_min_eff_date,
877: hr_api.g_eot,
878: p_event_group);
879: --
880: fetch c_ele bulk collect into
881: l_entry_id,

Line 889: hr_api.g_eot,

885: --
886: if (p_event_group is not null) then
887: open c_ele_adv(p_assignment_id,
888: l_min_eff_date,
889: hr_api.g_eot,
890: p_event_group);
891: --
892: fetch c_ele_adv bulk collect into
893: l_entry_id,

Line 902: hr_api.g_eot,

898: else
899: --
900: open c_ele_adv_neg(p_assignment_id,
901: l_min_eff_date,
902: hr_api.g_eot,
903: p_event_group);
904: --
905: fetch c_ele_adv_neg bulk collect into
906: l_entry_id,

Line 1303: l_start_date := hr_api.g_eot;

1299: and superseding_retro_asg_id is null;
1300: --
1301: exception
1302: when no_data_found then
1303: l_start_date := hr_api.g_eot;
1304: end;
1305: --
1306: pay_recorded_requests_pkg.get_recorded_date(
1307: p_process => 'RETRONOT_ASG',

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

1313: /* If this process has never run before for this
1314: assignment then we need to find the earliest
1315: date to run from.
1316: */
1317: if (l_min_creation_date = hr_api.g_sot) then
1318: select min(creation_date)
1319: into l_min_creation_date
1320: from pay_process_events
1321: where assignment_id = p_assignment_id