eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 22: FUNCTION Obligation_exists (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

18: -- --------------------------
19: -- This function returns TRUE if Obligation Release exists for a court ordery.
20: --
21: -------------------------------------------------------------------------------
22: FUNCTION Obligation_exists (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
23: ,p_effective_date IN DATE DEFAULT NULL)
24: RETURN BOOLEAN;
25: --====================================================================================
26:

Line 48: FUNCTION get_attach_seq_no(p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE)

44: -- ---------------------------
45: -- This function returns the attachment sequence number for a element_entry_id.
46: --
47: ------------------------------------------------------------------------------------
48: FUNCTION get_attach_seq_no(p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE)
49: RETURN VARCHAR2;
50: --====================================================================================
51:
52:

Line 88: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE )

84: -- returns the amount that was deducted from payroll in this payroll run for a creditor
85: --
86: --------------------------------------------------------------------------------------
87: FUNCTION paid_amount_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
88: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE )
89: RETURN NUMBER;
90: --====================================================================================
91:
92:

Line 116: FUNCTION attachment_total_base (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

112: -- ------------------------------
113: -- This function will return Attachment Total Base for a court order.
114: --
115: --------------------------------------------------------------------------------------
116: FUNCTION attachment_total_base (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
117: ,p_effective_date IN DATE DEFAULT NULL)
118: RETURN NUMBER;
119: --====================================================================================
120:

Line 131: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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: --====================================================================================
135:

Line 147: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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: --====================================================================================
151:

Line 173: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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: --====================================================================================
177:

Line 188: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE)

184: -- This function returns the Interest Amount this run for a creditor.
185: --
186: --------------------------------------------------------------------------------------
187: FUNCTION paid_interest_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
188: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE)
189: RETURN NUMBER;
190: --====================================================================================
191:
192:

Line 217: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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: --====================================================================================
221: