[Home] [Help]
635: lv_sql_string :=
636: 'select distinct paf.person_id
637: from pay_assignment_actions paa,
638: pay_payroll_actions ppa,
639: per_assignments_f paf
640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')
643: and fnd_date.canonical_to_date(''' ||
697: ,cp_business_group_id in number
698: ,cp_start_date in date
699: ,cp_end_date in date
700: ) is
701: select /*+ INDEX(PAF PER_ASSIGNMENTS_F_N12)
702: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
703: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
704: paa.assignment_id,
705: paa.tax_unit_id,
709: paa.assignment_action_id,
710: paa.payroll_action_id
711: from pay_payroll_actions ppa,
712: pay_assignment_actions paa,
713: per_assignments_f paf
714: where paf.person_id between cp_start_person_id
715: and cp_end_person_id
716: and paa.assignment_id = paf.assignment_id
717: and ppa.effective_date between paf.effective_start_date
749: ,cp_start_date in date
750: ,cp_end_date in date
751: ) is
752: select /*+ INDEX(PPR PAY_POPULATION_RANGES_N4)
753: INDEX(PAF PER_ASSIGNMENTS_F_N12)
754: INDEX(PPA PAY_PAYROLL_ACTIONS_N50)
755: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51) */
756: paa.assignment_id,
757: paa.tax_unit_id,
761: paa.assignment_action_id,
762: paa.payroll_action_id
763: from pay_payroll_actions ppa,
764: pay_assignment_actions paa,
765: per_assignments_f paf,
766: pay_population_ranges ppr
767: where ppr.payroll_action_id = cp_payroll_action_id
768: and ppr.chunk_number = cp_chunk_number
769: and paf.person_id = ppr.person_id
7222:
7223: -- added below cursor for 13029995
7224: cursor cur_busgrp is
7225: select paf.business_group_id
7226: from per_assignments_f paf
7227: where paf.assignment_id = p_assignment_id
7228: and p_curr_pymt_eff_date between paf.effective_start_date
7229: and paf.effective_end_date;
7230: