524: , pay_input_values_f piv
525: , per_pay_bases ppb
526: , per_time_period_types tpt
527: , pay_all_payrolls_f prl
528: , per_assignments_f a
529: , per_pay_proposals_v2 s
530: , hri_edw_cmpstn_snpsht_dts snp
531: where a.assignment_type = 'E'
532: and snp.snapshot_date between a.effective_start_date