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 28: from pay_element_entries_f pee

24: IS
25: CURSOR csr_processing_type
26: IS
27: select peev.screen_entry_value processing_type
28: from pay_element_entries_f pee
29: ,pay_element_entry_values_f peev
30: ,pay_input_values_f piv
31: where pee.element_entry_id = p_element_entry_id
32: and peev.element_entry_id = pee.element_entry_id

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

46: --===============================================================================
47: -------------------------------------------------------------------------------
48: /* FUNCTION Obligation_exists */
49: -------------------------------------------------------------------------------
50: FUNCTION Obligation_exists (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
51: ,p_effective_date IN DATE DEFAULT NULL) RETURN BOOLEAN
52: IS
53: CURSOR csr_obligation
54: IS

Line 57: from pay_element_entries_f pee

53: CURSOR csr_obligation
54: IS
55: select peev.screen_entry_value obligation_release
56: ,peev.effective_end_date
57: from pay_element_entries_f pee
58: ,pay_element_entry_values_f peev
59: ,pay_input_values_f piv
60: where pee.element_entry_id = p_element_entry_id
61: and peev.element_entry_id = pee.element_entry_id

Line 104: ,pay_element_entries_f pee

100: IS
101: Select pee.element_entry_id
102: from pay_element_types_f pet
103: ,pay_input_values_f piv
104: ,pay_element_entries_f pee
105: ,pay_element_entry_values_f peev
106: ,pay_element_links_f pel
107: where piv.input_value_id = peev.input_value_id
108: and pet.element_type_id = piv.element_type_id

Line 141: FUNCTION get_attach_seq_no (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE) RETURN VARCHAR2

137: --======================================================================================
138: ------------------------------------------------------------------------------------
139: /* FUNCTION get_attach_seq_no */
140: ------------------------------------------------------------------------------------
141: FUNCTION get_attach_seq_no (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE) RETURN VARCHAR2
142: IS
143: CURSOR csr_attach_seq
144: IS
145: select peev.screen_entry_value

Line 146: from pay_element_entries_f pee

142: IS
143: CURSOR csr_attach_seq
144: IS
145: select peev.screen_entry_value
146: from pay_element_entries_f pee
147: ,pay_element_entry_values_f peev
148: ,pay_input_values_f piv
149: ,pay_element_types_f pet
150: ,pay_element_links_f pel

Line 187: from pay_element_entries_f pee

183: IS
184: CURSOR csr_attachment_seq_no
185: IS
186: Select peev1.screen_entry_value attachment_seq_no
187: from pay_element_entries_f pee
188: ,pay_element_entry_values_f peev
189: ,pay_element_entries_f pee1
190: ,pay_input_values_f piv
191: ,pay_element_types_f pet

Line 189: ,pay_element_entries_f pee1

185: IS
186: Select peev1.screen_entry_value attachment_seq_no
187: from pay_element_entries_f pee
188: ,pay_element_entry_values_f peev
189: ,pay_element_entries_f pee1
190: ,pay_input_values_f piv
191: ,pay_element_types_f pet
192: ,pay_element_entry_values_f peev1
193: ,pay_input_values_f piv1

Line 235: from pay_element_entries_f pee

231: IS
232: CURSOR csr_wg_exists (p_date date)
233: IS
234: select distinct pee.element_entry_id
235: from pay_element_entries_f pee
236: ,pay_element_types_f pet
237: ,pay_element_links_f pel
238: where pee.assignment_id = p_assignment_id
239: and pet.element_name = 'Wage Garnishments'

Line 486: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE ) RETURN NUMBER

482: ---------------------------------------------------------------------------------------------
483: /* FUNCTION paid_amount_this_run (for single creditor) */
484: ---------------------------------------------------------------------------------------------
485: FUNCTION paid_amount_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
486: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE ) RETURN NUMBER
487: IS
488: Cursor csr_paid_amount
489: IS
490: Select sum(prrv.result_value)

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

545: --===========================================================================================
546: ---------------------------------------------------------------------------------------------
547: /* FUNCTION attachment_total_base */
548: ---------------------------------------------------------------------------------------------
549: FUNCTION attachment_total_base (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
550: ,p_effective_date IN DATE DEFAULT NULL) RETURN NUMBER
551: IS
552: CURSOR csr_attachment_base (p_date DATE)
553: IS

Line 555: from pay_element_entries_f pee

551: IS
552: CURSOR csr_attachment_base (p_date DATE)
553: IS
554: select sum(nvl(peev.screen_entry_value, 0)) attachment_base
555: from pay_element_entries_f pee
556: ,pay_element_entry_values_f peev
557: ,pay_input_values_f piv
558: ,pay_element_types_f pet
559: ,pay_element_links_f pel

Line 602: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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 ;
606: l_total_interest_paid NUMBER ;

Line 631: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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;
635: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 664: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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 ;
668: l_processing_type VARCHAR2(10);

Line 703: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE) RETURN NUMBER

699: -------------------------------------------------------------------------------------------------
700: /* FUNCTION paid_interest_this_run (for single creditor) */
701: -------------------------------------------------------------------------------------------------
702: FUNCTION paid_interest_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
703: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE) RETURN NUMBER
704: IS
705: Cursor csr_interest
706: IS
707: Select prrv.result_value

Line 766: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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;
770: l_assignment_action_id NUMBER;