APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 1367: insert into pay_element_span_usages

1363: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1364: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1365: End if;
1366:
1367: insert into pay_element_span_usages
1368: (element_span_usage_id, business_group_id, time_span_id,
1369: retro_component_usage_id, retro_element_type_id,
1370: creation_date, created_by, last_update_date, last_updated_by,
1371: last_update_login, object_version_number)

Line 1373: (pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,

1369: retro_component_usage_id, retro_element_type_id,
1370: creation_date, created_by, last_update_date, last_updated_by,
1371: last_update_login, object_version_number)
1372: values
1373: (pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
1374: p_retro_comp_usage_id, p_retro_element_type_id,
1375: sysdate, 2, sysdate, 2, 2, 1);
1376:
1377: IF g_debug THEN

Line 2724: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE

2720: PROCEDURE create_element_spans
2721: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2722: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2723: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2724: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2725: )
2726: IS
2727: --
2728: l_time_span_id pay_time_spans.time_span_id%TYPE;

Line 2730: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;

2726: IS
2727: --
2728: l_time_span_id pay_time_spans.time_span_id%TYPE;
2729: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2730: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
2731: --
2732: CURSOR csr_get_element_type_id IS
2733: SELECT element_type_id
2734: FROM pay_element_types_f

Line 2740: FROM pay_element_span_usages pesu

2736: AND legislation_code = g_legislation_code;
2737: --
2738: CURSOR csr_exists IS
2739: SELECT element_span_usage_id
2740: FROM pay_element_span_usages pesu
2741: WHERE pesu.retro_component_usage_id = p_retro_component_usage_id
2742: AND pesu.time_span_id = p_time_span_id
2743: AND pesu.adjustment_type IS NULL;
2744: --

Line 2761: INSERT INTO pay_element_span_usages

2757: OPEN csr_get_element_type_id;
2758: FETCH csr_get_element_type_id INTO l_element_type_id;
2759: CLOSE csr_get_element_type_id;
2760: --
2761: INSERT INTO pay_element_span_usages
2762: (ELEMENT_SPAN_USAGE_ID
2763: ,LEGISLATION_CODE
2764: ,TIME_SPAN_ID
2765: ,RETRO_COMPONENT_USAGE_ID

Line 2773: SELECT pay_element_span_usages_s.nextval

2769: ,LAST_UPDATE_DATE
2770: ,LAST_UPDATED_BY
2771: ,LAST_UPDATE_LOGIN
2772: ,OBJECT_VERSION_NUMBER)
2773: SELECT pay_element_span_usages_s.nextval
2774: , g_legislation_code
2775: , p_time_span_id
2776: , p_retro_component_usage_id
2777: , l_element_type_id

Line 2801: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE

2797: ,p_retro_element_name IN VARCHAR2
2798: ,p_component_name IN VARCHAR2
2799: ,p_reprocess_type IN VARCHAR2
2800: ,p_default_component IN VARCHAR2
2801: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2802: )
2803: IS
2804: --
2805: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;