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_ASSIGNMENT_ACTIONS

Line 414: RETURN pay_assignment_actions.assignment_action_id%type

410: /* FUNCTION get_max_asg_action_id */
411: ----------------------------------------------------------------------------------------
412: FUNCTION get_max_asg_action_id (p_assignment_id IN NUMBER
413: ,p_effective_date IN DATE DEFAULT NULL)
414: RETURN pay_assignment_actions.assignment_action_id%type
415: IS
416: --
417: -- Modified cursor for bug 3899565
418: --

Line 424: ,pay_assignment_actions pac

420: p_date date)
421: IS
422: select max(pac.action_sequence)
423: from pay_payroll_actions ppa
424: ,pay_assignment_actions pac
425: where ppa.payroll_action_id = pac.payroll_action_id
426: and pac.assignment_id = p_assignment_id
427: and ppa.effective_date <= p_date
428: and ppa.action_type in ('B','R','Q')

Line 439: pay_assignment_actions pac

435: IS
436: select
437: pac.assignment_action_id
438: from
439: pay_assignment_actions pac
440: where
441: pac.assignment_id = p_assignment_id
442: and pac.action_sequence = p_action_sequence
443: and pac.action_status = 'C';

Line 447: l_action_sequence pay_assignment_actions.action_sequence%type;

443: and pac.action_status = 'C';
444: --
445: l_asg_action_id NUMBER;
446: l_effective_date DATE;
447: l_action_sequence pay_assignment_actions.action_sequence%type;
448: --
449: BEGIN
450: --
451: IF p_effective_date IS NULL THEN

Line 485: FUNCTION paid_amount_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

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

Line 528: FUNCTION paid_amount_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) RETURN NUMBER

524: --===========================================================================================
525: ---------------------------------------------------------------------------------------------
526: /* FUNCTION paid_amount_this_run (for all creditors) */
527: ---------------------------------------------------------------------------------------------
528: FUNCTION paid_amount_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) RETURN NUMBER
529: IS
530: l_paid_amount_this_run NUMBER;
531: BEGIN
532: l_paid_amount_this_run := 0;

Line 635: l_assignment_action_id pay_assignment_actions.assignment_action_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;
636: BEGIN
637: l_unpaid_debt := 0;
638: IF processing_type (p_element_entry_id) = 'P' AND Obligation_exists (p_element_entry_id, p_effective_date)
639: THEN

Line 702: FUNCTION paid_interest_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

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

Line 744: FUNCTION paid_interest_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) RETURN NUMBER

740: --================================================================================================
741: -------------------------------------------------------------------------------------------------
742: /* FUNCTION paid_interest_this_run (for all creditors) */
743: -------------------------------------------------------------------------------------------------
744: FUNCTION paid_interest_this_run (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE) RETURN NUMBER
745: IS
746: l_paid_interest_to_all NUMBER;
747: BEGIN
748: l_paid_interest_to_all := 0;