APPS.PAY_SE_INCOME_STATEMENT dependencies on FF_DATABASE_ITEMS

Line 871: csr_v_balance_name ff_database_items.user_name%TYPE

867: ORDER BY as1.person_id
868: ,act.assignment_id;
869:
870: CURSOR csr_get_defined_balance_id (
871: csr_v_balance_name ff_database_items.user_name%TYPE
872: )
873: IS
874: SELECT ue.creator_id
875: FROM ff_user_entities ue

Line 876: ,ff_database_items di

872: )
873: IS
874: SELECT ue.creator_id
875: FROM ff_user_entities ue
876: ,ff_database_items di
877: WHERE di.user_name = csr_v_balance_name
878: AND ue.user_entity_id = di.user_entity_id
879: AND ue.legislation_code = 'SE'
880: AND ue.business_group_id IS NULL

Line 1626: ,ff_database_items d

1622: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1623: IS
1624: SELECT u.creator_id
1625: FROM ff_user_entities u
1626: ,ff_database_items d
1627: WHERE d.user_name = p_user_name
1628: AND u.user_entity_id = d.user_entity_id
1629: AND (u.legislation_code = 'SE')
1630: AND (u.business_group_id IS NULL)

Line 1674: ,ff_database_items d

1670: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1671: IS
1672: SELECT u.creator_id
1673: FROM ff_user_entities u
1674: ,ff_database_items d
1675: WHERE d.user_name = p_user_name
1676: AND u.user_entity_id = d.user_entity_id
1677: AND (u.legislation_code = 'SE')
1678: AND (u.business_group_id IS NULL)

Line 1781: csr_v_balance_name ff_database_items.user_name%TYPE

1777: ,p_effective_date IN DATE
1778: )
1779: IS
1780: CURSOR csr_get_defined_balance_id (
1781: csr_v_balance_name ff_database_items.user_name%TYPE
1782: )
1783: IS
1784: SELECT ue.creator_id
1785: FROM ff_user_entities ue

Line 1786: ,ff_database_items di

1782: )
1783: IS
1784: SELECT ue.creator_id
1785: FROM ff_user_entities ue
1786: ,ff_database_items di
1787: WHERE di.user_name = csr_v_balance_name
1788: AND ue.user_entity_id = di.user_entity_id
1789: AND ue.legislation_code = 'SE'
1790: AND ue.business_group_id IS NULL