[Home] [Help]
45: ,eei.eei_information4 -- Union Funds Lookup Type - Fund List
46: FROM pay_element_types_f ele
47: ,pay_element_type_extra_info eei
48: ,hr_lookups hrl
49: ,fnd_sessions fnd
50: WHERE ele.element_type_id = p_element_type_id
51: AND eei.element_type_id = ele.element_type_id
52: AND eei.information_type = g_union_ele_extra_info_type
53: AND NVL(hrl.lookup_type,'PQP_RATE_TYPE') = 'PQP_RATE_TYPE'
65: ,hrl.meaning -- Pension Rate Type Name
66: ,eei.eei_information4 -- Union Funds Lookup Type - Fund List
67: FROM pay_element_types_f ele
68: ,pay_element_type_extra_info eei
69: ,fnd_sessions fnd
70: ,(SELECT *
71: FROM fnd_lookup_values
72: WHERE lookup_type = 'PQP_RATE_TYPE'
73: AND enabled_flag = 'Y') hrl
179: ,TO_CHAR(fnds.effective_date-365,'YYYY') -- use previous year
180: )
181: FROM hr_organization_information hoi
182: ,pay_user_tables tbls
183: ,fnd_sessions fnds
184: WHERE hoi.organization_id = p_union_organization_id
185: AND hoi.org_information_context = g_union_org_info_type
186: AND tbls.user_table_id = TO_NUMBER(hoi.org_information1)
187: AND fnds.session_id = USERENV('sessionid');
278: )
279: ||'/'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'MM/DD')
280: FROM hr_organization_information hoi
281: ,pay_user_tables tbls
282: ,fnd_sessions fnds
283: WHERE hoi.organization_id = p_union_organization_id
284: AND hoi.org_information_context = g_union_org_info_type
285: AND tbls.user_table_id = TO_NUMBER(hoi.org_information1)
286: AND fnds.session_id = USERENV('sessionid');
411: CURSOR csr_uk_union_rates_table_row(l_business_group_id number) IS
412: SELECT distinct urws.row_low_range_or_name
413: FROM pay_user_rows_f urws
414: ,pay_user_tables tbls
415: ,fnd_sessions fnd
416: WHERE tbls.user_table_name = p_union_rates_table_name
417: AND tbls.range_or_match = 'M'
418: AND urws.user_table_id = tbls.user_table_id
419: AND urws.business_group_id = tbls.business_group_id