APPS.SSP_APAD_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 60: ssp_smp_support_pkg.element_input_value_id

56: to_number (ele1.element_information13) EARLIEST_START_MOM_DEATH_ASPPP,
57: to_number (ele1.element_information14) ASPP_NOTICE_REQUIREMENT,
58: to_number (ele1.element_information15) ASPP_CHANGE_NOTICE_REQUIREMENT,
59: to_number (ele1.element_information16) *7 DEATH_OF_CHILD_WEEK,
60: ssp_smp_support_pkg.element_input_value_id
61: (ele1.element_type_id, c_rate_name)
62: RATE_ID,
63: ssp_smp_support_pkg.element_input_value_id
64: (ele1.element_type_id, c_week_commencing_name)

Line 63: ssp_smp_support_pkg.element_input_value_id

59: to_number (ele1.element_information16) *7 DEATH_OF_CHILD_WEEK,
60: ssp_smp_support_pkg.element_input_value_id
61: (ele1.element_type_id, c_rate_name)
62: RATE_ID,
63: ssp_smp_support_pkg.element_input_value_id
64: (ele1.element_type_id, c_week_commencing_name)
65: WEEK_COMMENCING_ID,
66: ssp_smp_support_pkg.element_input_value_id
67: (ele1.element_type_id, c_amount_name)

Line 66: ssp_smp_support_pkg.element_input_value_id

62: RATE_ID,
63: ssp_smp_support_pkg.element_input_value_id
64: (ele1.element_type_id, c_week_commencing_name)
65: WEEK_COMMENCING_ID,
66: ssp_smp_support_pkg.element_input_value_id
67: (ele1.element_type_id, c_amount_name)
68: AMOUNT_ID,
69: ssp_smp_support_pkg.element_input_value_id
70: (ele1.element_type_id, c_recoverable_amount_name)

Line 69: ssp_smp_support_pkg.element_input_value_id

65: WEEK_COMMENCING_ID,
66: ssp_smp_support_pkg.element_input_value_id
67: (ele1.element_type_id, c_amount_name)
68: AMOUNT_ID,
69: ssp_smp_support_pkg.element_input_value_id
70: (ele1.element_type_id, c_recoverable_amount_name)
71: RECOVERABLE_AMOUNT_ID
72: from pay_element_types_f ele1
73: where ele1.element_name = p_element_name