APPS.PAY_BAL_ADJUST dependencies on PAY_ELEMENT_TYPES_F

Line 531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;

527: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
533: l_period_status per_time_periods.status%TYPE;
534: l_date_on_which_time_served_ok date;
535: l_date_on_which_old_enough date;

Line 532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;

528: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
529: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
530: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
531: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
532: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
533: l_period_status per_time_periods.status%TYPE;
534: l_date_on_which_time_served_ok date;
535: l_date_on_which_old_enough date;
536: l_dummy varchar2(1);

Line 539: l_element_name pay_element_types_f.element_name%TYPE;

535: l_date_on_which_old_enough date;
536: l_dummy varchar2(1);
537:
538: l_proc varchar2(72) := 'pay_bal_adjust.adjust_balance';
539: l_element_name pay_element_types_f.element_name%TYPE;
540: l_legislation_code pay_element_types_f.legislation_code%TYPE;
541:
542: -- bug 659393, added variables for storing all dates pased in and truncate them
543: l_effective_date date;

Line 540: l_legislation_code pay_element_types_f.legislation_code%TYPE;

536: l_dummy varchar2(1);
537:
538: l_proc varchar2(72) := 'pay_bal_adjust.adjust_balance';
539: l_element_name pay_element_types_f.element_name%TYPE;
540: l_legislation_code pay_element_types_f.legislation_code%TYPE;
541:
542: -- bug 659393, added variables for storing all dates pased in and truncate them
543: l_effective_date date;
544: --

Line 572: pay_element_types_f et,

568:
569: CURSOR c_entry_exists IS
570: SELECT 'X'
571: FROM pay_element_entries_f ee,
572: pay_element_types_f et,
573: pay_element_links_f el
574: WHERE el.element_link_id = ee.element_link_id
575: AND el.element_link_id = p_element_link_id
576: AND el.element_type_id = et.element_type_id

Line 597: FROM pay_element_types_f et,

593: -- Bugfix 2665492
594: -- Retrieve the element_link costable_type
595: --
596: el.costable_type
597: FROM pay_element_types_f et,
598: pay_element_links_f el
599: WHERE el.element_link_id = p_element_link_id
600: AND el.element_type_id = et.element_type_id
601: AND l_effective_date BETWEEN el.effective_start_date