APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 572: pay_element_classifications pec,

568: peev.element_entry_id element_entry_id,
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

Line 640: pay_element_classifications pec,

636: peev.element_entry_id element_entry_id,
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

Line 697: pay_element_classifications pec,

693: peev.element_entry_id element_entry_id,
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

Line 1050: pay_element_classifications pec,

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,
1054: per_assignments_f paa,