APPS.PY_SQWL_FORMULAS SQL Statements

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

Line: 4

 PROCEDURE insert_formula
 ( p_formula_name VARCHAR2 )
  IS
   p_formula_type_id number(9);

Line: 12

   SELECT formula_type_id
   INTO   p_formula_type_id
   FROM	  ff_formula_types
   WHERE  FORMULA_TYPE_NAME = 'Oracle Payroll';

Line: 19

   SELECT 'y'
   INTO l_exists
   FROM   ff_formulas_f
   WHERE formula_name = p_formula_name;

Line: 26

   INSERT INTO ff_formulas_f
     (formula_id,
      effective_start_date,
      effective_end_date,
      business_group_id,
      legislation_code,
      formula_type_id,
      formula_name,
      description,
      formula_text,
      sticky_flag)
   VALUES
     (ff_formulas_s.nextval,
      fnd_date.canonical_to_date('0001/01/01 00:00:00'),
      fnd_date.canonical_to_date('4712/12/31 23:59:59'),
      NULL,
      'US',
      p_formula_type_id,
      p_formula_name,
      NULL,
      NULL,
      NULL);

Line: 51

  END insert_formula;

Line: 57

    insert_formula('ICESA_TRANSMITTER');

Line: 58

    insert_formula('ICESA_BINFO');

Line: 59

    insert_formula('ICESA_EMPLOYER');

Line: 60

    insert_formula('ICESA_SUPPLEMENTAL');

Line: 61

    insert_formula('ICESA_TOTAL');

Line: 62

    insert_formula('ICESA_TOTAL2');

Line: 63

    insert_formula('ICESA_FINAL');

Line: 64

    insert_formula('SSA_SQWL_TRANSMITTER');

Line: 65

    insert_formula('SSA_SQWL_BINFO');

Line: 66

    insert_formula('SSA_SQWL_EMPLOYER');

Line: 67

    insert_formula('SSA_SQWL_SUPPLEMENTAL');

Line: 68

    insert_formula('SSA_SQWL_TOTAL');

Line: 69

    insert_formula('SSA_SQWL_FINAL');

Line: 70

    insert_formula('GASQWL_SUPPLEMENTAL');

Line: 71

    insert_formula('INSQWL_SUPPLEMENTAL');

Line: 72

    insert_formula('INSQWL_FINAL');

Line: 73

    insert_formula('NJSQWL_TRANSMITTER');

Line: 74

    insert_formula('NJSQWL_EMPLOYER');

Line: 75

    insert_formula('NJSQWL_SUPPLEMENTAL');

Line: 76

    insert_formula('NMSQWL_EMPLOYER');

Line: 77

    insert_formula('NMSQWL_SUPPLEMENTAL');

Line: 78

    insert_formula('NYSQWL_TRANSMITTER');

Line: 79

    insert_formula('NYSQWL_EMPLOYER');

Line: 80

    insert_formula('NYSQWL_EMPLOYEE');

Line: 81

    insert_formula('NYSQWL_TOTAL');

Line: 82

    insert_formula('NYSQWL_FINAL');

Line: 84

    insert_formula('NYSQWL_EMPLOYEE_JURISDICTION');

Line: 85

    insert_formula('NYSQWL_EMPLOYEE_TOTAL');

Line: 87

    insert_formula('OHSQWL_EMPLOYER');

Line: 88

    insert_formula('OHSQWL_EMPLOYEE');

Line: 89

    insert_formula('DUMMY_SQWL_EMPLOYER');

Line: 90

    insert_formula('DUMMY_SQWL_TRANSMITTER');

Line: 91

    insert_formula('DCSQWL_SUPPLEMENTAL');

Line: 92

    insert_formula('IDSQWL_SUPPLEMENTAL');

Line: 93

    insert_formula('PRSQWL_SUPPLEMENTAL');

Line: 94

    insert_formula('AKSQWL_EMPLOYEE');

Line: 95

    insert_formula('AKSQWL_TOTAL');

Line: 96

    insert_formula('IASQWL_EMPLOYER');

Line: 97

    insert_formula('IASQWL_SUPPLEMENTAL');

Line: 98

    insert_formula('IASQWL_TOTAL');

Line: 99

    insert_formula('IASQWL_FINAL');

Line: 100

    insert_formula('IASQWL_INTERMEDIATE_TOTAL');

Line: 101

    insert_formula('DUMMY_TIB4_TOTAL');

Line: 102

    insert_formula('DUMMY_TIB4_FINAL');

Line: 103

    insert_formula('DUMMY_TIB4_TRANSMITTER');

Line: 104

    insert_formula('NCTIB4_SUPPLEMENTAL');

Line: 105

    insert_formula('TIB4_SUPPLEMENTAL');

Line: 106

    insert_formula('NJTIB4_SUPPLEMENTAL');

Line: 107

    insert_formula('DUMMY_SQWL_TOTAL');

Line: 108

    insert_formula('DUMMY_SQWL_FINAL');

Line: 109

    insert_formula('FLSQWL_TRANSMITTER');

Line: 110

    insert_formula('FLSQWL_EMPLOYER');

Line: 111

    insert_formula('FLSQWL_SUPPLEMENTAL');

Line: 112

    insert_formula('FLSQWL_INTERMEDIATE_TOTAL');

Line: 113

    insert_formula('FLSQWL_TOTAL');

Line: 114

    insert_formula('FLSQWL_FINAL');

Line: 115

    insert_formula('SDSQWLD_EMPLOYER');

Line: 116

    insert_formula('SDSQWLD_SUPPLEMENTAL');

Line: 117

    insert_formula('WASQWL_EMPLOYER');

Line: 118

    insert_formula('WASQWL_SUPPLEMENTAL');

Line: 119

    insert_formula('WASQWL_FINAL');

Line: 120

    insert_formula('TIB4_DUMMY');

Line: 121

    insert_formula('TIB4_TRANSMITTER');

Line: 122

    insert_formula('TIB4_EMPLOYER');

Line: 123

    insert_formula('TIB4_EMPLOYEE');

Line: 124

    insert_formula('TIB4_BINFO');

Line: 125

    insert_formula('TIB4_TOTAL');

Line: 126

    insert_formula('TIB4_FINAL');

Line: 127

    insert_formula('TIB4_INTERMEDIATE_TOTAL');

Line: 128

    insert_formula('W2_TIB4_SUPPLEMENTAL');

Line: 129

    insert_formula('W2_HIGH_COMP');

Line: 130

    insert_formula('MDSQWLD_FINAL');

Line: 131

    insert_formula('MDSQWLD_SUPPLEMENTAL');

Line: 132

    insert_formula('CTSQWL_TOTAL');

Line: 133

    insert_formula('CT_SQWL_TOTAL_NP');

Line: 134

    insert_formula('CT_SQWL_SUPPLEMENTAL_NP');

Line: 135

    insert_formula('KY_DK_TRANSMITTER1');

Line: 136

    insert_formula('KY_DK_TRANSMITTER2');

Line: 137

    insert_formula('KY_DK_EMPLOYER1');

Line: 138

    insert_formula('KY_DK_EMPLOYER2');

Line: 139

    insert_formula('KY_DK_BINFO1');

Line: 140

    insert_formula('KY_DK_BINFO2');

Line: 141

    insert_formula('KY_DK_SUPPLEMENTAL1');

Line: 142

    insert_formula('KY_DK_SUPPLEMENTAL2');

Line: 143

    insert_formula('KY_DK_TOTAL1');

Line: 144

    insert_formula('GATIB4_TRANSMITTER');

Line: 145

    insert_formula('GATIB4_EMPLOYER');

Line: 146

    insert_formula('GATIB4_SUPPLEMENTAL');

Line: 147

    insert_formula('GATIB4_TOTAL');

Line: 148

    insert_formula('GATIB4_FINAL');

Line: 149

    insert_formula('NDSQWL_TRANSMITTER');