APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 833: csr_v_balance_name ff_database_items.user_name%TYPE

829: )
830: RETURN NUMBER
831: IS
832: CURSOR csr_get_defined_balance_id (
833: csr_v_balance_name ff_database_items.user_name%TYPE
834: )
835: IS
836: SELECT defined_balance_id
837: FROM pay_balance_types pbt,

Line 858: FROM ff_user_entities ue, ff_database_items di

854: WHERE paa_run.assignment_id = paa_archive.assignment_id
855: AND paa_run.payroll_action_id = g_run_payroll_action_id
856: AND paa_archive.assignment_action_id = p_assignment_action_id;
857: /* SELECT ue.creator_id
858: FROM ff_user_entities ue, ff_database_items di
859: WHERE di.user_name = csr_v_balance_name
860: AND ue.user_entity_id = di.user_entity_id
861: AND ue.legislation_code = 'FI';
862: -- AND ue.business_group_id IS NULL temporary commented