APPS.GHR_HISTORY_FETCH dependencies on PER_ASSIGNMENTS_F

Line 1893: p_assignment_id in per_assignments_f.assignment_id%type,

1889:
1890: Procedure fetch_element_entry_value
1891: (p_element_name in pay_element_types_f.element_name%type,
1892: p_input_value_name in pay_input_values_f.name%type,
1893: p_assignment_id in per_assignments_f.assignment_id%type,
1894: p_date_effective in date,
1895: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type
1896: )
1897: is

Line 1940: from per_assignments_f

1936: --added bg id check for business group id striping
1937: --
1938: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
1939: Select distinct business_group_id bg
1940: from per_assignments_f
1941: where assignment_id = p_assignment_id
1942: and p_eff_date between effective_start_date
1943: and effective_end_date;
1944:

Line 2155: from per_assignments_f

2151: and (ipv.business_group_id is NULL or ipv.business_group_id=p_bg_id);
2152: --
2153: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
2154: Select distinct business_group_id bg
2155: from per_assignments_f
2156: where assignment_id = p_assignment_id
2157: and p_eff_date between effective_start_date
2158: and effective_end_date;
2159: