DBA Data[Home] [Help]

APPS.GHR_NFC_POSITION_EXTRACTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

                               ,last_update_date               DATE
                               ,creation_date                  DATE);
Line: 27

 SELECT pdf.segment3 NFC_Agency_Code,
        pdf.segment4 Personnel_Office_ID,
        pdf.segment7 Grade
   FROM hr_all_positions_f pos, per_position_definitions pdf
  WHERE pos.position_definition_id = pdf.position_definition_id
    AND pos.position_id = c_position_id
    AND c_effective_date between pos.effective_start_date and pos.effective_end_date;
Line: 42

    SELECT 'X'
      FROM  hr_all_positions_f hap
     WHERE  hap.position_id =cp_position_id
       AND  cp_effective_date BETWEEN hap.effective_start_date
                              AND hap.effective_end_date
       AND  hap.business_group_id =cp_business_group_id
       AND  hap.information6 is null;
Line: 56

    SELECT 'X'
      FROM  hr_all_positions_f hap
     WHERE  hap.position_id =cp_position_id
       AND  cp_effective_date BETWEEN hap.effective_start_date
                              AND hap.effective_end_date
       AND  hap.business_group_id =cp_business_group_id
       AND  hap.information6 is not null;
Line: 68

     SELECT argument7, --Tranmission Type
            argument8,  -- Date Criteria
	    argument12,  -- From Date
	    argument13,  -- To Date
            argument14,  -- Agency Code
	    argument15, -- Personnel Office Id
	    argument16, -- Transmission Indicator
	    argument17, -- Signon Identification
	    argument18, -- User_ID
	    argument19, -- dept Code
	    argument20, -- Payroll_id
	    argument21 -- Notify
       FROM fnd_concurrent_requests
      WHERE request_id = c_req_id;
Line: 89

    SELECT bba.request_id
      FROM ben_benefit_actions bba
     WHERE bba.pl_id = c_ext_rslt_id
       AND bba.pgm_id = c_ext_dfn_id
       AND bba.business_group_id = c_business_group_id;
Line: 100

    SELECT rcd.ext_rcd_id
     FROM  ben_ext_rcd         rcd
         ,ben_ext_rcd_in_file rin
         ,ben_ext_dfn dfn
    WHERE dfn.ext_dfn_id   = ben_ext_thread.g_ext_dfn_id
      AND rin.ext_file_id  = dfn.ext_file_id
      AND rin.hide_flag    = c_hide_flag     -- Y=Hidden, N=Not Hidden
      AND rin.ext_rcd_id   = rcd.ext_rcd_id
      AND rcd.rcd_type_cd  = c_rcd_type_cd;  --S- Sub Header D=Detail,H=Header,F=Footer
Line: 116

   SELECT *
     FROM ben_ext_rslt_dtl dtl
    WHERE dtl.ext_rslt_id = c_ext_rslt_id
      AND dtl.VAL_71      = c_position_id
      AND dtl.ext_rcd_id  = c_ext_dtl_rcd_id;
Line: 128

   SELECT *
     FROM ben_ext_rslt_dtl dtl
    WHERE dtl.ext_rslt_id = c_ext_rslt_id
      AND dtl.VAL_71      = c_position_id
      AND dtl.ext_rslt_dtl_id  = c_ext_rslt_dtl_id;
Line: 140

   SELECT dtl.val_71 --Position_id
     FROM ben_ext_rslt_dtl dtl
    WHERE dtl.ext_rslt_id = c_ext_rslt_id
      AND dtl.VAL_45      = 'A'	    --Function Code
      AND dtl.ext_rcd_id  = c_ext_dtl_rcd_id
      AND dtl.VAL_49 is not null; --Incumbent SSN
Line: 157

   SELECT rslt.ext_rslt_dtl_id
     FROM ben_ext_rcd         rcd
         ,ben_ext_rcd_in_file rin
         ,ben_ext_dfn dfn
         ,ben_ext_rslt_dtl rslt
    WHERE dfn.ext_dfn_id   = ben_ext_thread.g_ext_dfn_id
      AND rin.ext_file_id  = dfn.ext_file_id
      AND rin.hide_flag    = c_ext_hide_flag     -- Y=Hidden, N=Not Hidden
      AND rin.ext_rcd_id   = rcd.ext_rcd_id
      AND rslt.EXT_RCD_ID  = rcd.ext_rcd_id
      AND rcd.rcd_type_cd  = c_rcd_type_cd  --S- Sub Header D=Detail,H=Header,F=Footer
      and rslt.val_71 =c_position_id
      and rslt.ext_rslt_id =c_ext_rslt_id
      and rslt.business_group_id =c_business_group_id;
Line: 189

SELECT ptp.period_num
 FROM  per_time_periods ptp
WHERE   ptp.payroll_id=p_payroll_id
  AND  cp_effective_date BETWEEN ptp.start_date
                             AND ptp.end_date;
Line: 226

SELECT ptp.period_num
      ,ptp.start_date start_date
      ,ptp.end_date   end_date
      ,paa.position_id
 FROM  per_time_periods ptp
      ,per_all_assignments_f paa
WHERE  paa.assignment_id = cp_assignment_id
  AND  paa.business_group_id = cp_business_group_id
  AND  cp_effective_date BETWEEN paa.effective_start_date
                             AND paa.effective_end_date
  AND  paa.payroll_id  =ptp.payroll_id
  AND  cp_effective_date BETWEEN ptp.start_date
                             AND ptp.end_date;
Line: 407

   SELECT pea.ext_dfn_id      ext_dfn_id
     FROM pqp_extract_attributes pea
    WHERE pea.ext_dfn_name  = c_extract_name;
Line: 554

  update ben_ext_rslt_dtl
  set val_01                 = p_val_tab(1)
     ,val_02                 = p_val_tab(2)
     ,val_03                 = p_val_tab(3)
     ,val_04                 = p_val_tab(4)
     ,val_05                 = p_val_tab(5)
     ,val_06                 = p_val_tab(6)
     ,val_07                 = p_val_tab(7)
     ,val_08                 = p_val_tab(8)
     ,val_09                 = p_val_tab(9)
     ,val_10                 = p_val_tab(10)
     ,val_11                 = p_val_tab(11)
     ,val_12                 = p_val_tab(12)
     ,val_13                 = p_val_tab(13)
     ,val_14                 = p_val_tab(14)
     ,val_15                 = p_val_tab(15)
     ,val_16                 = p_val_tab(16)
     ,val_17                 = p_val_tab(17)
     ,val_19                 = p_val_tab(19)
     ,val_18                 = p_val_tab(18)
     ,val_20                 = p_val_tab(20)
     ,val_21                 = p_val_tab(21)
     ,val_22                 = p_val_tab(22)
     ,val_23                 = p_val_tab(23)
     ,val_24                 = p_val_tab(24)
     ,val_25                 = p_val_tab(25)
     ,val_26                 = p_val_tab(26)
     ,val_27                 = p_val_tab(27)
     ,val_28                 = p_val_tab(28)
     ,val_29                 = p_val_tab(29)
     ,val_30                 = p_val_tab(30)
     ,val_31                 = p_val_tab(31)
     ,val_32                 = p_val_tab(32)
     ,val_33                 = p_val_tab(33)
     ,val_34                 = p_val_tab(34)
     ,val_35                 = p_val_tab(35)
     ,val_36                 = p_val_tab(36)
     ,val_37                 = p_val_tab(37)
     ,val_38                 = p_val_tab(38)
     ,val_39                 = p_val_tab(39)
     ,val_40                 = p_val_tab(40)
     ,val_41                 = p_val_tab(41)
     ,val_42                 = p_val_tab(42)
     ,val_43                 = p_val_tab(43)
     ,val_44                 = p_val_tab(44)
     ,val_45                 = p_val_tab(45)
     ,val_46                 = p_val_tab(46)
     ,val_47                 = p_val_tab(47)
     ,val_48                 = p_val_tab(48)
     ,val_49                 = p_val_tab(49)
     ,val_50                 = p_val_tab(50)
     ,val_51                 = p_val_tab(51)
     ,val_52                 = p_val_tab(52)
     ,val_53                 = p_val_tab(53)
     ,val_54                 = p_val_tab(54)
     ,val_55                 = p_val_tab(55)
     ,val_56                 = p_val_tab(56)
     ,val_57                 = p_val_tab(57)
     ,val_58                 = p_val_tab(58)
     ,val_59                 = p_val_tab(59)
     ,val_60                 = p_val_tab(60)
     ,val_61                 = p_val_tab(61)
     ,val_62                 = p_val_tab(62)
     ,val_63                 = p_val_tab(63)
     ,val_64                 = p_val_tab(64)
     ,val_65                 = p_val_tab(65)
     ,val_66                 = p_val_tab(66)
     ,val_67                 = p_val_tab(67)
     ,val_68                 = p_val_tab(68)
     ,val_69                 = p_val_tab(69)
     ,val_70                 = p_val_tab(70)
     ,val_71                 = p_val_tab(71)
     ,val_72                 = p_val_tab(72)
     ,val_73                 = p_val_tab(73)
     ,val_74                 = p_val_tab(74)
     ,val_75                 = p_val_tab(75)
     ,object_version_number  = p_dtl_rec.object_version_number
     --,thrd_sort_val          = p_dtl_rec.thrd_sort_val
  where ext_rslt_dtl_id = p_dtl_rec.ext_rslt_dtl_id;
Line: 660

  select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;
Line: 661

  insert into ben_ext_rslt_dtl
  (ext_rslt_dtl_id
  ,ext_rslt_id
  ,business_group_id
  ,ext_rcd_id
  ,person_id
  ,val_01
  ,val_02
  ,val_03
  ,val_04
  ,val_05
  ,val_06
  ,val_07
  ,val_08
  ,val_09
  ,val_10
  ,val_11
  ,val_12
  ,val_13
  ,val_14
  ,val_15
  ,val_16
  ,val_17
  ,val_19
  ,val_18
  ,val_20
  ,val_21
  ,val_22
  ,val_23
  ,val_24
  ,val_25
  ,val_26
  ,val_27
  ,val_28
  ,val_29
  ,val_30
  ,val_31
  ,val_32
  ,val_33
  ,val_34
  ,val_35
  ,val_36
  ,val_37
  ,val_38
  ,val_39
  ,val_40
  ,val_41
  ,val_42
  ,val_43
  ,val_44
  ,val_45
  ,val_46
  ,val_47
  ,val_48
  ,val_49
  ,val_50
  ,val_51
  ,val_52
  ,val_53
  ,val_54
  ,val_55
  ,val_56
  ,val_57
  ,val_58
  ,val_59
  ,val_60
  ,val_61
  ,val_62
  ,val_63
  ,val_64
  ,val_65
  ,val_66
  ,val_67
  ,val_68
  ,val_69
  ,val_70
  ,val_71
  ,val_72
  ,val_73
  ,val_74
  ,val_75
  /*,val_76
  ,val_77
  ,val_78
  ,val_79
  ,val_80
  ,val_81
  ,val_82
  ,val_83
  ,val_84
  ,val_85
  ,val_86
  ,val_87
  ,val_88
  ,val_89
  ,val_90
  ,val_91
  ,val_92
  ,val_93
  ,val_94
  ,val_95
  ,val_96
  ,val_97
  ,val_98
  ,val_99
  ,val_100
  ,val_101
  ,val_102
  ,val_103
  ,val_104
  ,val_105
  ,val_106
  ,val_107
  ,val_108
  ,val_109
  ,val_110
  ,val_111
  ,val_112
  ,val_113
  ,val_114
  ,val_115
  ,val_116
  ,val_117
  ,val_118
  ,val_119
  ,val_120
  ,val_121
  ,val_122
  ,val_123
  ,val_124
  ,val_125
  ,val_126
  ,val_127
  ,val_128
  ,val_129
  ,val_130
  ,val_131
  ,val_132
  ,val_133
  ,val_134
  ,val_135
  ,val_136
  ,val_137
  ,val_138
  ,val_139
  ,val_140
  ,val_141
  ,val_142
  ,val_143
  ,val_144
  ,val_145
  ,val_146
  ,val_147
  ,val_148
  ,val_149
  ,val_150 */
  ,created_by
  ,creation_date
  ,last_update_date
  ,last_updated_by
  ,last_update_login
  ,program_application_id
  ,program_id
  ,program_update_date
  ,request_id
  ,object_version_number
  ,prmy_sort_val
  ,scnd_sort_val
  ,thrd_sort_val
  ,trans_seq_num
  ,rcrd_seq_num
  )
  values
  (p_dtl_rec.ext_rslt_dtl_id
  ,p_dtl_rec.ext_rslt_id
  ,p_dtl_rec.business_group_id
  ,p_dtl_rec.ext_rcd_id
  ,p_dtl_rec.person_id
  ,p_val_tab(1)
  ,p_val_tab(2)
  ,p_val_tab(3)
  ,p_val_tab(4)
  ,p_val_tab(5)
  ,p_val_tab(6)
  ,p_val_tab(7)
  ,p_val_tab(8)
  ,p_val_tab(9)
  ,p_val_tab(10)
  ,p_val_tab(11)
  ,p_val_tab(12)
  ,p_val_tab(13)
  ,p_val_tab(14)
  ,p_val_tab(15)
  ,p_val_tab(16)
  ,p_val_tab(17)
  ,p_val_tab(19)
  ,p_val_tab(18)
  ,p_val_tab(20)
  ,p_val_tab(21)
  ,p_val_tab(22)
  ,p_val_tab(23)
  ,p_val_tab(24)
  ,p_val_tab(25)
  ,p_val_tab(26)
  ,p_val_tab(27)
  ,p_val_tab(28)
  ,p_val_tab(29)
  ,p_val_tab(30)
  ,p_val_tab(31)
  ,p_val_tab(32)
  ,p_val_tab(33)
  ,p_val_tab(34)
  ,p_val_tab(35)
  ,p_val_tab(36)
  ,p_val_tab(37)
  ,p_val_tab(38)
  ,p_val_tab(39)
  ,p_val_tab(40)
  ,p_val_tab(41)
  ,p_val_tab(42)
  ,p_val_tab(43)
  ,p_val_tab(44)
  ,p_val_tab(45)
  ,p_val_tab(46)
  ,p_val_tab(47)
  ,p_val_tab(48)
  ,p_val_tab(49)
  ,p_val_tab(50)
  ,p_val_tab(51)
  ,p_val_tab(52)
  ,p_val_tab(53)
  ,p_val_tab(54)
  ,p_val_tab(55)
  ,p_val_tab(56)
  ,p_val_tab(57)
  ,p_val_tab(58)
  ,p_val_tab(59)
  ,p_val_tab(60)
  ,p_val_tab(61)
  ,p_val_tab(62)
  ,p_val_tab(63)
  ,p_val_tab(64)
  ,p_val_tab(65)
  ,p_val_tab(66)
  ,p_val_tab(67)
  ,p_val_tab(68)
  ,p_val_tab(69)
  ,p_val_tab(70)
  ,p_val_tab(71)
  ,p_val_tab(72)
  ,p_val_tab(73)
  ,p_val_tab(74)
  ,p_val_tab(75)
  /*,p_val_tab(76)
  ,p_val_tab(77)
  ,p_val_tab(78)
  ,p_val_tab(79)
  ,p_val_tab(80)
  ,p_val_tab(81)
  ,p_val_tab(82)
  ,p_val_tab(83)
  ,p_val_tab(84)
  ,p_val_tab(85)
  ,p_val_tab(86)
  ,p_val_tab(87)
  ,p_val_tab(88)
  ,p_val_tab(89)
  ,p_val_tab(90)
  ,p_val_tab(91)
  ,p_val_tab(92)
  ,p_val_tab(93)
  ,p_val_tab(94)
  ,p_val_tab(95)
  ,p_val_tab(96)
  ,p_val_tab(97)
  ,p_val_tab(98)
  ,p_val_tab(99)
  ,p_val_tab(100)
  ,p_val_tab(101)
  ,p_val_tab(102)
  ,p_val_tab(103)
  ,p_val_tab(104)
  ,p_val_tab(105)
  ,p_val_tab(106)
  ,p_val_tab(107)
  ,p_val_tab(108)
  ,p_val_tab(109)
  ,p_val_tab(110)
  ,p_val_tab(111)
  ,p_val_tab(112)
  ,p_val_tab(113)
  ,p_val_tab(114)
  ,p_val_tab(115)
  ,p_val_tab(116)
  ,p_val_tab(117)
  ,p_val_tab(118)
  ,p_val_tab(119)
  ,p_val_tab(120)
  ,p_val_tab(121)
  ,p_val_tab(122)
  ,p_val_tab(123)
  ,p_val_tab(124)
  ,p_val_tab(125)
  ,p_val_tab(126)
  ,p_val_tab(127)
  ,p_val_tab(128)
  ,p_val_tab(129)
  ,p_val_tab(130)
  ,p_val_tab(131)
  ,p_val_tab(132)
  ,p_val_tab(133)
  ,p_val_tab(134)
  ,p_val_tab(135)
  ,p_val_tab(136)
  ,p_val_tab(137)
  ,p_val_tab(138)
  ,p_val_tab(139)
  ,p_val_tab(140)
  ,p_val_tab(141)
  ,p_val_tab(142)
  ,p_val_tab(143)
  ,p_val_tab(144)
  ,p_val_tab(145)
  ,p_val_tab(146)
  ,p_val_tab(147)
  ,p_val_tab(148)
  ,p_val_tab(149)
  ,p_val_tab(150)*/
  ,p_dtl_rec.created_by
  ,p_dtl_rec.creation_date
  ,p_dtl_rec.last_update_date
  ,p_dtl_rec.last_updated_by
  ,p_dtl_rec.last_update_login
  ,p_dtl_rec.program_application_id
  ,p_dtl_rec.program_id
  ,p_dtl_rec.program_update_date
  ,p_dtl_rec.request_id
  ,p_dtl_rec.object_version_number
  ,p_dtl_rec.prmy_sort_val
  ,p_dtl_rec.scnd_sort_val
  ,p_dtl_rec.thrd_sort_val
  ,p_dtl_rec.trans_seq_num
  ,p_dtl_rec.rcrd_seq_num
  );
Line: 1026

     p_pos_extra_info(1).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1033

     p_pos_extra_info(2).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1040

     p_pos_extra_info(3).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1047

     p_pos_extra_info(4).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1054

     p_pos_extra_info(5).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1061

     p_pos_extra_info(6).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1068

     p_pos_extra_info(7).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1075

     p_pos_extra_info(8).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1082

     p_pos_extra_info(9).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1089

     p_pos_extra_info(10).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1096

     p_pos_extra_info(11).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1103

     p_pos_extra_info(12).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1110

     p_pos_extra_info(13).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1117

     p_pos_extra_info(14).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1124

     p_pos_extra_info(15).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1131

     p_pos_extra_info(16).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1138

     p_pos_extra_info(17).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1145

     p_pos_extra_info(18).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1152

     p_pos_extra_info(19).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1159

     p_pos_extra_info(20).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1166

     p_pos_extra_info(21).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1173

     p_pos_extra_info(22).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1180

     p_pos_extra_info(23).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1187

     p_pos_extra_info(24).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1194

     p_pos_extra_info(25).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1201

     p_pos_extra_info(26).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1208

     p_pos_extra_info(27).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1215

     p_pos_extra_info(28).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1223

     p_pos_extra_info(29).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1230

     p_pos_extra_info(30).last_update_date          :=p_posi_extra_info.last_update_date;
Line: 1747

   SELECT hap.effective_start_date
         ,hap.effective_end_date
         ,permanent_temporary_flag
         ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
         ,hap.location_id
     FROM hr_all_positions_f hap
    WHERE cp_eff_date BETWEEN hap.effective_start_date
                      AND hap.effective_end_date
      AND hap.position_id=p_position_id
      AND hap.business_group_id = p_business_group_id;
Line: 1773

   SELECT hap.effective_start_date st_date
         ,hap.effective_end_date   e_date
         ,hap.creation_date
         ,HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status
     FROM hr_all_positions_f hap
    WHERE hap.position_id=p_position_id
      AND hap.business_group_id = p_business_group_id
      AND hap.effective_start_date <= p_eff_dt
    ORDER BY hap.effective_start_date asc;
Line: 1787

	SELECT 1
    FROM ghr_pa_history hist
    WHERE hist.information1 = to_char(c_position_id)
    AND hist.table_name = 'HR_ALL_POSITIONS_F'
    AND (hist.effective_date BETWEEN c_eff_start_date AND c_eff_end_date
	OR TRUNC(hist.process_date) BETWEEN TRUNC(c_eff_start_date) AND TRUNC(c_eff_end_date))
	AND EXISTS(
	   SELECT 1 FROM ghr_pa_history hist1
        WHERE hist1.information1 = to_char(c_position_id)
        AND hist1.table_name = 'HR_ALL_POSITIONS_F'
        AND hist1.effective_date > hist.effective_date
		and hist.pa_history_id > hist1.pa_history_id
        AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(hist1.information24) = 'Eliminated') ;
Line: 2054

   SELECT hap.information6 mrn
     FROM  hr_all_positions_f hap
    WHERE  hap.position_id =cp_position_id
      AND  cp_effective_date BETWEEN hap.effective_start_date
                             AND hap.effective_end_date
      AND  hap.business_group_id =cp_business_group_id;
Line: 2150

    SELECT pg.name
      FROM per_grades  pg
       WHERE pg.grade_id=cp_grade_id
       AND pg.business_group_id = cp_business_group_id;
Line: 2317

    SELECT job.name
      FROM hr_all_positions_f pos,
           per_jobs job
     WHERE pos.position_id = p_position_id
       AND p_date_effective BETWEEN pos.effective_start_date
       AND pos.effective_end_date
       AND job.job_id      = pos.job_id;
Line: 2459

     SELECT poei_information3 Int_Series_Code
           ,poei_information4 Int_Title_Code
           ,poei_information6 Int_Title_Suffix
           ,poei_information5 Int_Title_Prefix
      FROM per_position_extra_info pei
      WHERE pei.position_id  = cp_position_id
        AND rownum <=10
	AND information_type = 'GHR_US_POSITION_INTERDISC'
        ORDER BY poei_information3;
Line: 2539

   SELECT hap.effective_start_date
         ,hap.effective_end_date
     FROM hr_all_positions_f hap
    WHERE hap.position_id = cp_position_id
      AND (cp_effective_end_date BETWEEN hap.effective_start_date
                               AND hap.effective_end_date
       OR hap.effective_start_date BETWEEN cp_effective_start_date
                               AND cp_effective_end_date
       OR hap.effective_end_date BETWEEN cp_effective_start_date
                               AND cp_effective_end_date)
      AND hap.business_group_id   = cp_business_group_id
    ORDER BY hap.effective_end_date;
Line: 2566

     l_master_data_temp.delete;
Line: 2569

       g_master_data.delete;
Line: 2573

        g_int_data.delete;
Line: 2577

       g_int_metadata.delete;
Line: 2717

       g_master_data.delete;
Line: 2788

                l_pqp_record_values.delete;
Line: 2837

           l_pqp_record_values.delete;
Line: 2945

      SELECT 'X'
        FROM per_all_assignments_f
       WHERE position_id       = c_position_id
         AND business_group_id = c_business_group_id
	 AND c_effective_date BETWEEN effective_start_date
	 AND effective_end_date;
Line: 3131

    SELECT position_id
     FROM  per_all_assignments_f
    WHERE  assignment_id = c_assignment_id
      AND  business_group_id = c_business_group_id
      AND  c_effective_date BETWEEN effective_start_date
      AND  effective_end_date;
Line: 3319

    SELECT period_num
      FROM per_time_periods
     WHERE payroll_id = c_payroll_id
       AND c_effective_date BETWEEN start_date
                                AND end_date;
Line: 3328

    SELECT bba.request_id
      FROM ben_benefit_actions bba
     WHERE bba.pl_id = c_ext_rslt_id
       AND bba.pgm_id = c_ext_dfn_id ;
Line: 3334

     SELECT argument4, --Business Group ID
            argument5, --User ID
	    argument6, --dept Code
	    argument7, --Agency Code
	    argument8 --POI
       FROM fnd_concurrent_requests
      WHERE request_id = c_req_id;
Line: 3423

 SELECT POSITION_ID,
        susp_function_cd,
	record_id,
	result_dtl_id,
	result_id
   FROM ghr_pos_interface_err_dtls;
Line: 3434

SELECT dtl.ext_rslt_dtl_id
      ,dtl.val_45 --Detail function code
      ,dtl.val_26 --Open Position function code
  FROM ben_ext_rslt_dtl dtl
 WHERE dtl.ext_rslt_id = c_ext_rslt_id
   AND dtl.VAL_71      = c_position_id
   AND dtl.ext_rcd_id  = c_ext_dtl_rcd_id;
Line: 3443

   SELECT Count(dtl.ext_rslt_dtl_id)
     FROM ben_ext_rslt_dtl dtl
    WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
    AND dtl.ext_rcd_id NOT IN(c_ext_rcd_id);
Line: 3453

  select distinct paf.position_id
    from per_all_assignments_f paf
        ,ben_ext_rslt_dtl dtl
   where dtl.val_71 = paf.position_id
     and paf.business_group_id = c_business_group_id
     and paf.business_group_id = dtl.business_group_id
     and paf.person_id         = dtl.person_id
     and dtl.ext_rslt_id       = c_ext_rslt_id
     and dtl.VAL_45      = 'C'
     and dtl.ext_rcd_id  = c_ext_rcd_id
     and dtl.VAL_49 is not null
     and paf.effective_start_date = c_effective_date;
Line: 3468

   SELECT dtl.*
     FROM ben_ext_rcd         rcd
         ,ben_ext_rcd_in_file rin
         ,ben_ext_dfn dfn
         ,ben_ext_rslt_dtl dtl
    WHERE dfn.ext_dfn_id   = c_ext_dfn_id
      AND rin.ext_file_id  = dfn.ext_file_id
      AND rin.hide_flag    = 'N'     -- Y=Hidden, N=Not Hidden
      AND rin.ext_rcd_id   = rcd.ext_rcd_id
      AND rcd.rcd_type_cd  in ('S','D')
      AND rcd.ext_rcd_id  = dtl.ext_rcd_id
      and dtl.ext_rslt_id = c_ext_rslt_id
      ORDER BY dtl.val_02 desc;
Line: 3551

	  -- then delete it from detail record
          DELETE
            FROM ben_ext_rslt_dtl
           WHERE ext_rcd_id        = g_ext_dtl_rcd_id
             AND ext_rslt_id       = Ben_Ext_Thread.g_ext_rslt_id
             AND business_group_id = p_business_group_id
             AND val_71 = l_ext_position_id;
Line: 3595

	  -- then delete it from detail record
          DELETE
            FROM ben_ext_rslt_dtl
           WHERE ext_rcd_id        = g_ext_dtl_rcd_id
             AND ext_rslt_id       = Ben_Ext_Thread.g_ext_rslt_id
             AND business_group_id = p_business_group_id
             AND val_71 = l_ext_position_id;
Line: 3612

    DELETE
      FROM ben_ext_rslt_dtl
     WHERE ext_rcd_id        = csr_rcd_rec_t.ext_rcd_id
       AND ext_rslt_id       = Ben_Ext_Thread.g_ext_rslt_id
       AND business_group_id = p_business_group_id
       AND val_52 = 'FOUND';
Line: 3632

       UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
        WHERE ext_rcd_id       = csr_header_rcd_id.ext_rcd_id
          AND ext_rslt_id      = Ben_Ext_Thread.g_ext_rslt_id
          AND business_group_id= p_business_group_id;
Line: 3674

        UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
               ,group_val_01 = '   '
         WHERE ext_rcd_id       = l_main_rec.ext_rcd_id
           AND ext_rslt_id      = Ben_Ext_Thread.g_ext_rslt_id
           AND ext_rslt_dtl_id  = l_main_rec.ext_rslt_dtl_id
           AND business_group_id= p_business_group_id;
Line: 3681

        UPDATE ben_ext_rslt_dtl set PRMY_SORT_VAL = l_new_rec.prmy_sort_val
         WHERE ext_rcd_id       = l_main_rec.ext_rcd_id
           AND ext_rslt_id      = Ben_Ext_Thread.g_ext_rslt_id
           AND ext_rslt_dtl_id  = l_main_rec.ext_rslt_dtl_id
           AND business_group_id= p_business_group_id;