APPS.PAY_SE_ALECTA dependencies on FF_DATABASE_ITEMS

Line 489: csr_v_balance_name ff_database_items.user_name%TYPE

485: ORDER BY as1.person_id
486: ,act.assignment_id;
487:
488: CURSOR csr_get_defined_balance_id (
489: csr_v_balance_name ff_database_items.user_name%TYPE
490: )
491: IS
492: SELECT ue.creator_id
493: FROM ff_user_entities ue

Line 494: ,ff_database_items di

490: )
491: IS
492: SELECT ue.creator_id
493: FROM ff_user_entities ue
494: ,ff_database_items di
495: WHERE di.user_name = csr_v_balance_name
496: AND ue.user_entity_id = di.user_entity_id
497: AND ue.legislation_code = 'SE'
498: AND ue.business_group_id IS NULL

Line 849: ,ff_database_items d

845: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
846: IS
847: SELECT u.creator_id
848: FROM ff_user_entities u
849: ,ff_database_items d
850: WHERE d.user_name = p_user_name
851: AND u.user_entity_id = d.user_entity_id
852: AND (u.legislation_code = 'SE')
853: AND (u.business_group_id IS NULL)

Line 938: csr_v_balance_name ff_database_items.user_name%TYPE

934: ,p_effective_date IN DATE
935: )
936: IS
937: CURSOR csr_get_defined_balance_id (
938: csr_v_balance_name ff_database_items.user_name%TYPE
939: )
940: IS
941: SELECT ue.creator_id
942: FROM ff_user_entities ue

Line 943: ,ff_database_items di

939: )
940: IS
941: SELECT ue.creator_id
942: FROM ff_user_entities ue
943: ,ff_database_items di
944: WHERE di.user_name = csr_v_balance_name
945: AND ue.user_entity_id = di.user_entity_id
946: AND ue.legislation_code = 'SE'
947: AND ue.business_group_id IS NULL