APPS.HR_US_ACCRUAL_PLANS dependencies on PAY_ELEMENT_ENTRIES_F

Line 339: pay_element_entries_f pee,

335:
336: CURSOR get_vac_hours IS
337: select fnd_number.canonical_to_number(pev.screen_entry_value)
338: from pay_accrual_plans pap,
339: pay_element_entries_f pee,
340: pay_element_entry_values_f pev
341: where pap.accrual_category = 'V'
342: and pap.business_group_id = p_bg_id
343: and pev.input_value_id = pap.pto_input_value_id

Line 361: pay_element_entries_f pee,

357:
358: CURSOR get_sick_hours IS
359: select fnd_number.canonical_to_number(pev.screen_entry_value)
360: from pay_accrual_plans pap,
361: pay_element_entries_f pee,
362: pay_element_entry_values_f pev
363: where pap.accrual_category = 'S'
364: and pap.business_group_id = p_bg_id
365: and pev.input_value_id = pap.pto_input_value_id

Line 472: pay_element_entries_f pee,

468: hr_utility.set_location('accrual_time_taken', 1);
469: select sum(fnd_number.canonical_to_number(pev.screen_entry_value))
470: into l_hours_taken
471: from pay_accrual_plans pap,
472: pay_element_entries_f pee,
473: pay_element_entry_values_f pev
474: where pap.accrual_category = p_mode
475: and pap.business_group_id = p_bg_id
476: and pev.input_value_id = pap.pto_input_value_id