APPS.PAY_JP_DEF_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1447: from per_all_assignments_f pa

1443: --
1444: cursor csr_bg
1445: is
1446: select pa.business_group_id
1447: from per_all_assignments_f pa
1448: where pa.assignment_id = p_rec.assignment_id
1449: and p_rec.effective_date
1450: between pa.effective_start_date and pa.effective_end_date;
1451: --

Line 1574: from per_all_assignments_f asg,

1570: trim(substrb(decode(adrr.address_id, null,
1571: adrc.address_line1 || adrc.address_line2 || adrc.address_line3,
1572: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address,
1573: decode(adrr.address_id,null,adrc.town_or_city,adrr.town_or_city) district_code
1574: from per_all_assignments_f asg,
1575: per_all_people_f per,
1576: per_addresses adrr,
1577: per_addresses adrc
1578: where asg.assignment_id = p_assignment_id

Line 3179: per_all_assignments_f asg,

3175: assact.object_version_number,
3176: per.full_name,
3177: asg.assignment_number
3178: from per_all_people_f per,
3179: per_all_assignments_f asg,
3180: pay_jp_def_assact_v assact,
3181: pay_assignment_actions paa
3182: where paa.payroll_action_id = l_payroll_action_id
3183: and paa.action_status = 'C'