DBA Data[Home] [Help]

APPS.PAY_ELE_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: , per_all_assignments_f paa

26: cursor csr_sec_grp is
27: select distinct pbg.security_group_id
28: from per_business_groups pbg
29: , pay_element_entries_f ele
30: , per_all_assignments_f paa
31: where ele.element_entry_id = p_element_entry_id
32: and pbg.business_group_id = paa.business_group_id
33: and paa.assignment_id = ele.assignment_id;
34: --

Line 92: , per_all_assignments_f paa

88: cursor csr_leg_code is
89: select distinct pbg.legislation_code
90: from per_business_groups pbg
91: , pay_element_entries_f ele
92: , per_all_assignments_f paa
93: where ele.element_entry_id = p_element_entry_id
94: and pbg.business_group_id = paa.business_group_id
95: and paa.assignment_id = ele.assignment_id;
96: --

Line 472: (p_base_table_name => 'per_all_assignments_f'

468: );
469: --
470: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
471: NOT (dt_api.check_min_max_dates
472: (p_base_table_name => 'per_all_assignments_f'
473: ,p_base_key_column => 'ASSIGNMENT_ID'
474: ,p_base_key_value => p_assignment_id
475: ,p_from_date => p_validation_start_date
476: ,p_to_date => p_validation_end_date))) Then