92: /* FUNCTION get_element_entry_id */
93: ------------------------------------------------------------------------------------
94: /* Bug 2856663 : condition for assignment_id added to the where clause */
95: ------------------------------------------------------------------------------------
96: FUNCTION get_element_entry_id (p_assignment_id IN per_assignments_f.assignment_id%type
97: ,p_attachment_seq_no IN VARCHAR2) RETURN NUMBER
98: IS
99: CURSOR csr_element_entry
100: IS
225: --==================================================================================
226: ---------------------------------------------------------------------------------------------
227: /* FUNCTION wage_garnishment_exists */
228: ---------------------------------------------------------------------------------------------
229: FUNCTION wage_garnishment_exists (p_assignment_id IN per_assignments_f.assignment_id%TYPE
230: ,p_effective_date IN DATE DEFAULT NULL ) RETURN boolean
231: IS
232: CURSOR csr_wg_exists (p_date date)
233: IS
597: --===========================================================================================
598: ---------------------------------------------------------------------------------------------
599: /* FUNCTION real_attachment_total */
600: ---------------------------------------------------------------------------------------------
601: FUNCTION real_attachment_total (p_assignment_id IN per_assignments_f.assignment_id%TYPE
602: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
603: ,p_effective_date IN DATE DEFAULT NULL) RETURN NUMBER
604: IS
605: l_attachment_base NUMBER ;
626: --===========================================================================================
627: ---------------------------------------------------------------------------------------------
628: /* FUNCTION unpaid_debt */
629: ---------------------------------------------------------------------------------------------
630: FUNCTION unpaid_debt (p_assignment_id IN per_assignments_f.assignment_id%TYPE
631: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
632: ,p_effective_date IN DATE DEFAULT NULL ) RETURN NUMBER
633: IS
634: l_unpaid_debt NUMBER;
659: --===============================================================================================
660: -------------------------------------------------------------------------------------------------
661: /* FUNCTION paid_amount (for single creditor) */
662: -------------------------------------------------------------------------------------------------
663: FUNCTION paid_amount (p_assignment_id IN per_assignments_f.assignment_id%TYPE
664: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
665: ,p_effective_date IN DATE DEFAULT NULL ) RETURN NUMBER
666: IS
667: l_paid_amount NUMBER ;
761: --====================================================================================================
762: -------------------------------------------------------------------------------------------------
763: /* FUNCTION paid_interest (for single creditor) */
764: -------------------------------------------------------------------------------------------------
765: FUNCTION paid_interest (p_assignment_id IN per_assignments_f.assignment_id%TYPE
766: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
767: ,p_effective_date IN DATE DEFAULT NULL) RETURN NUMBER
768: IS
769: l_paid_interest NUMBER;