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

Line 335: l_element_name pay_element_types_f.element_name%TYPE;

331: FUNCTION get_element_name(p_phf_si_type IN VARCHAR2)
332: RETURN VARCHAR2
333: IS
334: --
335: l_element_name pay_element_types_f.element_name%TYPE;
336: l_proc_name VARCHAR2(150);
337:
338: --
339: BEGIN

Line 999: l_element_name pay_element_types_f.element_name%TYPE;

995: l_contribution_area VARCHAR2(30);
996: l_contribution_year VARCHAR2(30);
997: l_filling_date DATE;
998: l_report_type VARCHAR2(3);
999: l_element_name pay_element_types_f.element_name%TYPE;
1000:
1001: l_mod_start_date DATE;
1002: l_mod_end_date DATE;
1003:

Line 1229: l_element_name pay_element_types_f.element_name%TYPE;

1225: l_contribution_area VARCHAR2(30);
1226: l_contribution_year VARCHAR2(30);
1227: l_filling_date DATE;
1228: l_report_type VARCHAR2(3);
1229: l_element_name pay_element_types_f.element_name%TYPE;
1230:
1231: -- Cursor to return Expatriate Indicator and Legal Employer
1232: --
1233: -- Bug 3415164

Line 1438: l_element_name pay_element_types_f.element_name%TYPE;

1434: RETURN VARCHAR2
1435: IS
1436: --
1437:
1438: l_element_name pay_element_types_f.element_name%TYPE;
1439: l_acct_status VARCHAR2(50);
1440: l_prev_acct_status VARCHAR2(50);
1441: l_reason_of_change VARCHAR2(10);
1442: l_expat_indicator per_all_people_f.per_information8%TYPE;

Line 1475: ,pay_element_types_f pet

1471: FROM pay_element_entry_values_f eev
1472: ,pay_element_entries_f pee
1473: ,pay_element_links_f pil
1474: ,pay_input_values_f piv
1475: ,pay_element_types_f pet
1476: WHERE pet.element_name = p_element_name
1477: AND pet.element_type_id = piv.element_type_id
1478: AND piv.name = p_input_value
1479: AND pet.element_type_id = pil.element_type_id

Line 1514: ,pay_element_types_f pet

1510: FROM pay_element_entry_values_f eev
1511: ,pay_element_entries_f pee
1512: ,pay_element_links_f pil
1513: ,pay_input_values_f piv
1514: ,pay_element_types_f pet
1515: WHERE pet.element_name = p_element_name
1516: AND pet.element_type_id = piv.element_type_id
1517: AND piv.name = p_input_value
1518: AND pet.element_type_id = pil.element_type_id

Line 2847: l_element_name pay_element_types_f.element_name%TYPE;

2843: --
2844:
2845: l_return_value CHAR(1);
2846: l_count NUMBER;
2847: l_element_name pay_element_types_f.element_name%TYPE;
2848: l_proc_name VARCHAR2(150);
2849:
2850: -- Cursor to fetch count of element entry
2851: -- Bug 3415164

Line 2860: ,pay_element_types_f pet

2856: --
2857: SELECT COUNT(*)
2858: FROM pay_element_entries_f pee
2859: ,pay_element_links_f pel
2860: ,pay_element_types_f pet
2861: ,per_all_assignments_f paa
2862: WHERE paa.assignment_id = p_assignment_id
2863: AND paa.business_group_id = p_business_group_id
2864: AND p_effective_date BETWEEN paa.effective_start_date

Line 2975: ,pay_element_types_f type

2971: SELECT target.ENTRY_INFORMATION1
2972: FROM per_all_assignments_f assign
2973: ,pay_element_entries_f target
2974: ,pay_element_links_f link
2975: ,pay_element_types_f type
2976: WHERE assign.assignment_id = p_assignment_id
2977: AND target.assignment_id = assign.assignment_id
2978: AND target.entry_information_category = 'CN_PHF AND SI INFORMATION'
2979: AND target.element_link_id = link.element_link_id