DBA Data[Home] [Help]

APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 471: per_business_groups_perf pbg

467: pbg.business_group_id bg_id,
468: pbg.name bg_name,
469: pa.assignment_number ass_num
470: from per_all_assignments_f pa,
471: per_business_groups_perf pbg
472: where pa.assignment_id = p_assignment_id
473: and p_effective_date
474: between pa.effective_start_date and pa.effective_end_date
475: and pbg.business_group_id = pa.business_group_id;

Line 1428: from per_business_groups_perf pbg,

1424: pbg.business_group_id,
1425: pbg.name bg_name,
1426: pa.assignment_id,
1427: pa.assignment_number
1428: from per_business_groups_perf pbg,
1429: per_all_assignments_f pa
1430: where pbg.legislation_code = g_legislation_code
1431: and pa.business_group_id = pbg.business_group_id
1432: and pa.effective_start_date = (

Line 2786: from per_business_groups_perf pbg,

2782: pbg.business_group_id,
2783: pbg.name bg_name,
2784: pa.assignment_id,
2785: pa.assignment_number
2786: from per_business_groups_perf pbg,
2787: per_all_assignments_f pa
2788: where pbg.legislation_code = g_legislation_code
2789: and pa.business_group_id = pbg.business_group_id
2790: and pa.effective_start_date = (