APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_INPUT_VALUES_F

Line 574: pay_input_values_f piv,

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
578: and (fnd_date.canonical_to_date(l_benefit_end_date)

Line 642: pay_input_values_f piv,

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
646: and (fnd_date.canonical_to_date(l_benefit_end_date)

Line 700: pay_input_values_f piv,

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
704: and (fnd_date.canonical_to_date(l_benefit_end_date)

Line 1052: pay_input_values_f piv,

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,
1055: per_assignments_f paa,
1056: pay_assignment_actions paac

Line 1076: FROM pay_input_values_f piv, pay_element_entry_values_f peev

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
1077: WHERE piv.input_value_id = peev.input_value_id AND
1078: piv.element_type_id = v_element_type_id AND
1079: peev.element_entry_id = v_element_entry_id AND
1080: peev.effective_start_date = v_effective_start_date;

Line 1124: FROM pay_input_values_f piv,

1120: (flex_ele.enabled_flag IS NULL OR flex_ele.enabled_flag ='Y') AND
1121: flex_ele.end_user_column_name = flex_act.end_user_column_name ) AND
1122: not Exists (
1123: SELECT /*+ no_unnest */ 1
1124: FROM pay_input_values_f piv,
1125: pay_element_entry_values_f peev
1126: WHERE piv.input_value_id = peev.input_value_id AND
1127: piv.element_type_id = v_element_type_id AND
1128: peev.element_entry_id = v_element_entry_id AND