APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 1570: insert into pay_element_span_usages

1566: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
1567: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
1568: End if;
1569:
1570: insert into pay_element_span_usages
1571: (element_span_usage_id, business_group_id, time_span_id,
1572: retro_component_usage_id, retro_element_type_id,
1573: creation_date, created_by, last_update_date, last_updated_by,
1574: last_update_login, object_version_number)

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

1572: retro_component_usage_id, retro_element_type_id,
1573: creation_date, created_by, last_update_date, last_updated_by,
1574: last_update_login, object_version_number)
1575: values
1576: (pay_element_span_usages_s.nextval, p_business_group_id, p_time_span_id,
1577: p_retro_comp_usage_id, p_retro_element_type_id,
1578: sysdate, 2, sysdate, 2, 2, 1);
1579:
1580: IF g_debug THEN

Line 2993: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE

2989: PROCEDURE create_element_spans
2990: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2991: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2992: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2993: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2994: )
2995: IS
2996: --
2997: l_time_span_id pay_time_spans.time_span_id%TYPE;

Line 2999: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;

2995: IS
2996: --
2997: l_time_span_id pay_time_spans.time_span_id%TYPE;
2998: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2999: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
3000: --
3001: CURSOR csr_get_element_type_id IS
3002: SELECT element_type_id
3003: FROM pay_element_types_f

Line 3009: FROM pay_element_span_usages pesu

3005: AND legislation_code = g_legislation_code;
3006: --
3007: CURSOR csr_exists IS
3008: SELECT element_span_usage_id
3009: FROM pay_element_span_usages pesu
3010: WHERE pesu.retro_component_usage_id = p_retro_component_usage_id
3011: AND pesu.time_span_id = p_time_span_id
3012: AND pesu.adjustment_type IS NULL;
3013: --

Line 3030: INSERT INTO pay_element_span_usages

3026: OPEN csr_get_element_type_id;
3027: FETCH csr_get_element_type_id INTO l_element_type_id;
3028: CLOSE csr_get_element_type_id;
3029: --
3030: INSERT INTO pay_element_span_usages
3031: (ELEMENT_SPAN_USAGE_ID
3032: ,LEGISLATION_CODE
3033: ,TIME_SPAN_ID
3034: ,RETRO_COMPONENT_USAGE_ID

Line 3042: SELECT pay_element_span_usages_s.nextval

3038: ,LAST_UPDATE_DATE
3039: ,LAST_UPDATED_BY
3040: ,LAST_UPDATE_LOGIN
3041: ,OBJECT_VERSION_NUMBER)
3042: SELECT pay_element_span_usages_s.nextval
3043: , g_legislation_code
3044: , p_time_span_id
3045: , p_retro_component_usage_id
3046: , l_element_type_id

Line 3070: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE

3066: ,p_retro_element_name IN VARCHAR2
3067: ,p_component_name IN VARCHAR2
3068: ,p_reprocess_type IN VARCHAR2
3069: ,p_default_component IN VARCHAR2
3070: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
3071: )
3072: IS
3073: --
3074: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;