91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:
95: l_ut_unnudt_nm pay_user_tables.user_table_name%TYPE;
96: l_ut_unnudt_id pay_user_tables.user_table_id%TYPE;
97: l_ut_tbltyp_nm pay_user_tables.range_or_match%TYPE;
98:
99:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:
95: l_ut_unnudt_nm pay_user_tables.user_table_name%TYPE;
96: l_ut_unnudt_id pay_user_tables.user_table_id%TYPE;
97: l_ut_tbltyp_nm pay_user_tables.range_or_match%TYPE;
98:
99:
100: l_frm_effective_end_date DATE:=NVL(p_frm_effective_end_date
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:
95: l_ut_unnudt_nm pay_user_tables.user_table_name%TYPE;
96: l_ut_unnudt_id pay_user_tables.user_table_id%TYPE;
97: l_ut_tbltyp_nm pay_user_tables.range_or_match%TYPE;
98:
99:
100: l_frm_effective_end_date DATE:=NVL(p_frm_effective_end_date
101: ,TO_DATE('31/12/4712','DD/MM/YYYY'));