APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_ELEMENTS

Line 851: psp_enc_elements peel,

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,
853: per_assignment_status_types past,
854: per_time_periods ptp
855: WHERE peev.element_entry_id = pee.element_entry_id

Line 956: psp_enc_elements peel,

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,
958: per_assignment_status_types past
959: WHERE peev.element_entry_id = pee.element_entry_id
960: AND peev.effective_start_date <= paf.effective_end_date

Line 998: FROM psp_enc_elements pee

994:
995: CURSOR get_input_formula_cur IS
996: SELECT NVL(input_value_id, -1),
997: formula_id
998: FROM psp_enc_elements pee
999: WHERE element_type_id = p_element_type_id
1000: AND ( formula_id IS NOT NULL
1001: OR EXISTS (SELECT 1
1002: FROM pay_input_values_f piv

Line 6885: FROM psp_enc_elements

6881: AND pet.effective_end_date >= pa.effective_start_date
6882: AND pet.effective_start_date <=pa.effective_end_date
6883: AND pel.business_group_id = l_business_group_id
6884: AND pet.element_type_id IN ( SELECT element_type_id
6885: FROM psp_enc_elements
6886: WHERE business_group_id = l_business_group_id
6887: AND set_of_books_id = l_set_of_books_id)
6888: AND pet.classification_id = pc.classification_id
6889: ORDER BY pet.element_type_id;

Line 7027: FROM psp_enc_elements pee

7023: AND change_type = 'ZZ';
7024:
7025: CURSOR money_value_cur (p_element_type_id IN NUMBER) IS
7026: SELECT COUNT(1)
7027: FROM psp_enc_elements pee
7028: WHERE element_type_id = p_element_type_id
7029: AND ( formula_id IS NOT NULL
7030: OR EXISTS (SELECT 1
7031: FROM pay_input_values_f piv

Line 7037: FROM psp_enc_elements pee

7033: AND SUBSTR(piv.uom, 1, 1) <> 'H'));
7034:
7035: CURSOR hours_value_cur (p_element_type_id IN NUMBER) IS
7036: SELECT COUNT(1)
7037: FROM psp_enc_elements pee
7038: WHERE element_type_id = p_element_type_id
7039: AND ( formula_id IS NOT NULL
7040: OR EXISTS (SELECT 1
7041: FROM pay_input_values_f piv