APPS.PAY_KR_WG_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 35: FUNCTION get_element_entry_id (p_assignment_id IN per_assignments_f.assignment_id%type

31: -- -----------------------------
32: -- This function returns the element_entry_id for a attachment sequence number.
33: -- Bug 2856663 : Added parameter p_assignment_id
34: ------------------------------------------------------------------------------------
35: FUNCTION get_element_entry_id (p_assignment_id IN per_assignments_f.assignment_id%type
36: ,p_attachment_seq_no IN VARCHAR2)
37: RETURN NUMBER;
38: --====================================================================================
39:

Line 74: FUNCTION wage_garnishment_exists (p_assignment_id IN per_assignments_f.assignment_id%TYPE

70: -- returns 'TRUE' if there are any active 'Court Orders' against this assignment
71: -- returns 'FALSE' if there are no active 'Court Orders' against this assignment
72: --
73: --------------------------------------------------------------------------------------
74: FUNCTION wage_garnishment_exists (p_assignment_id IN per_assignments_f.assignment_id%TYPE
75: ,p_effective_date IN date DEFAULT NULL)
76: RETURN BOOLEAN;
77: --====================================================================================
78:

Line 130: FUNCTION real_attachment_total ( p_assignment_id IN per_assignments_f.assignment_id%TYPE

126: -- ------------------------------
127: -- This function will return Real Attachment Total for a case number.
128: --
129: --------------------------------------------------------------------------------------
130: FUNCTION real_attachment_total ( p_assignment_id IN per_assignments_f.assignment_id%TYPE
131: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
132: ,p_effective_date IN DATE DEFAULT NULL)
133: RETURN NUMBER;
134: --====================================================================================

Line 146: FUNCTION unpaid_debt(p_assignment_id IN per_assignments_f.assignment_id%TYPE

142: -- This function will return unpaid debt amount for a court order.
143: -- unpaid debt = real_attachment_total - paid_amount
144: --
145: --------------------------------------------------------------------------------------
146: FUNCTION unpaid_debt(p_assignment_id IN per_assignments_f.assignment_id%TYPE
147: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
148: ,p_effective_date IN DATE DEFAULT NULL)
149: RETURN NUMBER;
150: --====================================================================================

Line 172: FUNCTION paid_amount (p_assignment_id IN per_assignments_f.assignment_id%TYPE

168: -- paid_amount = paid_amount for this court order
169: -- + paid_amount for previous case court order
170: --
171: --------------------------------------------------------------------------------------
172: FUNCTION paid_amount (p_assignment_id IN per_assignments_f.assignment_id%TYPE
173: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
174: ,p_effective_date IN DATE DEFAULT NULL)
175: RETURN NUMBER;
176: --====================================================================================

Line 216: FUNCTION paid_interest (p_assignment_id IN per_assignments_f.assignment_id%TYPE

212: -- This function returns the total Interets Paid for this creditor till date.
213: -- paid_interest = WG_PAID_INTEREST_ASG_WG_ITD
214: --
215: --------------------------------------------------------------------------------------
216: FUNCTION paid_interest (p_assignment_id IN per_assignments_f.assignment_id%TYPE
217: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
218: ,p_effective_date IN DATE DEFAULT NULL)
219: RETURN NUMBER;
220: --====================================================================================