DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PAY_ACTION_PARAMETERS

Line 5292: l_logging pay_action_parameters.parameter_value%TYPE;

5288: l_security_profile_id number;
5289: l_action_parameter_group_id number;
5290: l_user_id number;
5291: l_security_profile_name per_security_profiles.security_profile_name%TYPE;
5292: l_logging pay_action_parameters.parameter_value%TYPE;
5293: l_request_id number;
5294: l_effective_date varchar2(50);
5295: l_update_date date;
5296: l_debug boolean := FALSE;

Line 5320: FROM pay_action_parameters pap

5316: -- should be switched on.
5317: --
5318: CURSOR csr_get_action_param IS
5319: SELECT pap.parameter_value
5320: FROM pay_action_parameters pap
5321: WHERE pap.parameter_name = 'LOGGING';
5322:
5323: CURSOR security_profiles
5324: IS

Line 5817: l_logging pay_action_parameters.parameter_value%type;

5813: l_found boolean default false;
5814: l_debug boolean := false;
5815: l_business_group_mode varchar2(30);
5816: l_proc varchar2(72) := g_package||'generate_lists';
5817: l_logging pay_action_parameters.parameter_value%type;
5818: l_process_all_users boolean default true;
5819: l_user_id number;
5820: --
5821: -- Fetch the action parameter to determine if logging

Line 5825: from pay_action_parameters pap

5821: -- Fetch the action parameter to determine if logging
5822: -- should be switched on.
5823: cursor csr_get_action_param is
5824: select pap.parameter_value
5825: from pay_action_parameters pap
5826: where pap.parameter_name = 'LOGGING';
5827: --
5828: cursor security_profiles is
5829: select *