APPS.PAY_SE_ALECTA dependencies on FF_DATABASE_ITEMS

Line 529: csr_v_balance_name ff_database_items.user_name%TYPE

525: ORDER BY as1.person_id
526: ,act.assignment_id;
527:
528: CURSOR csr_get_defined_balance_id (
529: csr_v_balance_name ff_database_items.user_name%TYPE
530: )
531: IS
532: SELECT ue.creator_id
533: FROM ff_user_entities ue

Line 534: ,ff_database_items di

530: )
531: IS
532: SELECT ue.creator_id
533: FROM ff_user_entities ue
534: ,ff_database_items di
535: WHERE di.user_name = csr_v_balance_name
536: AND ue.user_entity_id = di.user_entity_id
537: AND ue.legislation_code = 'SE'
538: AND ue.business_group_id IS NULL

Line 889: ,ff_database_items d

885: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
886: IS
887: SELECT u.creator_id
888: FROM ff_user_entities u
889: ,ff_database_items d
890: WHERE d.user_name = p_user_name
891: AND u.user_entity_id = d.user_entity_id
892: AND (u.legislation_code = 'SE')
893: AND (u.business_group_id IS NULL)

Line 978: csr_v_balance_name ff_database_items.user_name%TYPE

974: ,p_effective_date IN DATE
975: )
976: IS
977: CURSOR csr_get_defined_balance_id (
978: csr_v_balance_name ff_database_items.user_name%TYPE
979: )
980: IS
981: SELECT ue.creator_id
982: FROM ff_user_entities ue

Line 983: ,ff_database_items di

979: )
980: IS
981: SELECT ue.creator_id
982: FROM ff_user_entities ue
983: ,ff_database_items di
984: WHERE di.user_name = csr_v_balance_name
985: AND ue.user_entity_id = di.user_entity_id
986: AND ue.legislation_code = 'SE'
987: AND ue.business_group_id IS NULL