APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on FF_DATABASE_ITEMS

Line 596: csr_v_balance_name ff_database_items.user_name%TYPE

592: AND as1.effective_end_date
593: ORDER BY as1.person_id, act.assignment_id;
594:
595: CURSOR csr_get_defined_balance_id (
596: csr_v_balance_name ff_database_items.user_name%TYPE
597: )
598: IS
599: SELECT ue.creator_id
600: FROM ff_user_entities ue, ff_database_items di

Line 600: FROM ff_user_entities ue, ff_database_items di

596: csr_v_balance_name ff_database_items.user_name%TYPE
597: )
598: IS
599: SELECT ue.creator_id
600: FROM ff_user_entities ue, ff_database_items di
601: WHERE di.user_name = csr_v_balance_name
602: AND ue.user_entity_id = di.user_entity_id
603: AND ue.legislation_code = 'SE'
604: AND ue.business_group_id IS NULL

Line 804: FROM ff_user_entities u, ff_database_items d

800: /* Cursor to retrieve Defined Balance Id */
801: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
802: IS
803: SELECT u.creator_id
804: FROM ff_user_entities u, ff_database_items d
805: WHERE d.user_name = p_user_name
806: AND u.user_entity_id = d.user_entity_id
807: AND (u.legislation_code = 'SE')
808: AND (u.business_group_id IS NULL)

Line 851: FROM ff_user_entities u, ff_database_items d

847: /* Cursor to retrieve Defined Balance Id */
848: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
849: IS
850: SELECT u.creator_id
851: FROM ff_user_entities u, ff_database_items d
852: WHERE d.user_name = p_user_name
853: AND u.user_entity_id = d.user_entity_id
854: AND (u.legislation_code = 'SE')
855: AND (u.business_group_id IS NULL)

Line 906: csr_v_balance_name ff_database_items.user_name%TYPE

902: , p_effective_date IN DATE
903: )
904: IS
905: CURSOR csr_get_defined_balance_id (
906: csr_v_balance_name ff_database_items.user_name%TYPE
907: )
908: IS
909: SELECT ue.creator_id
910: FROM ff_user_entities ue, ff_database_items di

Line 910: FROM ff_user_entities ue, ff_database_items di

906: csr_v_balance_name ff_database_items.user_name%TYPE
907: )
908: IS
909: SELECT ue.creator_id
910: FROM ff_user_entities ue, ff_database_items di
911: WHERE di.user_name = csr_v_balance_name
912: AND ue.user_entity_id = di.user_entity_id
913: AND ue.legislation_code = 'SE'
914: AND ue.business_group_id IS NULL