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 6765: ,pay_element_entries_f ee

6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et
6764: ,pay_input_values_f iv1
6765: ,pay_element_entries_f ee
6766: ,pay_element_entry_values_f eev1
6767: WHERE asg1.assignment_id = p_assignment_id
6768: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
6769: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

6786: AND p_effective_date BETWEEN el.effective_start_date AND el.effective_end_date
6787: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
6788: ORDER BY ee.element_entry_id;
6789: --
6790: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
6791: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
6792: eename pay_input_values_f.name%TYPE );
6793: l_rec l_record;
6794: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 7059: ,pay_element_entries_f ee

7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et
7058: ,pay_input_values_f iv1
7059: ,pay_element_entries_f ee
7060: ,pay_element_entry_values_f eev1
7061: WHERE asg1.assignment_id = p_assignment_id
7062: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
7063: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

7080: AND effdt BETWEEN el.effective_start_date AND el.effective_end_date
7081: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
7082: ORDER BY ee.element_entry_id;
7083: --
7084: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
7085: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
7086: eename pay_input_values_f.name%TYPE );
7087: l_rec l_record;
7088: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 7113: ,pay_element_entries_f ee

7109: INTO l_max_date
7110: FROM pay_element_types_f et
7111: ,pay_element_links_f el
7112: ,pay_input_values_f iv1
7113: ,pay_element_entries_f ee
7114: ,pay_element_entry_values_f eev1
7115: WHERE et.element_name = 'Sickness Unpaid'
7116: AND et.legislation_code = 'NO'
7117: AND iv1.element_type_id = et.element_type_id

Line 7225: ,pay_element_entries_f ee

7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et
7224: ,pay_input_values_f iv1
7225: ,pay_element_entries_f ee
7226: ,pay_element_entry_values_f eev1
7227: WHERE asg1.assignment_id = p_assignment_id
7228: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
7229: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

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

7246: AND effdt BETWEEN el.effective_start_date AND el.effective_end_date
7247: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
7248: ORDER BY ee.element_entry_id;
7249: --
7250: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
7251: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
7252: eename pay_input_values_f.name%TYPE );
7253: l_rec l_record;
7254: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 7298: ,pay_element_entries_f ee

7294: INTO l_max_date
7295: FROM pay_element_types_f et
7296: ,pay_element_links_f el
7297: ,pay_input_values_f iv1
7298: ,pay_element_entries_f ee
7299: ,pay_element_entry_values_f eev1
7300: WHERE et.element_name = 'Sickness Unpaid'
7301: AND et.legislation_code = 'NO'
7302: AND iv1.element_type_id = et.element_type_id

Line 7514: pay_element_entries_f

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

Line 7612: pay_element_entries_f

7608: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7609:
7610: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7611: SELECT element_type_id from
7612: pay_element_entries_f
7613: WHERE element_entry_id = p_element_entry_id;
7614:
7615: CURSOR csr_get_input_value_id(p_element_type_id NUMBER) IS
7616: SELECT input_value_id from

Line 7678: FROM pay_element_entries_f peef

7674: RETURN DATE IS
7675:
7676: CURSOR csr_get_ele_details(p_original_entry_id IN NUMBER ) IS
7677: SELECT peef.effective_start_date,peef.assignment_id
7678: FROM pay_element_entries_f peef
7679: WHERE peef.element_entry_id = p_original_entry_id;
7680:
7681: /* Cursor to get the payroll start date given absence*/
7682: CURSOR csr_intial_abs_pay_stdt (p_assignment_id number, p_initial_abs_start_date date) is

Line 7692: FROM pay_element_entries_f peef,

7688:
7689: /* Cursor to get the absence category based on the given element entry id*/
7690: CURSOR csr_abs_category (p_element_entry_id number) is
7691: SELECT screen_entry_value
7692: FROM pay_element_entries_f peef,
7693: pay_input_values_f pivf,
7694: pay_element_entry_values_f peevf
7695: WHERE peef.element_entry_id = p_element_entry_id
7696: AND pivf.element_type_id = peef.element_type_id

Line 7955: ,pay_element_entries_f peef1

7951: CURSOR csr_get_intial_abs_st_date(p_abs_attn_id IN VARCHAR2 ) IS
7952: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
7953: FROM pay_element_entry_values_f peevf
7954: ,pay_input_values_f pivf
7955: ,pay_element_entries_f peef1
7956: ,pay_element_entries_f peef2
7957: WHERE peevf.screen_entry_value = p_abs_attn_id
7958: AND pivf.input_value_id = peevf.input_value_id
7959: AND pivf.NAME = 'CREATOR_ID'

Line 7956: ,pay_element_entries_f peef2

7952: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
7953: FROM pay_element_entry_values_f peevf
7954: ,pay_input_values_f pivf
7955: ,pay_element_entries_f peef1
7956: ,pay_element_entries_f peef2
7957: WHERE peevf.screen_entry_value = p_abs_attn_id
7958: AND pivf.input_value_id = peevf.input_value_id
7959: AND pivf.NAME = 'CREATOR_ID'
7960: AND pivf.legislation_code = 'NO'