APPS.PAY_PAYWSDAS_PKG dependencies on FF_USER_ENTITIES

Line 39: , ff_user_entities ue

35: into p_data_type
36: , p_null_allowed
37: , p_notfound_allowed
38: from ff_database_items di
39: , ff_user_entities ue
40: , ff_routes fr
41: where di.user_name = p_operand_value
42: and ue.user_entity_id = di.user_entity_id
43: and (

Line 71: -- match against ff_database_items, ff_user_entities etc. more efficiently.

67: if ff_dbi_utils_pkg.translations_supported(p_legislation_code) then
68: --
69: -- For the translated database item case use a cursor FOR-loop to return
70: -- the tiny fraction of rows from ff_database_items_tl. The code can then
71: -- match against ff_database_items, ff_user_entities etc. more efficiently.
72: --
73: for dbitl in csr_dbitl(p_operand_value => p_operand_value) loop
74: begin
75: select di.data_type

Line 82: , ff_user_entities ue

78: into p_data_type
79: , p_null_allowed
80: , p_notfound_allowed
81: from ff_database_items di
82: , ff_user_entities ue
83: , ff_routes fr
84: where di.user_name = dbitl.user_name
85: and di.user_entity_id = dbitl.user_entity_id
86: and ue.user_entity_id = dbitl.user_entity_id

Line 377: l_notfound_allowed ff_user_entities.notfound_allowed_flag%type;

373: p_operand in varchar2) is
374: --
375: l_data_type ff_database_items.data_type%type;
376: l_null_allowed ff_database_items.null_allowed_flag%type;
377: l_notfound_allowed ff_user_entities.notfound_allowed_flag%type;
378: begin
379: --
380: begin
381: core_fetch_dbi_info