APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_ACTION_PARAMETERS

Line 988: from pay_action_parameters

984:
985: cursor csr_get_parameter is
986: select parameter_name
987: ,parameter_value
988: from pay_action_parameters
989: where parameter_name = p_prm_name;
990: --
991: l_proc varchar2(80) := g_package||'cache_action_prms';
992: --

Line 1018: same reads of pay action parameters view.

1014: /* =====================================================================
1015: Name : Get Cache ActionPrm
1016: /* =====================================================================
1017: Purpose : Gets the event_id from a cached pl/sql table to prevent
1018: same reads of pay action parameters view.
1019: Returns : parameter value if found, null otherwise.
1020: ---------------------------------------------------------------------*/
1021: function get_cache_ActionPrm(p_prm_name in varchar2)
1022: return varchar2 is

Line 1053: same table scans on pay_action_parameters.

1049: /* ========================================================================
1050: Name : Get Action Parameter
1051: ========================================================================
1052: Purpose : Gets the Action Parameter from a cached pl/sql table to prevent
1053: same table scans on pay_action_parameters.
1054: Returns : parameter value.
1055: -----------------------------------------------------------------------*/
1056: function get_action_parameter(p_prm_name in varchar2)
1057: return varchar2 is