eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 37: ,pay_element_entry_values_f v

33: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,1,1),NULL)) AS Active_Rent_Flag
34: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,4,1),NULL)) AS Minority_Group_Flag
35: FROM pay_element_entries_f e
36: ,pay_input_values_f i
37: ,pay_element_entry_values_f v
38: ,pay_element_types_f t
39: ,pay_element_links_f l
40: WHERE e.element_entry_id = v.element_entry_id
41: AND v.input_value_id = i.input_value_id

Line 463: FROM pay_element_entry_values_f pev

459: AND p_reporting_date BETWEEN pcf.effective_start_date AND pcf.effective_end_date;
460: --
461: CURSOR csr_get_ss_identifier_per (c_person_id NUMBER,c_reporting_date DATE) IS
462: SELECT nvl(pev.screen_entry_value, 'X') screen_entry_value
463: FROM pay_element_entry_values_f pev
464: ,pay_input_values_f piv
465: ,pay_element_types_f pet
466: ,pay_element_entries_f pee
467: ,pay_element_links_f pel

Line 490: FROM pay_element_entry_values_f pev

486: AND c_reporting_date BETWEEN pel.effective_start_date AND pel.effective_end_date;
487: --
488: CURSOR csr_get_ss_identifier_asg (c_assignment_id NUMBER,c_reporting_date DATE) IS
489: SELECT nvl(pev.screen_entry_value, 'X') screen_entry_value
490: FROM pay_element_entry_values_f pev
491: ,pay_input_values_f piv
492: ,pay_element_types_f pet
493: ,pay_element_entries_f pee
494: ,pay_element_links_f pel

Line 518: ,pay_element_entry_values_f v

514: ,min(decode(i.name,'Special Relationship Type',v.screen_entry_value,NULL)) AS Active_Rent_Flag
515: ,min(decode(i.name,'Retirement Age Reduction',v.screen_entry_value,NULL)) AS Minority_Group_Flag
516: FROM pay_element_entries_f e
517: ,pay_input_values_f i
518: ,pay_element_entry_values_f v
519: ,pay_element_types_f t
520: ,pay_element_links_f l
521: WHERE e.element_entry_id = v.element_entry_id
522: AND v.input_value_id = i.input_value_id

Line 591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;

587: l_ovn pay_action_information.object_version_number%TYPE;
588: l_contract_start_date DATE;
589: l_replace_person_id per_all_people_f.person_id%TYPE;
590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;
591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;
592: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;
594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%TYPE;
595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

Line 593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;

589: l_replace_person_id per_all_people_f.person_id%TYPE;
590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;
591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;
592: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;
594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%TYPE;
595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;
597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;

Line 594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%TYPE;

590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;
591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;
592: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;
594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%TYPE;
595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;
597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;
598: l_legal_employer hr_all_organization_units.organization_id%TYPE;

Line 600: l_ss_number pay_element_entry_values_f.screen_entry_value%TYPE;

596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;
597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;
598: l_legal_employer hr_all_organization_units.organization_id%TYPE;
599: l_province_code per_addresses.region_2%TYPE;
600: l_ss_number pay_element_entry_values_f.screen_entry_value%TYPE;
601: --
602: BEGIN
603: --
604: l_unused_number := 0;

Line 775: FROM pay_element_entry_values_f pev

771: CURSOR csr_get_element_values (c_assignment_id NUMBER,c_effective_start_date VARCHAR2) IS
772: SELECT pee.assignment_id AS assignment_Id
773: ,min(decode(piv.name,'SS Epigraph Code',nvl(pev.screen_entry_value, 'X'),NULL)) AS epigraph_code
774: ,min(decode(piv.name,'Contract Key',nvl(pev.screen_entry_value, 'X'),NULL)) AS Contract_Key
775: FROM pay_element_entry_values_f pev
776: ,pay_input_values_f piv
777: ,pay_element_types_f pet
778: ,pay_element_entries_f pee
779: ,pay_element_links_f pel

Line 813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;

809: l_contribution_group VARCHAR2(30);
810: l_employment_category VARCHAR2(30);
811: l_action_info_id pay_action_information.action_information_id%TYPE;
812: l_ovn pay_action_information.object_version_number%TYPE;
813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;
814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;
815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;
816: l_unused_number NUMBER;
817: sql_str VARCHAR2(4000);

Line 814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;

810: l_employment_category VARCHAR2(30);
811: l_action_info_id pay_action_information.action_information_id%TYPE;
812: l_ovn pay_action_information.object_version_number%TYPE;
813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;
814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;
815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;
816: l_unused_number NUMBER;
817: sql_str VARCHAR2(4000);
818: l_ec_value VARCHAR2(60);

Line 815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;

811: l_action_info_id pay_action_information.action_information_id%TYPE;
812: l_ovn pay_action_information.object_version_number%TYPE;
813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;
814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;
815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;
816: l_unused_number NUMBER;
817: sql_str VARCHAR2(4000);
818: l_ec_value VARCHAR2(60);
819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

Line 820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;

816: l_unused_number NUMBER;
817: sql_str VARCHAR2(4000);
818: l_ec_value VARCHAR2(60);
819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;

Line 821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;

817: sql_str VARCHAR2(4000);
818: l_ec_value VARCHAR2(60);
819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;

Line 822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;

818: l_ec_value VARCHAR2(60);
819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;

Line 823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;

819: l_soft_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
827: l_employee_category VARCHAR2(30);

Line 824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;

820: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
827: l_employee_category VARCHAR2(30);
828: l_collective_agreement NUMBER;

Line 825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;

821: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
827: l_employee_category VARCHAR2(30);
828: l_collective_agreement NUMBER;
829: l_disability_degree NUMBER;

Line 826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;

822: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
823: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
824: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
825: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
826: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
827: l_employee_category VARCHAR2(30);
828: l_collective_agreement NUMBER;
829: l_disability_degree NUMBER;
830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 834: l_contract_key pay_element_entry_values_f.screen_entry_value%TYPE;

830: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
831: l_sex per_all_people_f.sex%TYPE;
832: l_system_status per_assignment_status_types.per_system_status%TYPE;
833: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
834: l_contract_key pay_element_entry_values_f.screen_entry_value%TYPE;
835: --
836: BEGIN
837: --
838: OPEN csr_get_eit_values(p_assignment_id, p_effective_end_date);

Line 1007: from pay_element_entry_values_f pev

1003: sql_str := 'select distinct nvl(pev.screen_entry_value, ''X'') screen_entry_value
1004: ,pev.effective_start_date actual_date
1005: ,pap.date_of_birth date_of_birth
1006: ,pap.sex sex
1007: from pay_element_entry_values_f pev
1008: ,pay_input_values_f piv
1009: ,pay_element_types_f pet
1010: ,pay_element_entries_f pee
1011: ,per_all_assignments_f paa

Line 1106: from pay_element_entry_values_f pev

1102: sql_str := 'select distinct nvl(pev.screen_entry_value, ''X'') screen_entry_value
1103: ,pev.effective_start_date actual_date
1104: ,pap.date_of_birth date_of_birth
1105: ,pap.sex sex
1106: from pay_element_entry_values_f pev
1107: ,pay_input_values_f piv
1108: ,pay_element_types_f pet
1109: ,pay_element_entries_f pee
1110: ,per_all_assignments_f paa

Line 1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;

1205: l_sex per_all_people_f.sex%TYPE;
1206: --
1207: get_csr_event_values csr_event_values;
1208: --
1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;

1206: --
1207: get_csr_event_values csr_event_values;
1208: --
1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;

1207: get_csr_event_values csr_event_values;
1208: --
1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;

1208: --
1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1216: l_employee_category VARCHAR2(30);

Line 1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;

1209: l_under_repres_women pay_element_entry_values_f.screen_entry_value%TYPE;
1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1216: l_employee_category VARCHAR2(30);
1217: l_collective_agreement NUMBER;

Line 1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;

1210: l_rehired_disabled pay_element_entry_values_f.screen_entry_value%TYPE;
1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1216: l_employee_category VARCHAR2(30);
1217: l_collective_agreement NUMBER;
1218: l_disability_degree NUMBER;

Line 1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;

1211: l_unemployment_status pay_element_entry_values_f.screen_entry_value%TYPE;
1212: l_first_contractor pay_element_entry_values_f.screen_entry_value%TYPE;
1213: l_after_two_years pay_element_entry_values_f.screen_entry_value%TYPE;
1214: l_minority_group_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1216: l_employee_category VARCHAR2(30);
1217: l_collective_agreement NUMBER;
1218: l_disability_degree NUMBER;
1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1215: l_active_rent_flag pay_element_entry_values_f.screen_entry_value%TYPE;
1216: l_employee_category VARCHAR2(30);
1217: l_collective_agreement NUMBER;
1218: l_disability_degree NUMBER;
1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1216: l_employee_category VARCHAR2(30);
1217: l_collective_agreement NUMBER;
1218: l_disability_degree NUMBER;
1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1217: l_collective_agreement NUMBER;
1218: l_disability_degree NUMBER;
1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1218: l_disability_degree NUMBER;
1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1226: l_employee_category_ter VARCHAR2(30);

Line 1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1219: l_under_repres_women_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1226: l_employee_category_ter VARCHAR2(30);
1227: l_collective_agreement_ter NUMBER;

Line 1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1220: l_rehired_disabled_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1226: l_employee_category_ter VARCHAR2(30);
1227: l_collective_agreement_ter NUMBER;
1228: l_disability_degree_ter NUMBER;

Line 1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;

1221: l_unemployment_status_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1222: l_first_contractor_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1223: l_after_two_years_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1224: l_minority_group_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1225: l_active_rent_flag_ter pay_element_entry_values_f.screen_entry_value%TYPE;
1226: l_employee_category_ter VARCHAR2(30);
1227: l_collective_agreement_ter NUMBER;
1228: l_disability_degree_ter NUMBER;
1229: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;

Line 1600: FROM pay_element_entry_values_f pev

1596:
1597: --
1598: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
1599: INTO l_unused_number , l_effective_start_date
1600: FROM pay_element_entry_values_f pev
1601: ,pay_input_values_f piv
1602: ,pay_element_types_f pet
1603: ,pay_element_entries_f pee
1604: WHERE pev.element_entry_id = pee.element_entry_id

Line 1668: FROM pay_element_entry_values_f pev

1664:
1665: l_unused_number := 0;
1666: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
1667: INTO l_unused_number , l_effective_start_date
1668: FROM pay_element_entry_values_f pev
1669: ,pay_input_values_f piv
1670: ,pay_element_types_f pet
1671: ,pay_element_entries_f pee
1672: WHERE pev.element_entry_id = pee.element_entry_id

Line 1754: FROM pay_element_entry_values_f pev

1750: AND effective_start_date >= qualifying_assignments.current_reporting_date
1751: AND assignment_id = qualifying_assignments.assignment_id;*/
1752: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
1753: INTO l_unused_number , l_effective_start_date
1754: FROM pay_element_entry_values_f pev
1755: ,pay_input_values_f piv
1756: ,pay_element_types_f pet
1757: ,pay_element_entries_f pee
1758: WHERE pev.element_entry_id = pee.element_entry_id

Line 1822: FROM pay_element_entry_values_f pev

1818: ELSIF qualifying_assignments.action_status = 'MT' THEN
1819: l_unused_number := 0;
1820: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
1821: INTO l_unused_number , l_effective_start_date
1822: FROM pay_element_entry_values_f pev
1823: ,pay_input_values_f piv
1824: ,pay_element_types_f pet
1825: ,pay_element_entries_f pee
1826: WHERE pev.element_entry_id = pee.element_entry_id