DBA Data[Home] [Help]

APPS.CSTPPDOP dependencies on CST_LE_COST_TYPES

Line 37: CST_LE_COST_TYPES CLCT,

33:
34: select count(1)
35: into dummy
36: from
37: CST_LE_COST_TYPES CLCT,
38: CST_ACCT_INFO_V OOD,
39: MTL_PARAMETERS MP
40: where
41: clct.set_of_books_id = ood.LEDGER_ID

Line 70: FROM cst_le_cost_types clct

66: ret_num := 0;
67:
68: SELECT count(*)
69: INTO dummy
70: FROM cst_le_cost_types clct
71: WHERE clct.legal_entity = p_legal_entity
72: AND clct.cost_type_id <> p_cost_type_id
73: AND clct.set_of_books_id = (SELECT clct1.set_of_books_id
74: FROM cst_le_cost_types clct1

Line 74: FROM cst_le_cost_types clct1

70: FROM cst_le_cost_types clct
71: WHERE clct.legal_entity = p_legal_entity
72: AND clct.cost_type_id <> p_cost_type_id
73: AND clct.set_of_books_id = (SELECT clct1.set_of_books_id
74: FROM cst_le_cost_types clct1
75: WHERE clct1.cost_type_id = p_cost_type_id
76: AND clct1.legal_entity = p_legal_entity
77: AND clct.primary_cost_method > 2)
78: AND clct.post_to_gl = 'Y';

Line 104: cst_le_cost_types clct,

100:
101: SELECT count(1)
102: INTO dummy
103: FROM
104: cst_le_cost_types clct,
105: CST_ACCT_INFO_V ood,
106: mtl_parameters mp
107: WHERE
108: clct.set_of_books_id = ood.LEDGER_ID