DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on HR_API

Line 557: AND P_vac_date_to > nvl(HOU.date_to, hr_api.g_eot);

553: SELECT date_to
554: FROM HR_ORGANIZATION_UNITS HOU
555: WHERE HOU.ORGANIZATION_ID = P_organization_id
556: AND HOU.business_group_id + 0 = P_Business_group_id
557: AND P_vac_date_to > nvl(HOU.date_to, hr_api.g_eot);
558:
559: --
560: v_dummy NUMBER(1);
561: v_date Date;

Line 1272: l_end_of_time date := hr_api.g_eot;

1268: X_Attribute18 VARCHAR2,
1269: X_Attribute19 VARCHAR2,
1270: X_Attribute20 VARCHAR2
1271: ) IS
1272: l_end_of_time date := hr_api.g_eot;
1273: BEGIN
1274: --
1275: IF X_Organization_Id is not null then
1276: PER_VACANCIES_PKG.D_to_updt_org_chk(P_Business_group_id => X_Business_group_id