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.HR_ENTRY dependencies on PAY_ELEMENT_TYPES_F

Line 556: from pay_element_types_f pet

552: -- the session_date restriction that was used to ensure only one row would
553: -- be returned. This allow the employee termination procedure to proceed
554: -- for elements only defined after the termination date.
555: cursor c1 is select pet.process_in_run_flag
556: from pay_element_types_f pet
557: where pet.element_type_id = p_element_type_id;
558: --
559: begin
560:

Line 1185: from pay_element_types_f pet

1181:
1182: -- Get terminaation rule for element
1183: select pet.post_termination_rule
1184: into l_post_termination_rule
1185: from pay_element_types_f pet
1186: ,pay_element_links_f pel
1187: where pel.element_link_id = p_element_link_id
1188: and l_link.link_start between pel.effective_start_date
1189: and pel.effective_end_date

Line 1276: from pay_element_types_f_tl ELT_TL,

1272: -- a value_error would have been raised by the assert_condition call
1273: -- in the main body code otherwise.
1274: --
1275: select elt_tl.element_name
1276: from pay_element_types_f_tl ELT_TL,
1277: pay_element_types_f ELT,
1278: pay_element_links_f LINK
1279: where elt.element_type_id = link.element_type_id
1280: and elt_tl.element_type_id = elt.element_type_id

Line 1277: pay_element_types_f ELT,

1273: -- in the main body code otherwise.
1274: --
1275: select elt_tl.element_name
1276: from pay_element_types_f_tl ELT_TL,
1277: pay_element_types_f ELT,
1278: pay_element_links_f LINK
1279: where elt.element_type_id = link.element_type_id
1280: and elt_tl.element_type_id = elt.element_type_id
1281: and P_ELEMENT_LINK_ID = link.element_link_id

Line 1477: from pay_element_types_f pet,

1473: select pet.post_termination_rule,
1474: pet.processing_type
1475: into v_post_termination_rule,
1476: v_processing_type
1477: from pay_element_types_f pet,
1478: pay_element_links_f pel
1479: where p_session_date between pel.effective_start_date
1480: and pel.effective_end_date
1481: and pel.element_link_id = p_element_link_id

Line 2359: -- CLOSED_FOR_ENTRY_FLAG attribute on PAY_ELEMENT_TYPES_F.

2355: -- DESCRIPTION
2356: -- This procedure does the following checks:
2357: -- 1) Ensure that the element type is not closed for entry currently
2358: -- or in the future by determining the value of the
2359: -- CLOSED_FOR_ENTRY_FLAG attribute on PAY_ELEMENT_TYPES_F.
2360: -- 2) If the employee assignment is to a payroll then ensure that
2361: -- the current and future periods as of session date are open.
2362: -- If the period is closed, you can only change entries providing
2363: -- they are not to be processed in a payroll run.

Line 2374: l_element_name pay_element_types_f.element_name%TYPE;

2370: p_validation_end_date in date,
2371: p_assignment_id in number
2372: ) is
2373: --
2374: l_element_name pay_element_types_f.element_name%TYPE;
2375: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2376: l_us_except boolean := FALSE;
2377:
2378: cursor csr_element_type

Line 2375: l_legislation_code pay_element_types_f.legislation_code%TYPE;

2371: p_assignment_id in number
2372: ) is
2373: --
2374: l_element_name pay_element_types_f.element_name%TYPE;
2375: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2376: l_us_except boolean := FALSE;
2377:
2378: cursor csr_element_type
2379: (

Line 2387: from pay_element_types_f_tl et_tl,

2383: ) is
2384: select et_tl.element_name,
2385: et.closed_for_entry_flag,
2386: et.legislation_code
2387: from pay_element_types_f_tl et_tl,
2388: pay_element_types_f et
2389: where et.element_type_id = et_tl.element_type_id
2390: and et.element_type_id = p_element_type_id
2391: and userenv('LANG') = et_tl.language

Line 2388: pay_element_types_f et

2384: select et_tl.element_name,
2385: et.closed_for_entry_flag,
2386: et.legislation_code
2387: from pay_element_types_f_tl et_tl,
2388: pay_element_types_f et
2389: where et.element_type_id = et_tl.element_type_id
2390: and et.element_type_id = p_element_type_id
2391: and userenv('LANG') = et_tl.language
2392: and et.effective_start_date <= p_validation_end_date

Line 2429: --lock table pay_element_types_f in share mode;

2425: -- LOCK the element type table in share mode so that no other user can take
2426: -- out an exclusive lock to change the data. This provides a stable view
2427: -- of the element type table. See if the element type has been closed for
2428: -- entry over the period of change. If it has then error !
2429: --lock table pay_element_types_f in share mode;
2430: --
2431: for v_element_type in csr_element_type(p_element_type_id,
2432: p_validation_start_date,
2433: p_validation_end_date) loop

Line 3081: ,pay_element_types_f pet

3077: cursor c_cwk_element_check is
3078: -- Should not allow these PTO elements for CWKs
3079: select 'Y'
3080: from pay_element_links_f pel
3081: ,pay_element_types_f pet
3082: ,pay_accrual_plans pap
3083: where pel.element_link_id = p_element_link_id
3084: and p_session_date between pel.effective_start_date
3085: and pel.effective_end_date

Line 3094: ,pay_element_types_f pet

3090: union all
3091: -- Should not allow these absence elements for CWKs
3092: select 'Y'
3093: from pay_element_links_f pel
3094: ,pay_element_types_f pet
3095: ,pay_input_values_f piv
3096: ,per_absence_attendance_types abt
3097: where pel.element_link_id = p_element_link_id
3098: and p_session_date between pel.effective_start_date

Line 3137: pay_element_types_f et,

3133: v_third_party_pay_only_flag,
3134: v_element_name,
3135: v_classification_name
3136: from pay_element_links_f el,
3137: pay_element_types_f et,
3138: pay_element_classifications ec
3139: where el.element_link_id = p_element_link_id
3140: and et.element_type_id = el.element_type_id
3141: and et.classification_id = ec.classification_id

Line 3330: pay_element_types_f pet

3326: begin
3327: select distinct pet.POST_TERMINATION_RULE
3328: into v_post_termination_rule
3329: from pay_element_links_f pel,
3330: pay_element_types_f pet
3331: where pel.element_type_id=pet.element_type_id
3332: and pel.element_link_id=p_element_link_id
3333: and p_session_date between pet.effective_start_date and pet.effective_end_date
3334: and p_session_date between pel.effective_start_date and pel.effective_end_date;

Line 3865: pay_element_types_f et

3861: v_input_currency_code,
3862: v_output_currency_code
3863: from pay_element_entries_f ee,
3864: pay_element_links_f el,
3865: pay_element_types_f et
3866: where ee.element_entry_id = p_element_entry_id
3867: and el.element_link_id = ee.element_link_id
3868: and et.element_type_id = el.element_type_id
3869: and p_session_date between ee.effective_start_date

Line 5422: -- Bug G1420: restricted pay_element_types_f using date effective dates.

5418: -- being validated.
5419: begin
5420: --
5421: -- Dave Harris, 13-Oct-1994
5422: -- Bug G1420: restricted pay_element_types_f using date effective dates.
5423: --
5424: -- INDEX hint added following NHS project recommendation
5425: select /*+ INDEX(liv, pay_link_input_values_f_n2) */
5426: iv.uom,

Line 5449: pay_element_types_f et

5445: v_maximum_value,
5446: v_warning_or_error
5447: from pay_link_input_values_f liv,
5448: pay_input_values_f iv,
5449: pay_element_types_f et
5450: where liv.element_link_id = p_element_link_id
5451: and liv.input_value_id = p_input_value_id
5452: and iv.input_value_id = liv.input_value_id
5453: and et.element_type_id = iv.element_type_id