[Home] [Help]
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)
579: between paa.effective_start_date AND paa.effective_end_date
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)
647: between paa.effective_start_date AND paa.effective_end_date
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)
704: between paa.effective_start_date AND paa.effective_end_date
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
1056: WHERE pet.classification_id = pec.classification_id AND
1057: pet.element_type_id = piv.element_type_id AND
3175: LOOP
3176: l_counter := l_counter + 1;
3177: l_user_inputs(l_counter).NAME := TRIM(entry_flex_values.NAME);
3178: l_sql_stmt := 'Select ' || entry_flex_values.application_column_name || ' from ';
3179: l_sql_stmt := l_sql_stmt || ' pay_element_entries_f WHERE ';
3180: l_sql_stmt := l_sql_stmt || ' element_entry_id = :element_entry_id ';
3181: l_sql_stmt := l_sql_stmt || ' AND EFFECTIVE_START_DATE = :effec_st_date ';
3182: EXECUTE IMMEDIATE l_sql_stmt
3183: INTO l_user_inputs(l_counter).VALUE