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 698: pay_element_types_f pet,

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

Line 1049: FROM pay_element_types_f pet,

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

Line 1071: v_element_type_id pay_element_types_f.element_type_id%TYPE,

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

Line 1101: v_element_type_id pay_element_types_f.element_type_id%TYPE,

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

Line 1155: l_element_name pay_element_types_f.element_name%TYPE;

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