4424: per_all_assignments_f asg,
4425: pay_payroll_actions ppa1
4426: where ppa1.payroll_action_id = :payroll_action_id
4427: and ppa.effective_date between
4428: fnd_date.canonical_to_date('''||
4429: fnd_date.date_to_canonical(l_year_start)||''') and
4430: fnd_date.canonical_to_date('''||
4431: fnd_date.date_to_canonical(l_year_end)||''')
4432: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4425: pay_payroll_actions ppa1
4426: where ppa1.payroll_action_id = :payroll_action_id
4427: and ppa.effective_date between
4428: fnd_date.canonical_to_date('''||
4429: fnd_date.date_to_canonical(l_year_start)||''') and
4430: fnd_date.canonical_to_date('''||
4431: fnd_date.date_to_canonical(l_year_end)||''')
4432: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4433: and ppa.action_status = ''C''
4426: where ppa1.payroll_action_id = :payroll_action_id
4427: and ppa.effective_date between
4428: fnd_date.canonical_to_date('''||
4429: fnd_date.date_to_canonical(l_year_start)||''') and
4430: fnd_date.canonical_to_date('''||
4431: fnd_date.date_to_canonical(l_year_end)||''')
4432: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4433: and ppa.action_status = ''C''
4434: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4427: and ppa.effective_date between
4428: fnd_date.canonical_to_date('''||
4429: fnd_date.date_to_canonical(l_year_start)||''') and
4430: fnd_date.canonical_to_date('''||
4431: fnd_date.date_to_canonical(l_year_end)||''')
4432: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4433: and ppa.action_status = ''C''
4434: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4435: and ppa.payroll_action_id = paa.payroll_action_id