APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_MEDICALS

Line 54: FROM ssp_medicals

50: -- Cursor to get Medical Id for a given Absence Attendance Id.
51: CURSOR csr_medical_id(p_absence_id IN NUMBER)
52: IS
53: SELECT medical_id
54: FROM ssp_medicals
55: WHERE absence_attendance_id = p_absence_id;
56:
57: -- Cursor to get Maternity Id for a given Absence Attendance Id.
58: CURSOR csr_maternity_id(p_absence_id IN NUMBER)

Line 935: ------------------pqp_get_ssp_medicals_details--------------------

931: ,p_message OUT NOCOPY VARCHAR2
932: )
933: RETURN VARCHAR2;
934:
935: ------------------pqp_get_ssp_medicals_details--------------------
936: FUNCTION pqp_get_ssp_medicals_details(
937: p_absence_attendance_id IN NUMBER
938: ,p_col_name IN VARCHAR2
939: ,p_error_code OUT NOCOPY NUMBER

Line 936: FUNCTION pqp_get_ssp_medicals_details(

932: )
933: RETURN VARCHAR2;
934:
935: ------------------pqp_get_ssp_medicals_details--------------------
936: FUNCTION pqp_get_ssp_medicals_details(
937: p_absence_attendance_id IN NUMBER
938: ,p_col_name IN VARCHAR2
939: ,p_error_code OUT NOCOPY NUMBER
940: ,p_message OUT NOCOPY VARCHAR2

Line 1065: FUNCTION ben_get_ssp_medicals_details(

1061: )
1062: RETURN VARCHAR2;
1063:
1064: ------------------ben_get_ssp_medical_details--------------------
1065: FUNCTION ben_get_ssp_medicals_details(
1066: p_assignment_id IN NUMBER
1067: ,p_effective_date IN DATE
1068: ,p_col_name IN VARCHAR2
1069: ,p_error_code OUT NOCOPY NUMBER