[Home] [Help]
460:
461: cursor oracle_payroll_asg_end_date is
462: SELECT /*+ use_nl(PTP)
463: INDEX(ptp PER_TIME_PERIODS_N50)
464: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
465: Max(ptp.end_date)
466: FROM pay_payroll_actions ppa,
467: pay_assignment_actions paa,
468: per_time_periods ptp
463: INDEX(ptp PER_TIME_PERIODS_N50)
464: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
465: Max(ptp.end_date)
466: FROM pay_payroll_actions ppa,
467: pay_assignment_actions paa,
468: per_time_periods ptp
469: WHERE paa.assignment_id = p_assignmnet_id
470: AND ppa.payroll_action_id = paa.payroll_action_id
471: AND ppa.business_group_id = p_business_group_id
478:
479: cursor non_oracle_asg_end_date is
480: SELECT /*+ use_nl(PTP)
481: INDEX(ptp PER_TIME_PERIODS_N50)
482: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
483: max (ptp.end_date)
484: FROM pay_payroll_actions ppa
485: , pay_assignment_actions paa
486: , per_time_periods ptp
481: INDEX(ptp PER_TIME_PERIODS_N50)
482: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
483: max (ptp.end_date)
484: FROM pay_payroll_actions ppa
485: , pay_assignment_actions paa
486: , per_time_periods ptp
487: WHERE paa.assignment_id (+) = p_assignmnet_id
488: AND ppa.payroll_action_id = paa.payroll_action_id (+)
489: AND ppa.business_group_id = p_business_group_id
564: cursor payroll_pay_end_date_cur(p_payroll_id number) is
565: SELECT /*+ INDEX(ptp PER_TIME_PERIODS_N50)*/
566: max (ptp.end_date)
567: FROM pay_payroll_actions ppa
568: ,pay_assignment_actions paa
569: ,per_time_periods ptp
570: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
571: AND ppa.payroll_id = p_payroll_id
572: AND ppa.action_type IN ('R','Q')
6769:
6770: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6771: FOR recno IN 1..t_asg_array.COUNT
6772: LOOP
6773: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6774: hr_nonrun_asact.insact(l_asg_action_id,
6775: pactid => p_pactid,
6776: chunk => p_chunk_num,
6777: object_id => t_asg_array(recno),
6907: SELECT /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
6908: INDEX(ptp PER_TIME_PERIODS_N50) */
6909: Max(ptp.end_date)
6910: FROM pay_payroll_actions ppa,
6911: pay_assignment_actions paa,
6912: per_time_periods ptp
6913: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
6914: AND ppa.business_group_id = l_business_group_id
6915: AND ppa.payroll_id = l_payroll_id
8851: /* Bug 5642002: Replaced earned date with period end date */
8852: CURSOR c_last_pay_run IS
8853: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8854: FROM pay_payroll_actions ppa,
8855: pay_assignment_actions paa,
8856: per_time_periods ptp
8857: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
8858: AND ppa.business_group_id = l_business_group_id
8859: AND ppa.payroll_id = p_payroll_id
9455: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
9456: AND pesl.effective_date > (NVL((SELECT /*+
9457: INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
9458: INDEX(ptp PER_TIME_PERIODS_N50)
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,
9462: per_time_periods ptp,
9463: pay_assignment_actions paa
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,
9462: per_time_periods ptp,
9463: pay_assignment_actions paa
9464: WHERE paa.assignment_id(+) = pesl.assignment_id
9465: AND ppa.payroll_action_id = paa.payroll_action_id (+)
9466: -- AND ppa.time_period_id = ptp.time_period_id -- Commented for the Bug 12647364
9467: AND ppa.business_group_id = pesl.business_group_id