DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PAY_INPUT_VALUES_F

Line 2546: from pay_input_values_f PIV,

2542: cursor csr_rate is
2543: select piv.default_value,
2544: piv.effective_start_date,
2545: piv.effective_end_date
2546: from pay_input_values_f PIV,
2547: pay_element_types_f ELT
2548: where elt.element_type_id = piv.element_type_id
2549: and elt.element_type_id = g_SSP_legislation.element_type_id
2550: and p_effective_date between piv.effective_start_date and piv.effective_end_date

Line 3852: from pay_input_values_f inp,

3848: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3849: max(decode(inp.name,c_qualifying_days_name,
3850: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3851: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3852: from pay_input_values_f inp,
3853: pay_element_entry_values_f eev,
3854: pay_element_entries_f ENTRY,
3855: per_all_assignments_f ASGT /* adding this join speeds up the entry query */
3856: where creator_type = c_SSP_creator_type