APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_ENTRIES_F

Line 646: pay_element_entries_f pee,

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,
649: psp_enc_elements peel,
650: per_assignments_f paf,

Line 751: pay_element_entries_f pee,

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,
754: psp_enc_elements peel,
755: per_assignments_f paf,

Line 851: pay_element_entries_f pee

847: SELECT GREATEST(pee.effective_start_date, paf.effective_start_date, ff.effective_start_date) start_date,
848: LEAST(pee.effective_end_date, paf.effective_end_date, ff.effective_end_date) end_date
849: FROM ff_formulas_f ff,
850: per_assignments_f paf,
851: pay_element_entries_f pee
852: WHERE formula_id = l_formula_id
853: AND paf.assignment_id = p_assignment_id
854: AND pee.assignment_id = p_assignment_id
855: AND pee.element_type_id = p_element_type_id

Line 6601: FROM PAY_ELEMENT_ENTRIES_F pee,

6597: CURSOR earnings_element_cur(p_Assignment_ID NUMBER) IS
6598: SELECT DISTINCT
6599: pet.element_type_id,
6600: pc.costing_debit_or_credit
6601: FROM PAY_ELEMENT_ENTRIES_F pee,
6602: PAY_ELEMENT_LINKS_F pel,
6603: PAY_ELEMENT_TYPES_F pet,
6604: PER_ASSIGNMENTS_F pa,
6605: PAY_ELEMENT_CLASSIFICATIONS pc