APPS.PAY_FI_ARCHIVE_TEL dependencies on FF_DATABASE_ITEMS

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

730: AND act.TAX_UNIT_ID = act1.TAX_UNIT_ID
731: AND act.TAX_UNIT_ID = p_legal_employer_id
732: ORDER BY act.assignment_id;
733:
734: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
735: IS
736: SELECT ue.creator_id
737: FROM ff_user_entities ue,
738: ff_database_items di

Line 738: ff_database_items di

734: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
735: IS
736: SELECT ue.creator_id
737: FROM ff_user_entities ue,
738: ff_database_items di
739: WHERE di.user_name = csr_v_Balance_Name
740: AND ue.user_entity_id = di.user_entity_id
741: AND ue.legislation_code = 'FI'
742: AND ue.business_group_id is NULL

Line 968: ff_database_items d

964: /* Cursor to retrieve Defined Balance Id */
965: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
966: SELECT u.creator_id
967: FROM ff_user_entities u,
968: ff_database_items d
969: WHERE d.user_name = p_user_name
970: AND u.user_entity_id = d.user_entity_id
971: AND (u.legislation_code = 'FI' )
972: AND (u.business_group_id IS NULL )

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

993: p_assignment_action_id IN NUMBER
994: ,p_effective_date IN DATE)
995: IS
996: /* Cursor to retrieve Archive Payroll Action Id */
997: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
998: IS
999: SELECT ue.creator_id
1000: FROM ff_user_entities ue,
1001: ff_database_items di

Line 1001: ff_database_items di

997: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
998: IS
999: SELECT ue.creator_id
1000: FROM ff_user_entities ue,
1001: ff_database_items di
1002: WHERE di.user_name = csr_v_Balance_Name
1003: AND ue.user_entity_id = di.user_entity_id
1004: AND ue.legislation_code = 'FI'
1005: AND ue.business_group_id is NULL