DBA Data[Home] [Help]

APPS.HR_US_ACCRUAL_PLANS dependencies on PAY_ACCRUAL_PLANS

Line 124: FROM PAY_ACCRUAL_PLANS

120: ineligible_period_type,
121: accrual_start,
122: accrual_plan_id,
123: ineligibility_formula_id
124: FROM PAY_ACCRUAL_PLANS
125: WHERE pto_input_value_id = p_iv_id
126: AND business_group_id = p_bg_id;
127:
128: BEGIN

Line 338: from pay_accrual_plans pap,

334: l_sick_tot_hrs NUMBER(10,7) := 0;
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

Line 360: from pay_accrual_plans pap,

356: -- period for this assignment.
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

Line 471: from pay_accrual_plans pap,

467:
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