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 6766: ,pay_element_entry_values_f eev1

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
6770: AND per.person_id = asg1.person_id

Line 6791: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

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;
6795: l_tab l_table;

Line 7060: ,pay_element_entry_values_f eev1

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
7064: AND per.person_id = asg1.person_id

Line 7085: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

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;
7089: l_tab l_table;

Line 7114: ,pay_element_entry_values_f eev1

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
7118: AND iv1.NAME = 'End Date'

Line 7226: ,pay_element_entry_values_f eev1

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
7230: AND per.person_id = asg1.person_id

Line 7251: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

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;
7255: l_tab l_table;

Line 7299: ,pay_element_entry_values_f eev1

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
7303: AND iv1.NAME = 'End Date'

Line 7526: FROM pay_element_entry_values_f

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

Line 7624: FROM pay_element_entry_values_f

7620:
7621: CURSOR csr_get_screen_value(p_element_entry_id NUMBER
7622: ,p_input_value_id NUMBER ) IS
7623: SELECT screen_entry_value
7624: FROM pay_element_entry_values_f
7625: WHERE element_entry_id = p_element_entry_id
7626: AND input_value_id = p_input_value_id;
7627:
7628:

Line 7694: pay_element_entry_values_f peevf

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
7697: AND pivf.name = 'Absence Category'
7698: AND pivf.legislation_code = 'NO'

Line 7953: FROM pay_element_entry_values_f peevf

7949: FUNCTION get_init_abs_st_date (p_abs_attendance_id IN NUMBER) RETURN DATE IS
7950:
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