DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1287: per_all_assignments_f asg

1283: address
1284: from per_addresses adrc,
1285: per_addresses adrr,
1286: per_all_people_f per,
1287: per_all_assignments_f asg
1288: where asg.assignment_id = p_assignment_id
1289: and p_effective_date
1290: between asg.effective_start_date and asg.effective_end_date
1291: and per.person_id = asg.person_id

Line 2473: per_all_assignments_f asg,

2469: assact.object_version_number,
2470: per.full_name,
2471: asg.assignment_number
2472: from per_all_people_f per,
2473: per_all_assignments_f asg,
2474: pay_jp_def_assact_v assact,
2475: pay_assignment_actions paa
2476: where paa.payroll_action_id = l_payroll_action_id
2477: and paa.action_status = 'C'