DBA Data[Home] [Help]

APPS.SSP_SMP_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 119: ssp_smp_support_pkg.element_input_value_id

115: ele1.element_information15 *7
116: STILLBIRTH_THRESHHOLD_WEEK,
117: ele1.element_information16
118: STANDARD_SMP_RATE,
119: ssp_smp_support_pkg.element_input_value_id
120: (ele1.element_type_id, c_rate_name) RATE_ID,
121: ssp_smp_support_pkg.element_input_value_id
122: (ele1.element_type_id, c_week_commencing_name)
123: WEEK_COMMENCING_ID,

Line 121: ssp_smp_support_pkg.element_input_value_id

117: ele1.element_information16
118: STANDARD_SMP_RATE,
119: ssp_smp_support_pkg.element_input_value_id
120: (ele1.element_type_id, c_rate_name) RATE_ID,
121: ssp_smp_support_pkg.element_input_value_id
122: (ele1.element_type_id, c_week_commencing_name)
123: WEEK_COMMENCING_ID,
124: ssp_smp_support_pkg.element_input_value_id
125: (ele1.element_type_id, c_amount_name) AMOUNT_ID,

Line 124: ssp_smp_support_pkg.element_input_value_id

120: (ele1.element_type_id, c_rate_name) RATE_ID,
121: ssp_smp_support_pkg.element_input_value_id
122: (ele1.element_type_id, c_week_commencing_name)
123: WEEK_COMMENCING_ID,
124: ssp_smp_support_pkg.element_input_value_id
125: (ele1.element_type_id, c_amount_name) AMOUNT_ID,
126: ssp_smp_support_pkg.element_input_value_id
127: (ele1.element_type_id, c_recoverable_amount_name)
128: RECOVERABLE_AMOUNT_ID

Line 126: ssp_smp_support_pkg.element_input_value_id

122: (ele1.element_type_id, c_week_commencing_name)
123: WEEK_COMMENCING_ID,
124: ssp_smp_support_pkg.element_input_value_id
125: (ele1.element_type_id, c_amount_name) AMOUNT_ID,
126: ssp_smp_support_pkg.element_input_value_id
127: (ele1.element_type_id, c_recoverable_amount_name)
128: RECOVERABLE_AMOUNT_ID
129: from pay_element_types_f ele1
130: where ele1.element_name = p_element_name