APPS.HR_ENTRY dependencies on PAY_INPUT_VALUES_F

Line 610: PAY_INPUT_VALUES_F iv

606: pel.pay_basis_id is null and
607: NOT EXISTS
608: (SELECT pb.pay_basis_id
609: FROM PER_PAY_BASES pb,
610: PAY_INPUT_VALUES_F iv
611: WHERE iv.element_type_id = pel.element_type_id
612: and p_effective_date between
613: iv.effective_start_date and iv.effective_end_date
614: and pb.input_value_id =

Line 627: PAY_INPUT_VALUES_F iv

623: pel.pay_basis_id is null and
624: EXISTS
625: (SELECT pb.pay_basis_id
626: FROM PER_PAY_BASES pb,
627: PAY_INPUT_VALUES_F iv
628: WHERE iv.element_type_id = pel.element_type_id
629: and p_effective_date between
630: iv.effective_start_date and iv.effective_end_date
631: and pb.input_value_id =

Line 642: PAY_INPUT_VALUES_F iv

638: asg.pay_basis_id is null and
639: EXISTS
640: (SELECT pb.pay_basis_id
641: FROM PER_PAY_BASES pb,
642: PAY_INPUT_VALUES_F iv
643: WHERE iv.element_type_id = pel.element_type_id
644: and p_effective_date between
645: iv.effective_start_date and iv.effective_end_date
646: and pb.input_value_id =

Line 2332: from pay_input_values_f iv

2328: into v_uom,
2329: v_hot_default_flag,
2330: v_lookup_type,
2331: v_value_set_id
2332: from pay_input_values_f iv
2333: where iv.input_value_id = p_input_value_id
2334: and p_session_date
2335: between iv.effective_start_date and iv.effective_end_date;
2336: exception

Line 2389: pay_input_values_f i

2385: '',i.default_value,
2386: l.default_value)
2387: into v_default_value
2388: from pay_link_input_values_f l,
2389: pay_input_values_f i
2390: where i.input_value_id = p_input_value_id
2391: and l.input_value_id = i.input_value_id
2392: and l.element_link_id = p_element_link_id
2393: and p_session_date

Line 2416: from pay_input_values_f i

2412: i.max_value
2413: into v_default_value,
2414: v_minimum_value,
2415: v_maximum_value
2416: from pay_input_values_f i
2417: where i.input_value_id = p_input_value_id
2418: and p_session_date
2419: between i.effective_start_date and i.effective_end_date;
2420: exception

Line 2558: from pay_input_values_f_tl i_tl,

2554: i_tl.name
2555: into v_hot_default_flag,
2556: v_mandatory_flag,
2557: v_name
2558: from pay_input_values_f_tl i_tl,
2559: pay_input_values_f i
2560: where i.input_value_id = i_tl.input_value_id
2561: and i.input_value_id = p_input_value_id
2562: and userenv('LANG') = i_tl.language

Line 2559: pay_input_values_f i

2555: into v_hot_default_flag,
2556: v_mandatory_flag,
2557: v_name
2558: from pay_input_values_f_tl i_tl,
2559: pay_input_values_f i
2560: where i.input_value_id = i_tl.input_value_id
2561: and i.input_value_id = p_input_value_id
2562: and userenv('LANG') = i_tl.language
2563: and p_session_date

Line 2596: pay_input_values_f i

2592: begin
2593: select nvl(l.default_value,i.default_value)
2594: into v_default_value
2595: from pay_link_input_values_f l,
2596: pay_input_values_f i
2597: where i.input_value_id = p_input_value_id
2598: and l.input_value_id = i.input_value_id
2599: and l.element_link_id = p_element_link_id
2600: and p_session_date

Line 2819: ,pay_input_values_f piv

2815: -- Should not allow these absence elements for CWKs
2816: select 'Y'
2817: from pay_element_links_f pel
2818: ,pay_element_types_f pet
2819: ,pay_input_values_f piv
2820: ,per_absence_attendance_types abt
2821: where pel.element_link_id = p_element_link_id
2822: and p_session_date between pel.effective_start_date
2823: and pel.effective_end_date

Line 3424: from pay_input_values_f piv,

3420: p_session_date date ) is
3421: select peev.input_value_id,
3422: piv.uom,
3423: peev.screen_entry_value value
3424: from pay_input_values_f piv,
3425: pay_element_entry_values_f peev
3426: where peev.element_entry_id = p_element_entry_id
3427: and piv.input_value_id = peev.input_value_id
3428: and p_session_date between peev.effective_start_date

Line 3667: pay_input_values_f piv,

3663: begin
3664: select eev.screen_entry_value
3665: into v_jurisdiction
3666: from pay_element_entry_values_f eev,
3667: pay_input_values_f piv,
3668: pay_element_entries_f pee
3669: where pee.element_entry_id = v_element_entry_id
3670: and eev.element_entry_id = pee.element_entry_id
3671: and eev.input_value_id = piv.input_value_id

Line 5065: pay_input_values_f iv,

5061: v_minimum_value,
5062: v_maximum_value,
5063: v_warning_or_error
5064: from pay_link_input_values_f liv,
5065: pay_input_values_f iv,
5066: pay_element_types_f et
5067: where liv.element_link_id = p_element_link_id
5068: and liv.input_value_id = p_input_value_id
5069: and iv.input_value_id = liv.input_value_id