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_ENTRIES_F

Line 96: ,pay_element_entries_f ee

92: ,per_all_people_f per
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

Line 122: , pay_element_entries_f pee

118:
119: CURSOR CSR_RUN_RESULT_FETCH (p_input_name varchar2, stdate date, enddate date) IS
120: SELECT result_value
121: FROM pay_element_types_f pet
122: , pay_element_entries_f pee
123: , pay_run_results prr
124: , pay_run_result_values prrv
125: , pay_input_values_f piv
126: WHERE pet.element_type_id = pee.element_type_id

Line 208: ,pay_element_entries_f peef1

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
211: AND pivf.input_value_id = peevf.input_value_id
212: AND pivf.NAME = 'CREATOR_ID'

Line 209: ,pay_element_entries_f peef2

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
211: AND pivf.input_value_id = peevf.input_value_id
212: AND pivf.NAME = 'CREATOR_ID'
213: AND pivf.legislation_code = 'NO'

Line 6665: ,pay_element_entries_f ee

6661: ,per_all_people_f per
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

Line 6690: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,

6686: AND p_effective_date BETWEEN el.effective_start_date AND el.effective_end_date
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;

Line 6959: ,pay_element_entries_f ee

6955: ,per_all_people_f per
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

Line 6984: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,

6980: AND effdt BETWEEN el.effective_start_date AND el.effective_end_date
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;

Line 7013: ,pay_element_entries_f ee

7009: INTO l_max_date
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

Line 7125: ,pay_element_entries_f ee

7121: ,per_all_people_f per
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

Line 7150: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,

7146: AND effdt BETWEEN el.effective_start_date AND el.effective_end_date
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;

Line 7198: ,pay_element_entries_f ee

7194: INTO l_max_date
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

Line 7414: pay_element_entries_f

7410: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7411:
7412: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7413: SELECT element_type_id from
7414: pay_element_entries_f
7415: WHERE element_entry_id = p_element_entry_id;
7416:
7417: CURSOR csr_get_input_value_id(p_element_type_id NUMBER) IS
7418: SELECT input_value_id from

Line 7512: pay_element_entries_f

7508: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7509:
7510: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7511: SELECT element_type_id from
7512: pay_element_entries_f
7513: WHERE element_entry_id = p_element_entry_id;
7514:
7515: CURSOR csr_get_input_value_id(p_element_type_id NUMBER) IS
7516: SELECT input_value_id from

Line 7578: FROM pay_element_entries_f peef

7574: RETURN DATE IS
7575:
7576: CURSOR csr_get_ele_details(p_original_entry_id IN NUMBER ) IS
7577: SELECT peef.effective_start_date,peef.assignment_id
7578: FROM pay_element_entries_f peef
7579: WHERE peef.element_entry_id = p_original_entry_id;
7580:
7581: /* Cursor to get the payroll start date given absence*/
7582: CURSOR csr_intial_abs_pay_stdt (p_assignment_id number, p_initial_abs_start_date date) is

Line 7592: FROM pay_element_entries_f peef,

7588:
7589: /* Cursor to get the absence category based on the given element entry id*/
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

Line 7850: ,pay_element_entries_f peef1

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
7853: AND pivf.input_value_id = peevf.input_value_id
7854: AND pivf.NAME = 'CREATOR_ID'

Line 7851: ,pay_element_entries_f peef2

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
7853: AND pivf.input_value_id = peevf.input_value_id
7854: AND pivf.NAME = 'CREATOR_ID'
7855: AND pivf.legislation_code = 'NO'