APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ACTION_PARAMETERS

Line 1084: from pay_action_parameters

1080:
1081: cursor csr_get_parameter is
1082: select parameter_name
1083: ,parameter_value
1084: from pay_action_parameters
1085: where parameter_name = p_prm_name;
1086: --
1087: l_proc varchar2(80) := g_package||'cache_action_prms';
1088: --

Line 1114: same reads of pay action parameters view.

1110: /* =====================================================================
1111: Name : Get Cache ActionPrm
1112: /* =====================================================================
1113: Purpose : Gets the event_id from a cached pl/sql table to prevent
1114: same reads of pay action parameters view.
1115: Returns : parameter value if found, null otherwise.
1116: ---------------------------------------------------------------------*/
1117: function get_cache_ActionPrm(p_prm_name in varchar2)
1118: return varchar2 is

Line 1149: same table scans on pay_action_parameters.

1145: /* ========================================================================
1146: Name : Get Action Parameter
1147: ========================================================================
1148: Purpose : Gets the Action Parameter from a cached pl/sql table to prevent
1149: same table scans on pay_action_parameters.
1150: Returns : parameter value.
1151: -----------------------------------------------------------------------*/
1152: function get_action_parameter(p_prm_name in varchar2)
1153: return varchar2 is