APPS.HRI_EDW_FCT_RECRUITMENT dependencies on HRI_EDW_FCT_RECRUITMENT

Line 1: PACKAGE BODY hri_edw_fct_recruitment AS

1: PACKAGE BODY hri_edw_fct_recruitment AS
2: /* $Header: hriefwrt.pkb 120.0 2005/05/29 07:10:44 appldev noship $ */
3:
4: g_instance_fk VARCHAR2(40); -- Holds data source
5:

Line 439: null,hri_edw_fct_recruitment.is_successful(

435: /* If the application has not ended it is neither successful nor unsuccessful */
436: to_date(null),0,
437: decode(apl.termination_reason,
438: /* If there is a termination reason it is not successful */
439: null,hri_edw_fct_recruitment.is_successful(
440: asg.assignment_id,
441: apl.person_id,
442: apl.date_end),
443: -1))) success_flag

Line 632: END hri_edw_fct_recruitment;

628:
629: SELECT instance_code INTO g_instance_fk
630: FROM edw_local_instance;
631:
632: END hri_edw_fct_recruitment;