APPS.PAY_NL_ABP_REPORT dependencies on PER_SHARED_TYPES

Line 366: FROM per_shared_types

362: AND paa.assignment_action_id = c_assignment_action_id;
363: --=============================================================================
364: CURSOR csr_get_nationality(c_code VARCHAR2) IS
365: SELECT shared_type_name
366: FROM per_shared_types
367: WHERE lookup_type = 'NL_NATIONALITY'
368: AND information1 = c_code
369: ORDER BY 1;
370: --=============================================================================

Line 399: l_nationality per_shared_types.shared_type_name%TYPE;

395: , abp_pension_base;
396: --=============================================================================
397: --Variables--
398: TYPE tPayPeriodTable IS TABLE OF csr_pay_period_details%ROWTYPE INDEX BY BINARY_INTEGER;
399: l_nationality per_shared_types.shared_type_name%TYPE;
400: l_lang VARCHAR2(2) := userenv ('lang');
401: l_emp_details csr_emp_details%ROWTYPE;
402: l_asg_details csr_asg_details%ROWTYPE;
403: l_pay_count NUMBER :=0;