DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 644: FROM pay_element_entry_values_f peev,

640: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
641: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
642: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
643: ptp.time_period_id
644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,
646: pay_element_entries_f pee,
647: pay_element_links_f pel,
648: pay_element_types_f pet,

Line 749: FROM pay_element_entry_values_f peev,

745: CURSOR get_element_entry IS
746: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
747: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
748: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
749: FROM pay_element_entry_values_f peev,
750: pay_input_values_f piv,
751: pay_element_entries_f pee,
752: pay_element_links_f pel,
753: pay_element_types_f pet,