APPS.PAY_SE_INCOME_STATEMENT dependencies on FF_DATABASE_ITEMS

Line 877: csr_v_balance_name ff_database_items.user_name%TYPE

873: ORDER BY as1.person_id
874: ,act.assignment_id;
875:
876: CURSOR csr_get_defined_balance_id (
877: csr_v_balance_name ff_database_items.user_name%TYPE
878: )
879: IS
880: SELECT ue.creator_id
881: FROM ff_user_entities ue

Line 882: ,ff_database_items di

878: )
879: IS
880: SELECT ue.creator_id
881: FROM ff_user_entities ue
882: ,ff_database_items di
883: WHERE di.user_name = csr_v_balance_name
884: AND ue.user_entity_id = di.user_entity_id
885: AND ue.legislation_code = 'SE'
886: AND ue.business_group_id IS NULL

Line 1632: ,ff_database_items d

1628: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1629: IS
1630: SELECT u.creator_id
1631: FROM ff_user_entities u
1632: ,ff_database_items d
1633: WHERE d.user_name = p_user_name
1634: AND u.user_entity_id = d.user_entity_id
1635: AND (u.legislation_code = 'SE')
1636: AND (u.business_group_id IS NULL)

Line 1680: ,ff_database_items d

1676: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1677: IS
1678: SELECT u.creator_id
1679: FROM ff_user_entities u
1680: ,ff_database_items d
1681: WHERE d.user_name = p_user_name
1682: AND u.user_entity_id = d.user_entity_id
1683: AND (u.legislation_code = 'SE')
1684: AND (u.business_group_id IS NULL)

Line 1787: csr_v_balance_name ff_database_items.user_name%TYPE

1783: ,p_effective_date IN DATE
1784: )
1785: IS
1786: CURSOR csr_get_defined_balance_id (
1787: csr_v_balance_name ff_database_items.user_name%TYPE
1788: )
1789: IS
1790: SELECT ue.creator_id
1791: FROM ff_user_entities ue

Line 1792: ,ff_database_items di

1788: )
1789: IS
1790: SELECT ue.creator_id
1791: FROM ff_user_entities ue
1792: ,ff_database_items di
1793: WHERE di.user_name = csr_v_balance_name
1794: AND ue.user_entity_id = di.user_entity_id
1795: AND ue.legislation_code = 'SE'
1796: AND ue.business_group_id IS NULL