APPS.PAY_FI_ARCHIVE_LTFA dependencies on FF_DATABASE_ITEMS

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

685: AND act.TAX_UNIT_ID = act1.TAX_UNIT_ID
686: AND act.TAX_UNIT_ID = p_legal_employer_id
687: ORDER BY act.assignment_id;
688:
689: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
690: IS
691: SELECT ue.creator_id
692: FROM ff_user_entities ue,
693: ff_database_items di

Line 693: ff_database_items di

689: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
690: IS
691: SELECT ue.creator_id
692: FROM ff_user_entities ue,
693: ff_database_items di
694: WHERE di.user_name = csr_v_Balance_Name
695: AND ue.user_entity_id = di.user_entity_id
696: AND ue.legislation_code = 'FI'
697: AND ue.business_group_id is NULL

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

873: AND assign.assignment_id = pac.assignment_id
874: AND assign.person_id = pap.person_id
875: AND pap.per_information_category = 'FI';
876:
877: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
878: IS
879: SELECT ue.creator_id
880: FROM ff_user_entities ue,
881: ff_database_items di

Line 881: ff_database_items di

877: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
878: IS
879: SELECT ue.creator_id
880: FROM ff_user_entities ue,
881: ff_database_items di
882: WHERE di.user_name = csr_v_Balance_Name
883: AND ue.user_entity_id = di.user_entity_id
884: AND ue.legislation_code = 'FI'
885: AND ue.business_group_id is NULL

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

1093: AND action_information1 = 'PYFILTFA'
1094: AND action_information2 = 'PER'
1095: AND action_information10 = p_payroll_action_id ;
1096:
1097: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
1098: IS
1099: SELECT ue.creator_id
1100: FROM ff_user_entities ue,
1101: ff_database_items di

Line 1101: ff_database_items di

1097: Cursor csr_Get_Defined_Balance_Id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
1098: IS
1099: SELECT ue.creator_id
1100: FROM ff_user_entities ue,
1101: ff_database_items di
1102: WHERE di.user_name = csr_v_Balance_Name
1103: AND ue.user_entity_id = di.user_entity_id
1104: AND ue.legislation_code = 'FI'
1105: AND ue.business_group_id is NULL