[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
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)
705: between paa.effective_start_date AND paa.effective_end_date
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
1057: WHERE pet.classification_id = pec.classification_id AND
1058: pet.element_type_id = piv.element_type_id AND
3241: LOOP
3242: l_counter := l_counter + 1;
3243: l_user_inputs(l_counter).NAME := TRIM(entry_flex_values.NAME);
3244: l_sql_stmt := 'Select ' || entry_flex_values.application_column_name || ' from ';
3245: l_sql_stmt := l_sql_stmt || ' pay_element_entries_f WHERE ';
3246: l_sql_stmt := l_sql_stmt || ' element_entry_id = :element_entry_id ';
3247: l_sql_stmt := l_sql_stmt || ' AND EFFECTIVE_START_DATE = :effec_st_date ';
3248: EXECUTE IMMEDIATE l_sql_stmt
3249: INTO l_user_inputs(l_counter).VALUE