eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_RATES_HISTORY_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;

18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;
19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:
21: -- cache for get_bus_group_id
22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;
23: g_cache_business_group_id per_all_assignments_f.business_group_id%TYPE;
24:
25: -- cache for get_element_entry_value
26: g_geev_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 23: g_cache_business_group_id per_all_assignments_f.business_group_id%TYPE;

19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:
21: -- cache for get_bus_group_id
22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;
23: g_cache_business_group_id per_all_assignments_f.business_group_id%TYPE;
24:
25: -- cache for get_element_entry_value
26: g_geev_element_type_id pay_element_types_f.element_type_id%TYPE;
27:

Line 223: g_cache_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE;

219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;
220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:
222: -- cache for get_bus_group_id
223: g_cache_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE;
224: g_cache_business_group_id := NULL;--per_all_assignments_f.business_group_id%TYPE;
225:
226: END clear_cache;
227: --

Line 224: g_cache_business_group_id := NULL;--per_all_assignments_f.business_group_id%TYPE;

220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:
222: -- cache for get_bus_group_id
223: g_cache_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE;
224: g_cache_business_group_id := NULL;--per_all_assignments_f.business_group_id%TYPE;
225:
226: END clear_cache;
227: --
228: -- ----------------------------------------------------------------------------

Line 243: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

239: l_proc_step NUMBER(20,10):=0;
240: l_proc_name VARCHAR2(61):=
241: g_package_name||'get_bus_grp_id';
242:
243: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
244:
245: CURSOR csr_get_bus_grp_id
246: IS
247: SELECT business_group_id

Line 248: FROM per_all_assignments_f

244:
245: CURSOR csr_get_bus_grp_id
246: IS
247: SELECT business_group_id
248: FROM per_all_assignments_f
249: WHERE assignment_id = p_assignment_id;
250: BEGIN
251:
252: IF g_debug THEN

Line 693: FROM per_all_assignments_f assign

689: ,p_effective_date DATE
690: )
691: IS
692: SELECT types.number_per_fiscal_year annualization_factor
693: FROM per_all_assignments_f assign
694: ,per_time_periods period
695: ,per_time_period_types types
696: WHERE assign.assignment_id = p_assignment_id
697: AND period.payroll_id = assign.payroll_id