APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on FF_DATABASE_ITEMS

Line 569: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE

565:
566:
567: /* Cursor to retrieve Defined Balance Id */
568: Cursor csr_bg_get_defined_balance_id
569: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE
570: ,p_business_group_id NUMBER)
571: IS
572: SELECT ue.creator_id
573: FROM ff_user_entities ue,

Line 574: ff_database_items di

570: ,p_business_group_id NUMBER)
571: IS
572: SELECT ue.creator_id
573: FROM ff_user_entities ue,
574: ff_database_items di
575: WHERE di.user_name = csr_v_Balance_Name
576: AND ue.user_entity_id = di.user_entity_id
577: AND ue.legislation_code is NULL
578: AND ue.business_group_id = p_business_group_id

Line 2382: ,ff_database_items d

2378: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2379: IS
2380: SELECT u.creator_id
2381: FROM ff_user_entities u
2382: ,ff_database_items d
2383: WHERE d.user_name = p_user_name
2384: AND u.user_entity_id = d.user_entity_id
2385: AND (u.legislation_code = 'SE')
2386: AND (u.business_group_id IS NULL)

Line 2430: ,ff_database_items d

2426: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2427: IS
2428: SELECT u.creator_id
2429: FROM ff_user_entities u
2430: ,ff_database_items d
2431: WHERE d.user_name = p_user_name
2432: AND u.user_entity_id = d.user_entity_id
2433: AND (u.legislation_code = 'SE')
2434: AND (u.business_group_id IS NULL)