APPS.HR_ELEMENTS dependencies on PAY_ELEMENT_TYPES_F

Line 30: from pay_element_types_f

26: select 'N'
27: into v_validation_check
28: from sys.dual
29: where exists (select 1
30: from pay_element_types_f
31: where upper(p_element_name) = upper(element_name)
32: and (p_element_type_id <> element_type_id
33: or p_element_type_id is null)
34: and (p_business_group_id = business_group_id + 0

Line 79: -- from pay_element_types_f

75: -- select 'N'
76: -- into v_validation_check
77: -- from sys.dual
78: -- where exists (select 1
79: -- from pay_element_types_f
80: -- where upper(p_reporting_name) = upper(reporting_name)
81: -- and (p_element_type_id <> element_type_id
82: -- or p_element_type_id is null)
83: -- and (p_business_group_id = business_group_id + 0

Line 348: from pay_element_types_f

344: into l_no_process_update
345: from sys.dual
346: where p_val_start_date =
347: (select min(effective_start_date)
348: from pay_element_types_f
349: where element_type_id = p_element_type_id)
350: and p_val_end_date =
351: (select max(effective_end_date)
352: from pay_element_types_f

Line 352: from pay_element_types_f

348: from pay_element_types_f
349: where element_type_id = p_element_type_id)
350: and p_val_end_date =
351: (select max(effective_end_date)
352: from pay_element_types_f
353: where element_type_id = p_element_type_id);
354: --
355: exception
356: when NO_DATA_FOUND then NULL;

Line 399: from pay_element_types_f

395: into l_no_process_update
396: from sys.dual
397: where p_val_start_date =
398: (select min(effective_start_date)
399: from pay_element_types_f
400: where element_type_id = p_element_type_id)
401: and p_val_end_date =
402: (select max(effective_end_date)
403: from pay_element_types_f

Line 403: from pay_element_types_f

399: from pay_element_types_f
400: where element_type_id = p_element_type_id)
401: and p_val_end_date =
402: (select max(effective_end_date)
403: from pay_element_types_f
404: where element_type_id = p_element_type_id);
405: --
406: exception
407: when NO_DATA_FOUND then NULL;

Line 527: pay_element_types_f et

523: where exists (select 1
524: from pay_status_processing_rules_f spr,
525: pay_formula_result_rules_f fr,
526: pay_input_values_f iv,
527: pay_element_types_f et
528: where spr.element_type_id = p_element_type_id
529: and fr.result_rule_type = 'I'
530: and spr.status_processing_rule_id =
531: fr.status_processing_rule_id

Line 561: pay_element_types_f et

557: where exists(select 1
558: from pay_status_processing_rules_f spr,
559: pay_formula_result_rules_f fr,
560: pay_input_values_f iv,
561: pay_element_types_f et
562: where fr.input_value_id = iv.input_value_id
563: and fr.result_rule_type = 'I'
564: and iv.element_type_id = p_element_type_id
565: and fr.status_processing_rule_id =

Line 844: from pay_element_types_f et

840: et.creation_date,
841: et.business_group_id,
842: et.legislation_code,
843: et.legislation_subgroup
844: from pay_element_types_f et
845: where et.element_type_id = p_element_type_id
846: and et.effective_start_date = p_val_start_date;
847: --
848: if SQL%NOTFOUND then

Line 1505: from pay_element_types_f et1

1501: begin
1502: --
1503: select 'Y'
1504: into l_on_final_record
1505: from pay_element_types_f et1
1506: where p_element_type_id = et1.element_type_id
1507: and p_val_session_date between
1508: et1.effective_start_date and et1.effective_end_date
1509: and et1.effective_end_date =

Line 1511: from pay_element_types_f et2

1507: and p_val_session_date between
1508: et1.effective_start_date and et1.effective_end_date
1509: and et1.effective_end_date =
1510: (select max(et2.effective_end_date)
1511: from pay_element_types_f et2
1512: where p_element_type_id = et2.element_type_id);
1513: --
1514: exception
1515: when NO_DATA_FOUND then NULL;