APPS.PAY_FR_DUCS dependencies on PER_ALL_ASSIGNMENTS_F

Line 295: from per_all_assignments_f asg

291: AND payact.effective_date between g_period_start_date
292: and g_effective_date
293: AND assact.assignment_id in
294: (select assignment_id
295: from per_all_assignments_f asg
296: where asg.business_group_id+0 = g_business_group_id
297: and asg.person_id between p_start_person_id and p_end_person_id
298: and asg.effective_end_date >= g_period_start_date
299: and asg.effective_start_date <= g_effective_date

Line 328: , per_all_assignments_f asg

324: , assact.tax_unit_id establishment_id
325: , payact.action_type
326: FROM pay_population_ranges pop
327: , per_periods_of_service pos
328: , per_all_assignments_f asg
329: , pay_assignment_actions assact
330: , pay_payroll_actions payact
331: , hr_organization_information cmp_check
332: WHERE pop.payroll_action_id = p_payroll_action_id

Line 346: from per_all_assignments_f asg2

342: AND payact.effective_date between g_period_start_date
343: and g_effective_date
344: AND (asg.effective_start_date,assact.assignment_id) =
345: (select max(asg2.effective_start_date), asg2.assignment_id
346: from per_all_assignments_f asg2
347: where asg.assignment_id = asg2.assignment_id
348: and asg2.effective_end_date >= g_period_start_date
349: and asg2.effective_start_date <= g_effective_date
350: group by asg2.assignment_id)

Line 1000: ,per_all_assignments_f paa

996: CURSOR cur_per IS
997: SELECT distinct paa.person_id
998: FROM pay_action_information pai
999: ,pay_assignment_actions pac
1000: ,per_all_assignments_f paa
1001: WHERE pac.payroll_action_id=p_payroll_action_id
1002: and pai.action_information_category = 'FR_DUCS_ACTION_CONTRIB_INFO'
1003: and pai.action_information1 = l_page_id_chr
1004: and pai.action_information2 = p_page_type