DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_MTRA dependencies on PER_ALL_ASSIGNMENTS_F

Line 397: per_all_assignments_f paaf,

393: pay_payroll_actions appa2,
394: pay_assignment_actions act,
395: pay_assignment_actions act1,
396: pay_action_interlocks pai,
397: per_all_assignments_f paaf,
398: hr_soft_coding_keyflex hsck,
399: hr_organization_information hoi--,
400: -- pay_payrolls_f ppa
401: where appa.action_type in ('R', 'Q')

Line 435: from per_all_assignments_f paa

431: p_start_date date,
432: p_business_group_id number
433: ) is
434: select max (effective_end_date) effective_date
435: from per_all_assignments_f paa
436: where assignment_id = p_asg_id
437: and paa.effective_start_date <= p_end_date
438: and paa.effective_end_date > = p_start_date
439: and assignment_status_type_id in (select assignment_status_type_id

Line 452: from per_all_assignments_f asg1,

448: p_assignment_id number,
449: p_value_date date
450: ) is
451: select eev1.screen_entry_value screen_entry_value
452: from per_all_assignments_f asg1,
453: per_all_assignments_f asg2,
454: per_all_people_f per,
455: pay_element_links_f el,
456: pay_element_types_f et,

Line 453: per_all_assignments_f asg2,

449: p_value_date date
450: ) is
451: select eev1.screen_entry_value screen_entry_value
452: from per_all_assignments_f asg1,
453: per_all_assignments_f asg2,
454: per_all_people_f per,
455: pay_element_links_f el,
456: pay_element_types_f et,
457: pay_input_values_f iv1,