DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PAY_INPUT_VALUES_F

Line 2432: from pay_input_values_f PIV,

2428: cursor csr_rate is
2429: select piv.default_value,
2430: piv.effective_start_date,
2431: piv.effective_end_date
2432: from pay_input_values_f PIV,
2433: pay_element_types_f ELT
2434: where elt.element_type_id = piv.element_type_id
2435: and elt.element_type_id = g_SSP_legislation.element_type_id
2436: and p_effective_date between piv.effective_start_date and piv.effective_end_date

Line 3738: from pay_input_values_f inp,

3734: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3735: max(decode(inp.name,c_qualifying_days_name,
3736: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3737: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3738: from pay_input_values_f inp,
3739: pay_element_entry_values_f eev,
3740: pay_element_entries_f ENTRY,
3741: per_all_assignments_f ASGT /* adding this join speeds up the entry query */
3742: where creator_type = c_SSP_creator_type