DBA Data[Home] [Help]

APPS.SSP_PAD_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 53: ssp_smp_support_pkg.element_input_value_id

49: to_number(ele1.element_information6) /100 SPP_RATE,
50: to_number(ele1.element_information7) /100 RECOVERY_RATE,
51: to_number(ele1.element_information8) STANDARD_RATE,
52: to_number(ele1.element_information9) *7 LATEST_END_OF_PPP,
53: ssp_smp_support_pkg.element_input_value_id
54: (ele1.element_type_id,
55: c_rate_name) RATE_ID,
56: ssp_smp_support_pkg.element_input_value_id
57: (ele1.element_type_id,

Line 56: ssp_smp_support_pkg.element_input_value_id

52: to_number(ele1.element_information9) *7 LATEST_END_OF_PPP,
53: ssp_smp_support_pkg.element_input_value_id
54: (ele1.element_type_id,
55: c_rate_name) RATE_ID,
56: ssp_smp_support_pkg.element_input_value_id
57: (ele1.element_type_id,
58: c_week_commencing_name) WEEK_COMMENCING_ID,
59: ssp_smp_support_pkg.element_input_value_id
60: (ele1.element_type_id,

Line 59: ssp_smp_support_pkg.element_input_value_id

55: c_rate_name) RATE_ID,
56: ssp_smp_support_pkg.element_input_value_id
57: (ele1.element_type_id,
58: c_week_commencing_name) WEEK_COMMENCING_ID,
59: ssp_smp_support_pkg.element_input_value_id
60: (ele1.element_type_id,
61: c_amount_name) AMOUNT_ID,
62: ssp_smp_support_pkg.element_input_value_id
63: (ele1.element_type_id,

Line 62: ssp_smp_support_pkg.element_input_value_id

58: c_week_commencing_name) WEEK_COMMENCING_ID,
59: ssp_smp_support_pkg.element_input_value_id
60: (ele1.element_type_id,
61: c_amount_name) AMOUNT_ID,
62: ssp_smp_support_pkg.element_input_value_id
63: (ele1.element_type_id,
64: c_recoverable_amount_name) RECOVERABLE_AMOUNT_ID
65: from pay_element_types_f ele1
66: where ele1.element_name = p_element_name