APPS.HR_NO_UTILITY dependencies on FND_DATE

Line 691: l_Date := fnd_date.canonical_to_date('4712/12/31');

687: EXCEPTION
688: WHEN NO_DATA_FOUND
689: THEN
690:
691: l_Date := fnd_date.canonical_to_date('4712/12/31');
692: END;
693:
694: RETURN l_Date;
695: END Get_LOAN_START_DATE;

Line 717: l_Date := fnd_date.canonical_to_date('4712/12/31');

713: EXCEPTION
714: WHEN NO_DATA_FOUND
715: THEN
716:
717: l_Date := fnd_date.canonical_to_date('4712/12/31');
718: END;
719:
720: RETURN l_Date;
721: END Get_EE_EFF_START_DATE;

Line 745: l_Date := fnd_date.canonical_to_date('4712/12/31');

741: EXCEPTION
742: WHEN NO_DATA_FOUND
743: THEN
744:
745: l_Date := fnd_date.canonical_to_date('4712/12/31');
746: END;
747:
748: RETURN l_Date;
749: END Get_EE_EFF_END_DATE;

Line 922: l_regular_pay_date := fnd_date.canonical_to_date('4712/12/31');

918:
919: EXCEPTION
920: WHEN NO_DATA_FOUND
921: THEN
922: l_regular_pay_date := fnd_date.canonical_to_date('4712/12/31');
923: END;
924:
925: Return l_regular_pay_date;
926: END get_regular_pay_date;

Line 974: -- Modifying CURSOR csr_get_row_id , commenting the use of fnd_date.canonical_to_date

970: WHERE legislation_code = 'NO'
971: AND UPPER(user_column_name) = UPPER(p_column_name)
972: AND user_table_id = l_user_table_id;
973:
974: -- Modifying CURSOR csr_get_row_id , commenting the use of fnd_date.canonical_to_date
975:
976: /*
977: CURSOR csr_get_row_id (l_user_table_id NUMBER) IS
978: SELECT user_row_id

Line 983: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

979: FROM pay_user_rows_f
980: WHERE legislation_code = 'NO'
981: AND UPPER(row_low_range_or_name) = UPPER(p_return_type)
982: AND user_table_id = l_user_table_id
983: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;
984: */
985:
986: CURSOR csr_get_row_id (l_user_table_id NUMBER) IS
987: SELECT user_row_id

Line 994: -- Modifying CURSOR csr_get_user_table_value , commenting the use of fnd_date.canonical_to_date

990: AND UPPER(row_low_range_or_name) = UPPER(p_return_type)
991: AND user_table_id = l_user_table_id
992: AND p_Date_Earned BETWEEN effective_start_date AND effective_end_date;
993:
994: -- Modifying CURSOR csr_get_user_table_value , commenting the use of fnd_date.canonical_to_date
995:
996: /*
997: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
998: SELECT value

Line 1003: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;

999: FROM pay_user_column_instances_f
1000: WHERE legislation_code = 'NO'
1001: AND user_column_id = l_user_column_id
1002: AND user_row_id = l_user_row_id
1003: AND fnd_date.canonical_to_date(p_Date_Earned) BETWEEN effective_start_date AND effective_end_date;
1004: */
1005:
1006: /*
1007: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS