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_DK_TC_DP_UPLOAD dependencies on PAY_ELEMENT_TYPES_F

Line 65: l_element_name pay_element_types_f.element_name%TYPE;

61: l_employer_org_no VARCHAR2(80);
62: l_effective_date VARCHAR2(80);
63: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
64: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;

63: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
64: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
70: l_input_value_name1 VARCHAR2(80);
71: l_input_value_name2 VARCHAR2(80);

Line 149: , pay_element_types_f pet

145: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_date per_all_assignments_f.effective_start_date%TYPE)
146: IS
147: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
148: from pay_element_entries_f pee
149: , pay_element_types_f pet
150: , pay_element_links_f pel
151: , per_all_assignments_f paa
152: where pet.ELEMENT_NAME = 'Tax Card'
153: and pet.legislation_code = 'DK'

Line 531: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT

527:
528: --Added for Flugger fix
529: select ELEMENTTL.element_name
530: into l_element_name_tl
531: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
532: where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
533: and ELEMENT.LEGISLATION_CODE ='DK'
534: and ELEMENT.ELEMENT_NAME = 'Tax Card'
535: AND ELEMENTTL.LANGUAGE = USERENV('LANG');

Line 539: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT

535: AND ELEMENTTL.LANGUAGE = USERENV('LANG');
536:
537: select ELEMENTTL.element_name
538: into l_element_name
539: from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
540: where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
541: and ELEMENT.LEGISLATION_CODE ='DK'
542: and ELEMENT.ELEMENT_NAME = 'Tax Card'
543: AND ELEMENTTL.LANGUAGE = 'US';

Line 1125: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE

1121: (
1122: p_assignment_id IN NUMBER
1123: ,p_business_group_id IN NUMBER
1124: ,p_date IN per_all_assignments_f.effective_start_date%TYPE
1125: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
1126: ) RETURN NUMBER
1127: IS
1128: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
1129: CURSOR csr_get_payroll_id IS