DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on SSP_SMP_SUPPORT_PKG

Line 77: ssp_smp_support_pkg.element_input_value_id

73: to_number (element_information4) WAITING_DAYS,
74: to_number (element_information5) PIW_THRESHHOLD,
75: to_number (element_information6) MAXIMUM_LINKED_PIW_YEARS,
76: to_number (element_information7) PERCENTAGE_THRESHHOLD,
77: ssp_smp_support_pkg.element_input_value_id
78: (element_type_id, c_SSP_days_due_name) SSP_DAYS_DUE_ID,
79: ssp_smp_support_pkg.element_input_value_id
80: (element_type_id, c_amount_name) AMOUNT_ID,
81: ssp_smp_support_pkg.element_input_value_id

Line 79: ssp_smp_support_pkg.element_input_value_id

75: to_number (element_information6) MAXIMUM_LINKED_PIW_YEARS,
76: to_number (element_information7) PERCENTAGE_THRESHHOLD,
77: ssp_smp_support_pkg.element_input_value_id
78: (element_type_id, c_SSP_days_due_name) SSP_DAYS_DUE_ID,
79: ssp_smp_support_pkg.element_input_value_id
80: (element_type_id, c_amount_name) AMOUNT_ID,
81: ssp_smp_support_pkg.element_input_value_id
82: (element_type_id, c_from_name) FROM_ID,
83: ssp_smp_support_pkg.element_input_value_id

Line 81: ssp_smp_support_pkg.element_input_value_id

77: ssp_smp_support_pkg.element_input_value_id
78: (element_type_id, c_SSP_days_due_name) SSP_DAYS_DUE_ID,
79: ssp_smp_support_pkg.element_input_value_id
80: (element_type_id, c_amount_name) AMOUNT_ID,
81: ssp_smp_support_pkg.element_input_value_id
82: (element_type_id, c_from_name) FROM_ID,
83: ssp_smp_support_pkg.element_input_value_id
84: (element_type_id, c_to_name) TO_ID,
85: ssp_smp_support_pkg.element_input_value_id

Line 83: ssp_smp_support_pkg.element_input_value_id

79: ssp_smp_support_pkg.element_input_value_id
80: (element_type_id, c_amount_name) AMOUNT_ID,
81: ssp_smp_support_pkg.element_input_value_id
82: (element_type_id, c_from_name) FROM_ID,
83: ssp_smp_support_pkg.element_input_value_id
84: (element_type_id, c_to_name) TO_ID,
85: ssp_smp_support_pkg.element_input_value_id
86: (element_type_id, c_rate_name) RATE_ID,
87: ssp_smp_support_pkg.element_input_value_id

Line 85: ssp_smp_support_pkg.element_input_value_id

81: ssp_smp_support_pkg.element_input_value_id
82: (element_type_id, c_from_name) FROM_ID,
83: ssp_smp_support_pkg.element_input_value_id
84: (element_type_id, c_to_name) TO_ID,
85: ssp_smp_support_pkg.element_input_value_id
86: (element_type_id, c_rate_name) RATE_ID,
87: ssp_smp_support_pkg.element_input_value_id
88: (element_type_id,c_withheld_days_name) WITHHELD_DAYS_ID,
89: ssp_smp_support_pkg.element_input_value_id

Line 87: ssp_smp_support_pkg.element_input_value_id

83: ssp_smp_support_pkg.element_input_value_id
84: (element_type_id, c_to_name) TO_ID,
85: ssp_smp_support_pkg.element_input_value_id
86: (element_type_id, c_rate_name) RATE_ID,
87: ssp_smp_support_pkg.element_input_value_id
88: (element_type_id,c_withheld_days_name) WITHHELD_DAYS_ID,
89: ssp_smp_support_pkg.element_input_value_id
90: (element_type_id, c_SSP_weeks_name) SSP_WEEKS_ID,
91: ssp_smp_support_pkg.element_input_value_id

Line 89: ssp_smp_support_pkg.element_input_value_id

85: ssp_smp_support_pkg.element_input_value_id
86: (element_type_id, c_rate_name) RATE_ID,
87: ssp_smp_support_pkg.element_input_value_id
88: (element_type_id,c_withheld_days_name) WITHHELD_DAYS_ID,
89: ssp_smp_support_pkg.element_input_value_id
90: (element_type_id, c_SSP_weeks_name) SSP_WEEKS_ID,
91: ssp_smp_support_pkg.element_input_value_id
92: (element_type_id, c_qualifying_days_name) QUALIFYING_DAYS_ID,
93: input_currency_code

Line 91: ssp_smp_support_pkg.element_input_value_id

87: ssp_smp_support_pkg.element_input_value_id
88: (element_type_id,c_withheld_days_name) WITHHELD_DAYS_ID,
89: ssp_smp_support_pkg.element_input_value_id
90: (element_type_id, c_SSP_weeks_name) SSP_WEEKS_ID,
91: ssp_smp_support_pkg.element_input_value_id
92: (element_type_id, c_qualifying_days_name) QUALIFYING_DAYS_ID,
93: input_currency_code
94: from pay_element_types_f
95: where element_name = p_element_name

Line 103: -- ssp_smp_support_pkg. This procedure handles the case where an

99: --------------------------------------------------------------------------------
100: procedure update_linked_absence_ids;
101: --
102: -- Called from the recalculate_ssp_and_smp procedure in the
103: -- ssp_smp_support_pkg. This procedure handles the case where an
104: -- absence has been updated such that it is now a PIW, having not
105: -- previously been one. It will update the linked_absence_id of the
106: -- modified absence if it links to a previous PIW, and amend the PIW
107: -- ID held in the temporary store which determines which PIWs have