[Home] [Help]
646: EXCEPTION
647: WHEN NO_DATA_FOUND
648: THEN
649:
650: l_Date := fnd_date.canonical_to_date('4712/12/31');
651: END;
652:
653: RETURN l_Date;
654: END Get_EE_EFF_START_DATE;
674: EXCEPTION
675: WHEN NO_DATA_FOUND
676: THEN
677:
678: l_Date := fnd_date.canonical_to_date('4712/12/31');
679: END;
680:
681: RETURN l_Date;
682: END Get_EE_EFF_END_DATE;
842:
843: EXCEPTION
844: WHEN NO_DATA_FOUND
845: THEN
846: l_regular_pay_date := fnd_date.canonical_to_date('4712/12/31');
847: END;
848:
849: Return l_regular_pay_date;
850: END get_regular_pay_date;
894: WHERE legislation_code = 'NO'
895: AND UPPER(user_column_name) = UPPER(p_column_name)
896: AND user_table_id = l_user_table_id;
897:
898: -- Modifying CURSOR csr_get_row_id , commenting the use of fnd_date.canonical_to_date
899:
900: /*
901: CURSOR csr_get_row_id (l_user_table_id NUMBER) IS
902: SELECT user_row_id
903: FROM pay_user_rows_f
904: WHERE legislation_code = 'NO'
905: AND UPPER(row_low_range_or_name) = UPPER(p_return_type)
906: AND user_table_id = l_user_table_id
907: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;
908: */
909:
910: CURSOR csr_get_row_id (l_user_table_id NUMBER) IS
911: SELECT user_row_id
914: AND UPPER(row_low_range_or_name) = UPPER(p_return_type)
915: AND user_table_id = l_user_table_id
916: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;
917:
918: -- Modifying CURSOR csr_get_user_table_value , commenting the use of fnd_date.canonical_to_date
919:
920: /*
921: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
922: SELECT value
923: FROM pay_user_column_instances_f
924: WHERE legislation_code = 'NO'
925: AND user_column_id = l_user_column_id
926: AND user_row_id = l_user_row_id
927: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;
928: */
929:
930: /*
931: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS