DBA Data[Home] [Help]

APPS.PAY_BAL_CLASSIFICATIONS_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 71: from pay_element_classifications ecl

67: ) is
68: --
69: cursor csr_unique_bal_classification (p_startup_mode varchar2) is
70: select ecl.classification_id
71: from pay_element_classifications ecl
72: where ecl.classification_id = p_classification_id
73: and not exists
74: (select null
75: from pay_balance_classifications bcl

Line 86: pay_element_classifications ecl2

82: and ((ecl.parent_classification_id is null and
83: not exists
84: (select null
85: from pay_balance_classifications bcl2,
86: pay_element_classifications ecl2
87: where bcl2.balance_type_id = p_balance_type_id
88: and ecl2.classification_id = bcl2.classification_id
89: and ecl2.parent_classification_id = ecl.classification_id
90: and (p_row_id is null or

Line 97: pay_element_classifications ecl3

93: or (ecl.parent_classification_id is not null and
94: not exists
95: (select null
96: from pay_balance_classifications bcl3,
97: pay_element_classifications ecl3
98: where bcl3.balance_type_id = p_balance_type_id
99: and ecl3.classification_id = bcl3.classification_id
100: and (ecl3.parent_classification_id =
101: ecl.parent_classification_id or