APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_ELEMENTS

Line 649: psp_enc_elements peel,

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,
651: per_assignment_status_types past,
652: per_time_periods ptp
653: WHERE peev.element_entry_id = pee.element_entry_id

Line 754: psp_enc_elements peel,

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,
756: per_assignment_status_types past
757: WHERE peev.element_entry_id = pee.element_entry_id
758: AND peev.effective_start_date <= paf.effective_end_date

Line 795: FROM psp_enc_elements pee

791:
792: CURSOR get_input_formula_cur IS
793: SELECT NVL(input_value_id, -1),
794: formula_id
795: FROM psp_enc_elements pee
796: WHERE element_type_id = p_element_type_id
797: AND ( formula_id IS NOT NULL
798: OR EXISTS (SELECT 1
799: FROM pay_input_values_f piv

Line 6619: FROM psp_enc_elements

6615: AND pet.effective_end_date >= pa.effective_start_date
6616: AND pet.effective_start_date <=pa.effective_end_date
6617: AND pel.business_group_id = l_business_group_id
6618: AND pet.element_type_id IN ( SELECT element_type_id
6619: FROM psp_enc_elements
6620: WHERE business_group_id = l_business_group_id
6621: AND set_of_books_id = l_set_of_books_id)
6622: AND pet.classification_id = pc.classification_id
6623: ORDER BY pet.element_type_id;

Line 6750: FROM psp_enc_elements pee

6746: AND change_type = 'ZZ';
6747:
6748: CURSOR money_value_cur (p_element_type_id IN NUMBER) IS
6749: SELECT COUNT(1)
6750: FROM psp_enc_elements pee
6751: WHERE element_type_id = p_element_type_id
6752: AND ( formula_id IS NOT NULL
6753: OR EXISTS (SELECT 1
6754: FROM pay_input_values_f piv

Line 6760: FROM psp_enc_elements pee

6756: AND SUBSTR(piv.uom, 1, 1) <> 'H'));
6757:
6758: CURSOR hours_value_cur (p_element_type_id IN NUMBER) IS
6759: SELECT COUNT(1)
6760: FROM psp_enc_elements pee
6761: WHERE element_type_id = p_element_type_id
6762: AND ( formula_id IS NOT NULL
6763: OR EXISTS (SELECT 1
6764: FROM pay_input_values_f piv