DBA Data[Home] [Help]

APPS.PAY_MX_YEAREND_REP dependencies on PER_GEN_HIERARCHY_NODES

Line 66: FROM per_gen_hierarchy_nodes gre_node,

62: and fic.context_id = ffc.context_id
63: and ffc.context_name ='TAX_UNIT_ID'
64: and ltrim(rtrim(fic.context)) in(
65: SELECT DISTINCT gre_node.entity_id
66: FROM per_gen_hierarchy_nodes gre_node,
67: per_gen_hierarchy_nodes le_node,
68: per_gen_hierarchy_versions hier_ver,
69: fnd_lookup_values flv
70: WHERE gre_node.node_type = 'MX GRE'

Line 67: per_gen_hierarchy_nodes le_node,

63: and ffc.context_name ='TAX_UNIT_ID'
64: and ltrim(rtrim(fic.context)) in(
65: SELECT DISTINCT gre_node.entity_id
66: FROM per_gen_hierarchy_nodes gre_node,
67: per_gen_hierarchy_nodes le_node,
68: per_gen_hierarchy_versions hier_ver,
69: fnd_lookup_values flv
70: WHERE gre_node.node_type = 'MX GRE'
71: and gre_node.entity_id = fic.context