APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_ENTRIES_F

Line 848: pay_element_entries_f pee,

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,
851: psp_enc_elements peel,
852: per_assignments_f paf,

Line 953: pay_element_entries_f pee,

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,
956: psp_enc_elements peel,
957: per_assignments_f paf,

Line 1054: pay_element_entries_f pee

1050: SELECT GREATEST(pee.effective_start_date, paf.effective_start_date, ff.effective_start_date) start_date,
1051: LEAST(pee.effective_end_date, paf.effective_end_date, ff.effective_end_date) end_date
1052: FROM ff_formulas_f ff,
1053: per_assignments_f paf,
1054: pay_element_entries_f pee
1055: WHERE formula_id = l_formula_id
1056: AND paf.assignment_id = p_assignment_id
1057: AND pee.assignment_id = p_assignment_id
1058: AND pee.element_type_id = p_element_type_id

Line 6867: FROM PAY_ELEMENT_ENTRIES_F pee,

6863: CURSOR earnings_element_cur(p_Assignment_ID NUMBER) IS
6864: SELECT DISTINCT
6865: pet.element_type_id,
6866: pc.costing_debit_or_credit
6867: FROM PAY_ELEMENT_ENTRIES_F pee,
6868: PAY_ELEMENT_LINKS_F pel,
6869: PAY_ELEMENT_TYPES_F pet,
6870: PER_ASSIGNMENTS_F pa,
6871: PAY_ELEMENT_CLASSIFICATIONS pc