[Home] [Help]
463: --
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
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
486: WHERE ASSACT.assignment_id = P_ASSIGNMENT_ID
536: --
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
546: -- AND PACT.effective_date >= p_from_date
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
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
573: AND PACT.action_type <> 'V'
574: AND PACT.effective_date >= p_from_date
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
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
646: -- and HROG.organization_id = BACT.business_group_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
653: -- AND ( ( PACT.date_earned < V1.date_earned)
663: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
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,
679: months_between( BACT.date_earned,
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