[Home] [Help]
55: sqlstr:=
56: 'select distinct paf.person_id
57: from pay_payroll_actions ppa, -- pyugen
58: per_gen_hierarchy_nodes pghn,
59: per_assignments_f paf,
60: per_assignment_status_types past,
61: per_jobs pj,
62: fnd_common_lookups fcl
63: where ppa.payroll_action_id = :pactid
84: and paf.location_id = pghn.entity_id
85: and paf.assignment_status_type_id = past.assignment_status_type_id
86: and past.per_system_Status = ''ACTIVE_ASSIGN''
87: and paf.effective_start_Date = (select max(effective_Start_date)
88: from per_assignments_f paf1
89: where paf1.assignment_id = paf.assignment_id
90: and paf1.effective_start_Date <=ppa.start_Date
91: -- and paf1.effective_end_date >=ppa.start_date
92: and paf1.effective_end_date >=trunc(ppa.start_date,''Y'') -- BUG3886008
132: paa.tax_unit_id,
133: paf.location_id
134: FROM pay_assignment_actions paa,
135: pay_payroll_actions ppa,
136: per_assignments_f paf,
137: per_jobs pj,
138: per_gen_hierarchy_nodes pghn,
139: -- per_assignment_status_types past, -- BUG3886008
140: fnd_common_lookups fcl
148: SELECT MAX(paa2.action_sequence)
149: FROM pay_action_classifications pac,
150: pay_payroll_actions ppa2,
151: pay_assignment_actions paa2,
152: per_assignments_f paf1
153: WHERE paf1.person_id = paf.person_id
154: AND paa2.assignment_id = paf1.assignment_id
155: AND paf1.primary_flag = 'Y' -- BUG3941460
156: AND paa2.tax_unit_id = paa.tax_unit_id
186: )
187: -- AND paf.assignment_status_type_id = past.assignment_status_type_id
188: -- AND past.per_system_Status = 'ACTIVE_ASSIGN' -- BUG3886008
189: AND paf.effective_start_Date = (select max(effective_Start_date)
190: from per_assignments_f paf1
191: where paf1.assignment_id = paf.assignment_id
192: and paf1.effective_start_Date <=l_end_date
193: and paf1.effective_end_date >= l_start_date
194: -- and paf1.assignment_status_type_id =