APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_BPL_PARAMETER

Line 405: l_start_date := hri_bpl_parameter.get_bis_global_start_date;

401: --
402: -- Initialize variables
403: --
404: l_end_of_time := hr_general.end_of_time;
405: l_start_date := hri_bpl_parameter.get_bis_global_start_date;
406: l_user_id := fnd_global.user_id;
407: l_current_time := SYSDATE;
408: --
409: INSERT /*+ APPEND */

Line 583: GREATEST(hri_bpl_parameter.get_bis_global_start_date

579: --
580: -- Gets all active person's
581: --
582: SELECT pos.person_id,
583: GREATEST(hri_bpl_parameter.get_bis_global_start_date
584: ,pos.date_start)
585: FROM per_periods_of_service pos,
586: hri_eq_sprvsr_hstry_chgs eq
587: WHERE eq.person_id=pos.person_id

Line 593: GREATEST(hri_bpl_parameter.get_bis_global_start_date

589: --
590: -- Gets all active placements
591: --
592: SELECT pop.person_id,
593: GREATEST(hri_bpl_parameter.get_bis_global_start_date
594: ,pop.date_start)
595: FROM per_periods_of_placement pop,
596: hri_eq_sprvsr_hstry_chgs eq
597: WHERE eq.person_id=pop.person_id

Line 852: l_start_date := hri_bpl_parameter.get_bis_global_start_date;

848: --
849: -- Initialize variables
850: --
851: l_end_of_time := hr_general.end_of_time;
852: l_start_date := hri_bpl_parameter.get_bis_global_start_date;
853: l_user_id := fnd_global.user_id;
854: l_current_time := SYSDATE;
855: --
856: INSERT /*+ APPEND */

Line 997: GREATEST(hri_bpl_parameter.get_bis_global_start_date

993: --
994: -- Gets all active person's
995: --
996: SELECT pos.person_id,
997: GREATEST(hri_bpl_parameter.get_bis_global_start_date
998: ,pos.date_start)
999: FROM per_periods_of_service pos,
1000: hri_eq_sprvsr_hstry_chgs eq
1001: WHERE eq.person_id=pos.person_id

Line 1007: GREATEST(hri_bpl_parameter.get_bis_global_start_date

1003: --
1004: -- Gets all active placements
1005: --
1006: SELECT pop.person_id,
1007: GREATEST(hri_bpl_parameter.get_bis_global_start_date
1008: ,pop.date_start)
1009: FROM per_periods_of_placement pop,
1010: hri_eq_sprvsr_hstry_chgs eq
1011: WHERE eq.person_id=pop.person_id