APPS.PAY_SE_FORA dependencies on FF_DATABASE_ITEMS

Line 430: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)

426: AND nvl(hsck.segment10,'N')='N' /* Person is not CEO */
427: AND nvl(hsck.segment11,'N')='N' /* Person is not Owner/Joint Owner */
428: ORDER BY papf.person_id;
429:
430: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
431: IS
432: SELECT ue.creator_id
433: FROM ff_user_entities ue,
434: ff_database_items di

Line 434: ff_database_items di

430: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
431: IS
432: SELECT ue.creator_id
433: FROM ff_user_entities ue,
434: ff_database_items di
435: WHERE di.user_name = csr_v_Balance_Name
436: AND ue.user_entity_id = di.user_entity_id
437: AND ue.legislation_code = 'SE'
438: AND ue.business_group_id is NULL

Line 1646: FROM ff_user_entities u, ff_database_items d

1642: /* Cursor to retrieve Defined Balance Id */
1643: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1644: IS
1645: SELECT u.creator_id
1646: FROM ff_user_entities u, ff_database_items d
1647: WHERE d.user_name = p_user_name
1648: AND u.user_entity_id = d.user_entity_id
1649: AND (u.legislation_code = 'SE')
1650: AND (u.business_group_id IS NULL)

Line 1691: FROM ff_user_entities u, ff_database_items d

1687: /* Cursor to retrieve Defined Balance Id */
1688: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
1689: IS
1690: SELECT u.creator_id
1691: FROM ff_user_entities u, ff_database_items d
1692: WHERE d.user_name = p_user_name
1693: AND u.user_entity_id = d.user_entity_id
1694: AND (u.legislation_code = 'SE')
1695: AND (u.business_group_id IS NULL)