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_GB_P11D_ARCHIVE_SS dependencies on PAY_ELEMENT_TYPES_F

Line 573: pay_element_types_f pet,

569: peev.effective_start_date effective_start_date
570: from per_all_assignments_f paa,
571: pay_all_payrolls_f ppf,
572: pay_element_classifications pec,
573: pay_element_types_f pet,
574: pay_input_values_f piv,
575: pay_element_entries_f pee,
576: pay_element_entry_values_f peev
577: where paa.person_id between stperson AND endperson

Line 641: pay_element_types_f pet,

637: peev.effective_start_date effective_start_date
638: from per_all_assignments_f paa,
639: pay_all_payrolls_f ppf,
640: pay_element_classifications pec,
641: pay_element_types_f pet,
642: pay_input_values_f piv,
643: pay_element_entries_f pee,
644: pay_element_entry_values_f peev
645: where paa.person_id between stperson AND endperson

Line 699: pay_element_types_f pet,

695: peev.effective_start_date effective_start_date
696: from per_all_assignments_f paa,
697: pay_all_payrolls_f ppf,
698: pay_element_classifications pec,
699: pay_element_types_f pet,
700: pay_input_values_f piv,
701: pay_element_entries_f pee,
702: pay_element_entry_values_f peev
703: where paa.person_id between stperson AND endperson

Line 1050: FROM pay_element_types_f pet,

1046: IS
1047: SELECT DISTINCT pet.element_type_id element_type_id, peev.element_entry_id element_entry_id,
1048: pet.element_name element_name, peev.effective_start_date effective_start_date, paa.person_id,
1049: paa.assignment_id, UPPER('GB_'|| pec.classification_name) classification_name
1050: FROM pay_element_types_f pet,
1051: pay_element_classifications pec,
1052: pay_input_values_f piv,
1053: pay_element_entry_values_f peev,
1054: pay_element_entries_f pee,

Line 1072: v_element_type_id pay_element_types_f.element_type_id%TYPE,

1068: ORDER BY pet.element_type_id, peev.element_entry_id, peev.effective_start_date;
1069:
1070:
1071: CURSOR csr_element_entry_values(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,
1072: v_element_type_id pay_element_types_f.element_type_id%TYPE,
1073: v_effective_start_date DATE)
1074: IS
1075: SELECT peev.screen_entry_value, UPPER(TRANSLATE(piv.NAME, ' ', '_') ) NAME
1076: FROM pay_input_values_f piv, pay_element_entry_values_f peev

Line 1102: v_element_type_id pay_element_types_f.element_type_id%TYPE,

1098: descriptive_flex_context_code = v_element_name AND
1099: (enabled_flag IS NULL OR enabled_flag = 'Y');
1100:
1101: Cursor csr_non_iv_action_info_items(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,
1102: v_element_type_id pay_element_types_f.element_type_id%TYPE,
1103: v_effective_start_date DATE,
1104: v_element_name VARCHAR2,
1105: v_classification_name VARCHAR2)
1106: is

Line 1156: l_element_name pay_element_types_f.element_name%TYPE;

1152: select max(effective_end_date)
1153: from per_all_assignments_f
1154: where assignment_id = p_assignment_id;
1155:
1156: l_element_name pay_element_types_f.element_name%TYPE;
1157: l_formula_id ff_formulas_f.formula_id%TYPE;
1158: l_formula_effective_start_date DATE;
1159: l_inputs ff_exec.inputs_t;
1160: l_user_inputs ff_exec.inputs_t;