[Home] [Help]
703: ,ppa_pre.payroll_id
704: ,ppa_pre.effective_date /* BUG: 5383895 added ppa_pre.effective_date */
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 */
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
785: and paa.action_status = 'C'
786: and paa.pre_payment_id = cp_pre_payment_id
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
822: and paa.action_status = 'C'
823: and paa.run_type_id is not null
903: p_chkno number
904: ) IS
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)
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
933: and ppa_pymt.action_type in ('M','H', 'E')