[Home] [Help]
267: SELECT
268: p_key_name
269: ,p_product_name
270: ,p_key_value
271: FROM dual
272: WHERE NOT EXISTS (SELECT NULL
273: FROM hr_s_application_ownerships
274: WHERE product_name = p_product_name
275: AND key_name = p_key_name
331:
332: BEGIN
333: SELECT 1
334: INTO l_reference
335: FROM dual WHERE EXISTS (SELECT NULL FROM pay_element_classifications
336: WHERE nvl(legislation_code,'X') = 'ZZ'
337: AND business_group_id IS NULL);
338:
339: EXCEPTION
1782: SELECT
1783: 'ZZ'
1784: ,p_rule_type
1785: ,p_rule_mode
1786: FROM dual
1787: WHERE NOT EXISTS (SELECT NULL
1788: FROM hr_s_legislation_rules
1789: WHERE legislation_code = 'ZZ'
1790: AND rule_type = p_rule_type);
1929:
1930: IF ln_report_mapping_id IS NULL THEN
1931:
1932: SELECT PAY_REPORT_FORMAT_MAPPINGS_S.nextval
1933: INTO ln_report_mapping_id FROM dual;
1934:
1935: UPDATE pay_report_format_mappings_f
1936: SET report_format_mapping_id = ln_report_mapping_id
1937: WHERE report_qualifier = p_legislation_code
2496: --
2497: CURSOR csr_get_defn_id
2498: IS
2499: SELECT pay_retro_definitions_s.nextval
2500: FROM dual;
2501: --
2502: BEGIN
2503: --
2504: OPEN csr_defn_exists;
2561: --
2562: CURSOR csr_get_comp_id
2563: IS
2564: SELECT pay_retro_components_s.nextval
2565: FROM dual;
2566: --
2567: BEGIN
2568: --
2569: OPEN csr_component_exists;
2636: AND retro_component_id = p_retro_component_id;
2637: --
2638: CURSOR csr_get_defn_comp_id IS
2639: SELECT pay_retro_defn_components_s.nextval
2640: from dual;
2641: --
2642: BEGIN
2643: --
2644: OPEN csr_defn_comp_exists;
2710: --
2711: CURSOR csr_get_time_definition
2712: IS
2713: SELECT pay_time_definitions_s.nextval
2714: from dual;
2715: --
2716: BEGIN
2717: --
2718: OPEN csr_time_definition_exists;
2792:
2793: CURSOR csr_get_time_span
2794: IS
2795: select pay_time_spans_s.nextval
2796: from dual;
2797: --
2798: BEGIN
2799: --
2800: OPEN csr_time_span_exists;