DBA Data[Home] [Help]

APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_ELEMENT_SPAN_USAGES

Line 528: pay_element_span_usages

524: IS
525: BEGIN
526: INSERT
527: INTO
528: pay_element_span_usages
529: (
530: element_span_usage_id,
531: business_group_id,
532: time_span_id,

Line 544: pay_element_span_usages_s.nextval,

540: object_version_number
541: )
542: --values
543: SELECT
544: pay_element_span_usages_s.nextval,
545: p_business_group_id,
546: p_time_span_id,
547: p_retro_comp_usage_id,
548: p_retro_element_type_id,

Line 563: pay_element_span_usages pesu

559: (
560: SELECT
561: 1
562: FROM
563: pay_element_span_usages pesu
564: WHERE
565: pesu.business_group_id = p_business_group_id
566: AND pesu.legislation_code IS NULL
567: AND pesu.time_span_id = p_time_span_id