DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 846: FROM pay_element_entry_values_f peev,

842: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
845: ptp.time_period_id
846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,
848: pay_element_entries_f pee,
849: pay_element_links_f pel,
850: pay_element_types_f pet,

Line 951: FROM pay_element_entry_values_f peev,

947: CURSOR get_element_entry IS
948: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
949: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
950: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
951: FROM pay_element_entry_values_f peev,
952: pay_input_values_f piv,
953: pay_element_entries_f pee,
954: pay_element_links_f pel,
955: pay_element_types_f pet,