APPS.GHR_HISTORY_FETCH dependencies on PER_ASSIGNMENTS_F

Line 1793: p_assignment_id in per_assignments_f.assignment_id%type,

1789:
1790: Procedure fetch_element_entry_value
1791: (p_element_name in pay_element_types_f.element_name%type,
1792: p_input_value_name in pay_input_values_f.name%type,
1793: p_assignment_id in per_assignments_f.assignment_id%type,
1794: p_date_effective in date,
1795: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type
1796: )
1797: is

Line 1840: from per_assignments_f

1836: --added bg id check for business group id striping
1837: --
1838: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
1839: Select distinct business_group_id bg
1840: from per_assignments_f
1841: where assignment_id = p_assignment_id
1842: and p_eff_date between effective_start_date
1843: and effective_end_date;
1844:

Line 2055: from per_assignments_f

2051: and (ipv.business_group_id is NULL or ipv.business_group_id=p_bg_id);
2052: --
2053: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
2054: Select distinct business_group_id bg
2055: from per_assignments_f
2056: where assignment_id = p_assignment_id
2057: and p_eff_date between effective_start_date
2058: and effective_end_date;
2059: