APPS.PAY_PPR_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 484: FROM per_assignment_status_types astp

480:
481: Cursor c_chk_assign_status_type
482: is
483: SELECT '1'
484: FROM per_assignment_status_types astp
485: WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
486: and ((astp.legislation_code =
487: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
488: or ( astp.legislation_code is null and

Line 568: l_assignment_status per_assignment_status_types.user_status%type;

564: ff.business_group_id is null));
565:
566: --
567: l_formula_type ff_formula_types.formula_type_name%type;
568: l_assignment_status per_assignment_status_types.user_status%type;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);
572: