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_IN_TAX_DECLARATION dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 574: FROM pay_element_entry_values_f

570: --
571: CURSOR csr_entry_value(c_effective_date IN DATE)
572: IS
573: SELECT screen_entry_value
574: FROM pay_element_entry_values_f
575: WHERE element_entry_id = p_ele_entry_id
576: AND input_value_id = p_input_value_id
577: AND c_effective_date BETWEEN effective_start_date
578: AND effective_end_date;

Line 693: , pay_element_entry_values_f value

689: FROM per_assignments_f assgn
690: , pay_element_links_f link
691: , pay_element_types_f types
692: , pay_element_entries_f entries
693: , pay_element_entry_values_f value
694: , pay_input_values_f inputs
695: WHERE assgn.assignment_id = p_assignment_id
696: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
697: ,c_effective_date

Line 3292: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

3288: l_effective_start_date DATE;
3289: l_effective_end_date DATE;
3290: l_ele_entry_id pay_element_entries.element_entry_id%TYPE;
3291: l_ovn pay_element_entries_f.object_version_number%TYPE;
3292: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3293: l_element_name pay_element_types_f.element_name%TYPE;
3294: l_token1 VARCHAR2(240);
3295: --
3296: CURSOR csr_element_link_details

Line 3349: , pay_element_entry_values_f value1

3345: FROM per_assignments_f assgn
3346: , pay_element_links_f link
3347: , pay_element_types_f types
3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1
3350: , pay_input_values_f inputs1
3351: , pay_element_entry_values_f value2
3352: , pay_input_values_f inputs2
3353: WHERE assgn.assignment_id = p_assignment_id

Line 3351: , pay_element_entry_values_f value2

3347: , pay_element_types_f types
3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1
3350: , pay_input_values_f inputs1
3351: , pay_element_entry_values_f value2
3352: , pay_input_values_f inputs2
3353: WHERE assgn.assignment_id = p_assignment_id
3354: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
3355: ,c_effective_date

Line 3388: pay_element_entry_values_f peev

3384: IS
3385: SELECT peev.screen_entry_value
3386: FROM pay_element_entries_f peef,
3387: pay_input_values_f piv,
3388: pay_element_entry_values_f peev
3389: WHERE peef.element_entry_id = p_element_entry_id
3390: AND piv.element_type_id = peef.element_type_id
3391: AND piv.name = 'Component Name'
3392: AND peev.input_value_id = piv.input_value_id

Line 6254: , pay_element_entry_values_f value1

6250: FROM per_assignments_f assgn
6251: , pay_element_links_f link
6252: , pay_element_types_f types
6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3

Line 6256: , pay_element_entry_values_f value2

6252: , pay_element_types_f types
6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3
6259: , pay_input_values_f inputs3
6260: WHERE assgn.assignment_id = p_assignment_id

Line 6258: , pay_element_entry_values_f value3

6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3
6259: , pay_input_values_f inputs3
6260: WHERE assgn.assignment_id = p_assignment_id
6261: AND link.element_link_id = p_element_link_id-- Changed for bug 4774108
6262: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 6311: , pay_element_entry_values_f value1

6307: FROM per_assignments_f assgn
6308: , pay_element_links_f link
6309: , pay_element_types_f types
6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1
6312: , pay_input_values_f inputs1
6313: , pay_element_entry_values_f value2
6314: , pay_input_values_f inputs2
6315: WHERE assgn.assignment_id = p_assignment_id

Line 6313: , pay_element_entry_values_f value2

6309: , pay_element_types_f types
6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1
6312: , pay_input_values_f inputs1
6313: , pay_element_entry_values_f value2
6314: , pay_input_values_f inputs2
6315: WHERE assgn.assignment_id = p_assignment_id
6316: AND link.element_link_id = p_element_link_id
6317: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 6358: , pay_element_entry_values_f value1

6354: FROM per_assignments_f assgn
6355: , pay_element_links_f link
6356: , pay_element_types_f types
6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1
6359: , pay_input_values_f inputs1
6360: , pay_element_entry_values_f value2
6361: , pay_input_values_f inputs2
6362: WHERE assgn.assignment_id = p_assignment_id

Line 6360: , pay_element_entry_values_f value2

6356: , pay_element_types_f types
6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1
6359: , pay_input_values_f inputs1
6360: , pay_element_entry_values_f value2
6361: , pay_input_values_f inputs2
6362: WHERE assgn.assignment_id = p_assignment_id
6363: AND link.element_link_id = p_element_link_id
6364: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 6407: , pay_element_entry_values_f value1

6403: FROM per_assignments_f assgn
6404: , pay_element_links_f link
6405: , pay_element_types_f types
6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1
6408: , pay_input_values_f inputs1
6409: , pay_element_entry_values_f value2
6410: , pay_input_values_f inputs2
6411: WHERE assgn.assignment_id = p_assignment_id

Line 6409: , pay_element_entry_values_f value2

6405: , pay_element_types_f types
6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1
6408: , pay_input_values_f inputs1
6409: , pay_element_entry_values_f value2
6410: , pay_input_values_f inputs2
6411: WHERE assgn.assignment_id = p_assignment_id
6412: AND link.element_link_id = p_element_link_id
6413: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)