[Home] [Help]
569: CLOSE get_upper_base;
570: --Get the defined Balance id
571: select u.creator_id
572: into l_defined_balance_id
573: from ff_user_entities u,
574: ff_database_items d
575: where d.user_name = 'GOSI_REFERENCE_EARNINGS_ASG_YTD'
576: and u.user_entity_id = d.user_entity_id
577: and u.legislation_code = 'SA'
1449: --l_def_nationality :='American';
1450: --Fetch defined_balance_id's
1451: select u.creator_id
1452: into l_ann_month_db
1453: from ff_user_entities u,
1454: ff_database_items d
1455: where d.user_name = 'GOSI_ANNUITIES_NAT_JOINER_LEAVER_TU_MONTH'
1456: and u.user_entity_id = d.user_entity_id
1457: and u.legislation_code = 'SA'
1458: and u.business_group_id is null
1459: and u.creator_type = 'B';
1460: select u.creator_id
1461: into l_haz_month_db
1462: from ff_user_entities u,
1463: ff_database_items d
1464: where d.user_name = 'GOSI_HAZARDS_NAT_JOINER_LEAVER_TU_MONTH'
1465: and u.user_entity_id = d.user_entity_id
1466: and u.legislation_code = 'SA'
2064: l_emp_gosi_ann_asg_ptd_db number := 0;
2065: begin
2066: select u.creator_id
2067: into l_gosi_haz_asg_tu_mth_db
2068: from ff_user_entities u,
2069: ff_database_items d
2070: where d.user_name = 'GOSI_HAZARDS_ASG_TU_MONTH'
2071: and u.user_entity_id = d.user_entity_id
2072: and u.legislation_code = 'SA'
2073: and u.business_group_id is null
2074: and u.creator_type = 'B';
2075: select u.creator_id
2076: into l_emp_gosi_ann_asg_ptd_db
2077: from ff_user_entities u,
2078: ff_database_items d
2079: where d.user_name = 'GOSI_ANNUITIES_ASG_TU_MONTH'
2080: and u.user_entity_id = d.user_entity_id
2081: and u.legislation_code = 'SA'
3360: CLOSE get_upper_base;
3361: --get defined_balance_id
3362: select u.creator_id
3363: into l_defined_balance_id
3364: from ff_user_entities u,
3365: ff_database_items d
3366: where d.user_name = 'GOSI_REFERENCE_EARNINGS_ASG_YTD'
3367: and u.user_entity_id = d.user_entity_id
3368: and u.legislation_code = 'SA'