[Home] [Help]
52: run for a different consolidation_set_id
53: then the cursor was not picking up any
54: record.Now the cusrsor has been changed
55: so that it checks the consolidation_set_id
56: in pay_payroll_actions table. Also an nvl
57: has been added in this join, so that it
58: picks up records if consolidation_set_id
59: has not been passed from the process.
60: 20-MAR-2002 mmukherj 115.9 2271482 Bug no in the history has been correctd.
705: from pay_run_types_f prt
706: ,pay_assignment_actions paa_run
707: ,pay_action_interlocks pai
708: ,pay_assignment_actions paa_pre
709: ,pay_payroll_actions ppa_pre
710: where ppa_pre.business_group_id = cp_business_group_id
711: and ppa_pre.effective_date between cp_start_date and cp_end_date /* BUG: 5383895 ppa_pre.date_earned changed to ppa_pre.effective_date */
712: and ppa_pre.action_status = 'C'
713: and ppa_pre.action_type in ('U','P')
776: paa.payroll_action_id,
777: paa.assignment_id,
778: ppa.effective_date
779: from
780: pay_payroll_actions ppa,
781: pay_assignment_actions paa,
782: pay_action_interlocks pai
783: where pai.locked_action_id = cp_assignment_action_id
784: and pai.locking_action_id = paa.assignment_action_id
813: cp_business_group_id in number) IS
814: /* Query to get the Pay Date of Quickpay or Payroll run */
815: select ppa.effective_date,ptp.period_name
816: from per_time_periods ptp,
817: pay_payroll_actions ppa,
818: pay_assignment_actions paa,
819: pay_action_interlocks pai
820: where pai.locking_action_id = cp_assignment_action_id
821: and pai.locked_action_id = paa.assignment_action_id
905: SELECT void_pa.effective_date
906: FROM pay_assignment_actions chq_or_mag_aa,
907: pay_action_interlocks,
908: pay_assignment_actions void_aa,
909: pay_payroll_actions void_pa
910: WHERE chq_or_mag_aa.payroll_action_id = p_payact_id
911: AND ((fnd_number.canonical_to_number(chq_or_mag_aa.serial_number)
912: = p_chkno) OR ( p_chkno is NULL))
913: AND locked_action_id = chq_or_mag_aa.assignment_action_id
924: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
925: paa_pymt.serial_number)
926: from pay_pre_payments ppp,
927: pay_assignment_actions paa_pymt,
928: pay_payroll_actions ppa_pymt,
929: pay_action_interlocks pai
930: where pai.locked_action_id = cp_pre_payment_action
931: and paa_pymt.assignment_action_id = pai.locking_action_id
932: and ppa_pymt.payroll_action_id = paa_pymt.payroll_action_id