APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on FF_DATABASE_ITEMS

Line 567: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE

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

Line 572: ff_database_items di

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

Line 2342: ,ff_database_items d

2338: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2339: IS
2340: SELECT u.creator_id
2341: FROM ff_user_entities u
2342: ,ff_database_items d
2343: WHERE d.user_name = p_user_name
2344: AND u.user_entity_id = d.user_entity_id
2345: AND (u.legislation_code = 'SE')
2346: AND (u.business_group_id IS NULL)

Line 2390: ,ff_database_items d

2386: CURSOR csr_def_bal_id (p_user_name VARCHAR2)
2387: IS
2388: SELECT u.creator_id
2389: FROM ff_user_entities u
2390: ,ff_database_items d
2391: WHERE d.user_name = p_user_name
2392: AND u.user_entity_id = d.user_entity_id
2393: AND (u.legislation_code = 'SE')
2394: AND (u.business_group_id IS NULL)