[Home] [Help]
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)
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)
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
703: and (fnd_date.canonical_to_date(l_benefit_end_date)
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,
1055: pay_assignment_actions paac
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
1076: WHERE piv.input_value_id = peev.input_value_id AND
1077: piv.element_type_id = v_element_type_id AND
1078: peev.element_entry_id = v_element_entry_id AND
1079: peev.effective_start_date = v_effective_start_date;
1119: (flex_ele.enabled_flag IS NULL OR flex_ele.enabled_flag ='Y') AND
1120: flex_ele.end_user_column_name = flex_act.end_user_column_name ) AND
1121: not Exists (
1122: SELECT /*+ no_unnest */ 1
1123: FROM pay_input_values_f piv,
1124: pay_element_entry_values_f peev
1125: WHERE piv.input_value_id = peev.input_value_id AND
1126: piv.element_type_id = v_element_type_id AND
1127: peev.element_entry_id = v_element_entry_id AND