APPS.PAY_FI_ARCHIVE_DPSA dependencies on FF_DATABASE_ITEMS

Line 763: Cursor csr_get_defined_balance_id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)

759:
760: rg_csr_get_person_details csr_get_person_details%rowtype;
761:
762: /* Cursor to retrieve Defined Balance Id */
763: Cursor csr_get_defined_balance_id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
764: IS
765: SELECT ue.creator_id
766: FROM ff_user_entities ue,
767: ff_database_items di

Line 767: ff_database_items di

763: Cursor csr_get_defined_balance_id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
764: IS
765: SELECT ue.creator_id
766: FROM ff_user_entities ue,
767: ff_database_items di
768: WHERE di.user_name = csr_v_Balance_Name
769: AND ue.user_entity_id = di.user_entity_id
770: AND ue.legislation_code = 'FI'
771: AND ue.business_group_id is NULL

Line 778: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE

774: rg_csr_get_defined_balance_id csr_get_defined_balance_id%rowtype;
775:
776: /* Cursor to retrieve Defined Balance Id */
777: Cursor csr_bg_get_defined_balance_id
778: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE
779: ,p_business_group_id NUMBER)
780: IS
781: SELECT ue.creator_id
782: FROM ff_user_entities ue,

Line 783: ff_database_items di

779: ,p_business_group_id NUMBER)
780: IS
781: SELECT ue.creator_id
782: FROM ff_user_entities ue,
783: ff_database_items di
784: WHERE di.user_name = csr_v_Balance_Name
785: AND ue.user_entity_id = di.user_entity_id
786: AND ue.legislation_code is NULL
787: AND ue.business_group_id = p_business_group_id