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.HR_JPRTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 468: -- pay_assignment_actions ASSACT

464: -- cursor csr_assignment_action_id
465: -- is
466: -- SELECT ASSACT.assignment_action_id
467: -- FROM pay_payroll_actions PACT,
468: -- pay_assignment_actions ASSACT
469: -- WHERE ASSACT.assignment_id = P_ASSIGNMENT_ID
470: -- AND PACT.payroll_action_id = ASSACT.payroll_action_id
471: -- AND PACT.date_earned >= P_FROM_DATE
472: -- AND ( ( PACT.date_earned < P_TO_DATE)

Line 481: FROM pay_assignment_actions ASSACT,

477: is
478: -- SELECT /*+ RULE */
479: SELECT /* Hint removed : see bug :4256073 */
480: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
481: FROM pay_assignment_actions ASSACT,
482: pay_payroll_actions PACT,
483: pay_run_results RR,
484: pay_run_result_values TARGET,
485: pay_balance_feeds_f FEED

Line 533: l_assignment_action_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;

529: p_to_date IN DATE, -- sum up to this date
530: p_action_sequence IN NUMBER) -- sum up to this sequence
531: RETURN NUMBER
532: IS
533: l_assignment_action_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
534: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
535: l_balance NUMBER;
536: --
537: -- cursor csr_assignment_action_id

Line 541: -- pay_assignment_actions ASSACT

537: -- cursor csr_assignment_action_id
538: -- is
539: -- SELECT ASSACT.assignment_action_id
540: -- from pay_payroll_actions PACT,
541: -- pay_assignment_actions ASSACT
542: -- WHERE ASSACT.assignment_id = p_assignment_id
543: -- AND ASSACT.action_sequence <= NVL(p_action_sequence, ASSACT.action_sequence)
544: -- AND PACT.payroll_action_id = ASSACT.payroll_action_id
545: -- AND PACT.action_type <> 'V'

Line 551: -- pay_assignment_actions RASSACT,

547: -- AND PACT.effective_date <= p_to_date
548: -- AND NOT EXISTS(
549: -- SELECT NULL
550: -- FROM pay_payroll_actions RPACT,
551: -- pay_assignment_actions RASSACT,
552: -- pay_action_interlocks RINTL
553: -- WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
554: -- AND RASSACT.assignment_action_id = RINTL.locking_action_id
555: -- AND RPACT.payroll_action_id = RASSACT.payroll_action_id

Line 568: from pay_assignment_actions ASSACT,

564: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
565: FROM ( select /*+ ORDERED */
566: ASSACT.assignment_action_id,
567: PACT.effective_date
568: from pay_assignment_actions ASSACT,
569: pay_payroll_actions PACT
570: WHERE ASSACT.assignment_id = p_assignment_id
571: AND ASSACT.action_sequence <= NVL(p_action_sequence, ASSACT.action_sequence)
572: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 579: pay_assignment_actions RASSACT,

575: AND PACT.effective_date <= p_to_date
576: AND NOT EXISTS(
577: SELECT NULL
578: FROM pay_payroll_actions RPACT,
579: pay_assignment_actions RASSACT,
580: pay_action_interlocks RINTL
581: WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
582: AND RASSACT.assignment_action_id = RINTL.locking_action_id
583: AND RPACT.payroll_action_id = RASSACT.payroll_action_id

Line 641: -- from pay_assignment_actions BAL_ASSACT,

637: -- floor(
638: -- months_between( BACT.date_earned,
639: -- nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
640: -- / 12) * 12) start_date
641: -- from pay_assignment_actions BAL_ASSACT,
642: -- pay_payroll_actions BACT,
643: -- hr_organization_information HROG
644: -- where BAL_ASSACT.assignment_action_id = assact_id
645: -- and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id

Line 648: -- pay_assignment_actions ASSACT,

644: -- where BAL_ASSACT.assignment_action_id = assact_id
645: -- and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
646: -- and HROG.organization_id = BACT.business_group_id
647: -- and HROG.org_information_context = 'Business Group Information') V1,
648: -- pay_assignment_actions ASSACT,
649: -- pay_payroll_actions PACT
650: -- WHERE ASSACT.assignment_id = V1.assignment_id
651: -- AND PACT.payroll_action_id = ASSACT.payroll_action_id
652: -- AND PACT.date_earned >= V1.start_date

Line 668: pay_assignment_actions ASSACT,

664: FROM pay_balance_feeds_f FEED,
665: pay_run_result_values TARGET,
666: pay_run_results RR,
667: pay_payroll_actions PACT,
668: pay_assignment_actions ASSACT,
669: ( select BAL_ASSACT.assignment_id assignment_id,
670: BAL_ASSACT.action_sequence action_sequence,
671: -- BACT.action_type action_type,
672: BACT.date_earned date_earned,

Line 684: pay_assignment_actions BAL_ASSACT

680: nvl(fnd_date.canonical_to_date(HROG.org_information11), trunc(BACT.date_earned, 'YYYY')))
681: / 12) * 12) start_date
682: from hr_organization_information HROG,
683: pay_payroll_actions BACT,
684: pay_assignment_actions BAL_ASSACT
685: where BAL_ASSACT.assignment_action_id = assact_id
686: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
687: and HROG.organization_id = BACT.business_group_id
688: and HROG.org_information_context = 'Business Group Information') V1