DBA Data[Home] [Help]

APPS.HR_US_GARN_GEN dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 525: pay_element_classifications ec

521: select bt.balance_type_id,
522: bc.scale
523: from pay_balance_types bt,
524: pay_balance_classifications bc,
525: pay_element_classifications ec
526: where bt.balance_type_id = bc.balance_type_id
527: and bc.classification_id = ec.classification_id
528: and nvl(bc.business_group_id, p_bg_id) + 0 = p_bg_id
529: and ec.classification_name = 'Involuntary Deductions'

Line 1058: from pay_element_classifications

1054: select classification_id,
1055: default_priority
1056: into g_ele_class_id,
1057: g_ele_priority
1058: from pay_element_classifications
1059: where UPPER(classification_name) = g_ele_classification
1060: and legislation_code = 'US';
1061: exception WHEN NO_DATA_FOUND THEN
1062: hr_utility.set_location('Could not find ''CLASSIFICATION'' ', 999);