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.PAY_NO_ABSENCE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 97: ,pay_element_entry_values_f eev1

93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_f ee
97: ,pay_element_entry_values_f eev1
98: WHERE asg1.assignment_id = l_asg_id
99: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date
100: AND l_eff_dt BETWEEN asg2.effective_start_date AND asg2.effective_end_date
101: AND per.person_id = asg1.person_id

Line 206: FROM pay_element_entry_values_f peevf

202:
203: /* Cursor to get the initial absence start date for sickness */
204: CURSOR csr_get_intial_sick_abs_st_dt(p_abs_attn_id IN VARCHAR2 ) IS
205: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
206: FROM pay_element_entry_values_f peevf
207: ,pay_input_values_f pivf
208: ,pay_element_entries_f peef1
209: ,pay_element_entries_f peef2
210: WHERE peevf.screen_entry_value = p_abs_attn_id

Line 6666: ,pay_element_entry_values_f eev1

6662: ,pay_element_links_f el
6663: ,pay_element_types_f et
6664: ,pay_input_values_f iv1
6665: ,pay_element_entries_f ee
6666: ,pay_element_entry_values_f eev1
6667: WHERE asg1.assignment_id = p_assignment_id
6668: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
6669: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
6670: AND per.person_id = asg1.person_id

Line 6691: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

6687: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
6688: ORDER BY ee.element_entry_id;
6689: --
6690: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
6691: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
6692: eename pay_input_values_f.name%TYPE );
6693: l_rec l_record;
6694: TYPE l_table is table of l_record index by BINARY_INTEGER;
6695: l_tab l_table;

Line 6960: ,pay_element_entry_values_f eev1

6956: ,pay_element_links_f el
6957: ,pay_element_types_f et
6958: ,pay_input_values_f iv1
6959: ,pay_element_entries_f ee
6960: ,pay_element_entry_values_f eev1
6961: WHERE asg1.assignment_id = p_assignment_id
6962: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
6963: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
6964: AND per.person_id = asg1.person_id

Line 6985: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

6981: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
6982: ORDER BY ee.element_entry_id;
6983: --
6984: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
6985: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
6986: eename pay_input_values_f.name%TYPE );
6987: l_rec l_record;
6988: TYPE l_table is table of l_record index by BINARY_INTEGER;
6989: l_tab l_table;

Line 7014: ,pay_element_entry_values_f eev1

7010: FROM pay_element_types_f et
7011: ,pay_element_links_f el
7012: ,pay_input_values_f iv1
7013: ,pay_element_entries_f ee
7014: ,pay_element_entry_values_f eev1
7015: WHERE et.element_name = 'Sickness Unpaid'
7016: AND et.legislation_code = 'NO'
7017: AND iv1.element_type_id = et.element_type_id
7018: AND iv1.NAME = 'End Date'

Line 7126: ,pay_element_entry_values_f eev1

7122: ,pay_element_links_f el
7123: ,pay_element_types_f et
7124: ,pay_input_values_f iv1
7125: ,pay_element_entries_f ee
7126: ,pay_element_entry_values_f eev1
7127: WHERE asg1.assignment_id = p_assignment_id
7128: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
7129: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
7130: AND per.person_id = asg1.person_id

Line 7151: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

7147: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
7148: ORDER BY ee.element_entry_id;
7149: --
7150: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
7151: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
7152: eename pay_input_values_f.name%TYPE );
7153: l_rec l_record;
7154: TYPE l_table is table of l_record index by BINARY_INTEGER;
7155: l_tab l_table;

Line 7199: ,pay_element_entry_values_f eev1

7195: FROM pay_element_types_f et
7196: ,pay_element_links_f el
7197: ,pay_input_values_f iv1
7198: ,pay_element_entries_f ee
7199: ,pay_element_entry_values_f eev1
7200: WHERE et.element_name = 'Sickness Unpaid'
7201: AND et.legislation_code = 'NO'
7202: AND iv1.element_type_id = et.element_type_id
7203: AND iv1.NAME = 'End Date'

Line 7426: FROM pay_element_entry_values_f

7422:
7423: CURSOR csr_get_screen_value(p_element_entry_id NUMBER
7424: ,p_input_value_id NUMBER ) IS
7425: SELECT screen_entry_value
7426: FROM pay_element_entry_values_f
7427: WHERE element_entry_id = p_element_entry_id
7428: AND input_value_id = p_input_value_id;
7429:
7430:

Line 7524: FROM pay_element_entry_values_f

7520:
7521: CURSOR csr_get_screen_value(p_element_entry_id NUMBER
7522: ,p_input_value_id NUMBER ) IS
7523: SELECT screen_entry_value
7524: FROM pay_element_entry_values_f
7525: WHERE element_entry_id = p_element_entry_id
7526: AND input_value_id = p_input_value_id;
7527:
7528:

Line 7594: pay_element_entry_values_f peevf

7590: CURSOR csr_abs_category (p_element_entry_id number) is
7591: SELECT screen_entry_value
7592: FROM pay_element_entries_f peef,
7593: pay_input_values_f pivf,
7594: pay_element_entry_values_f peevf
7595: WHERE peef.element_entry_id = p_element_entry_id
7596: AND pivf.element_type_id = peef.element_type_id
7597: AND pivf.name = 'Absence Category'
7598: AND pivf.legislation_code = 'NO'

Line 7848: FROM pay_element_entry_values_f peevf

7844: FUNCTION get_init_abs_st_date (p_abs_attendance_id IN NUMBER) RETURN DATE IS
7845:
7846: CURSOR csr_get_intial_abs_st_date(p_abs_attn_id IN VARCHAR2 ) IS
7847: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
7848: FROM pay_element_entry_values_f peevf
7849: ,pay_input_values_f pivf
7850: ,pay_element_entries_f peef1
7851: ,pay_element_entries_f peef2
7852: WHERE peevf.screen_entry_value = p_abs_attn_id