eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 312: FROM pay_element_types_f

308: CURSOR csr_get_element_type_id
309: (cp_business_group_id NUMBER
310: ,cp_element_name VARCHAR2) IS
311: SELECT element_type_id
312: FROM pay_element_types_f
313: WHERE business_group_id = cp_business_group_id
314: AND element_name = cp_element_name;
315:
316: CURSOR csr_get_input_value_id (cp_name VARCHAR2

Line 334: FROM pay_element_types_f pet

330: CURSOR csr_get_valid_element_type_id
331: (cp_business_group_id NUMBER
332: ,cp_element_name VARCHAR2) IS
333: SELECT pet.element_type_id
334: FROM pay_element_types_f pet
335: ,pay_sub_classification_rules_f psc
336: ,pay_element_classifications pec
337: WHERE pet.business_group_id = cp_business_group_id
338: AND pet.element_name = cp_element_name

Line 351: FROM pay_element_types_f

347: ,cp_element_name VARCHAR2) IS
348: SELECT element_type_id
349: ,effective_start_date
350: ,effective_end_date
351: FROM pay_element_types_f
352: WHERE business_group_id = cp_business_group_id
353: AND element_name = cp_element_name;
354: rec_get_info_element_det csr_get_info_element_det%ROWTYPE;
355:

Line 362: l_base_name pay_element_types_f.element_name%TYPE;

358: FROM pay_element_classifications pec
359: WHERE classification_name = 'Subject to Social Insurance : Information'
360: AND legislation_code = 'AE';
361:
362: l_base_name pay_element_types_f.element_name%TYPE;
363: l_business_group_id NUMBER;
364: l_element_type_id NUMBER;
365: l_info_element_type_id NUMBER;
366: l_classification_id NUMBER;