DBA Data[Home] [Help]

APPS.HR_BALANCE_FEEDS dependencies on PER_BUSINESS_GROUPS_PERF

Line 598: per_business_groups_perf ivbg,

594: pay_element_types_f et,
595: pay_element_classifications ec,
596: pay_balance_classifications bc,
597: pay_balance_types bt,
598: per_business_groups_perf ivbg,
599: per_business_groups_perf btbg
600: where bc.balance_classification_id = p_balance_classification_id
601: and ec.classification_id = bc.classification_id
602: and ec.parent_classification_id is null

Line 599: per_business_groups_perf btbg

595: pay_element_classifications ec,
596: pay_balance_classifications bc,
597: pay_balance_types bt,
598: per_business_groups_perf ivbg,
599: per_business_groups_perf btbg
600: where bc.balance_classification_id = p_balance_classification_id
601: and ec.classification_id = bc.classification_id
602: and ec.parent_classification_id is null
603: and bt.balance_type_id = bc.balance_type_id

Line 669: per_business_groups_perf ivbg,

665: pay_input_values_f iv,
666: pay_element_classifications ec,
667: pay_balance_classifications bc,
668: pay_balance_types bt,
669: per_business_groups_perf ivbg,
670: per_business_groups_perf btbg
671: where bc.balance_classification_id = p_balance_classification_id
672: and ec.classification_id = bc.classification_id
673: and ec.parent_classification_id is not null

Line 670: per_business_groups_perf btbg

666: pay_element_classifications ec,
667: pay_balance_classifications bc,
668: pay_balance_types bt,
669: per_business_groups_perf ivbg,
670: per_business_groups_perf btbg
671: where bc.balance_classification_id = p_balance_classification_id
672: and ec.classification_id = bc.classification_id
673: and ec.parent_classification_id is not null
674: and bt.balance_type_id = bc.balance_type_id

Line 876: per_business_groups_perf ivbg,

872: from pay_balance_types bt,
873: pay_balance_classifications bc,
874: pay_element_types_f et,
875: pay_input_values_f iv,
876: per_business_groups_perf ivbg,
877: per_business_groups_perf btbg
878: where iv.input_value_id = p_input_value_id
879: and et.element_type_id = iv.element_type_id
880: and bc.classification_id = et.classification_id

Line 877: per_business_groups_perf btbg

873: pay_balance_classifications bc,
874: pay_element_types_f et,
875: pay_input_values_f iv,
876: per_business_groups_perf ivbg,
877: per_business_groups_perf btbg
878: where iv.input_value_id = p_input_value_id
879: and et.element_type_id = iv.element_type_id
880: and bc.classification_id = et.classification_id
881: and bt.balance_type_id = bc.balance_type_id

Line 939: per_business_groups_perf ivbg,

935: pay_balance_classifications bc,
936: pay_balance_types bt,
937: pay_element_types_f et,
938: pay_sub_classification_rules_f scr,
939: per_business_groups_perf ivbg,
940: per_business_groups_perf btbg
941: where iv.input_value_id = p_input_value_id
942: and et.element_type_id = iv.element_type_id
943: and scr.element_type_id = et.element_type_id

Line 940: per_business_groups_perf btbg

936: pay_balance_types bt,
937: pay_element_types_f et,
938: pay_sub_classification_rules_f scr,
939: per_business_groups_perf ivbg,
940: per_business_groups_perf btbg
941: where iv.input_value_id = p_input_value_id
942: and et.element_type_id = iv.element_type_id
943: and scr.element_type_id = et.element_type_id
944: and bc.classification_id = scr.classification_id

Line 1061: per_business_groups_perf ivbg,

1057: pay_element_types_f et,
1058: pay_input_values_f iv,
1059: pay_balance_classifications bc,
1060: pay_balance_types bt,
1061: per_business_groups_perf ivbg,
1062: per_business_groups_perf btbg
1063: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1064: and bc.classification_id = scr.classification_id
1065: and bt.balance_type_id = bc.balance_type_id

Line 1062: per_business_groups_perf btbg

1058: pay_input_values_f iv,
1059: pay_balance_classifications bc,
1060: pay_balance_types bt,
1061: per_business_groups_perf ivbg,
1062: per_business_groups_perf btbg
1063: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1064: and bc.classification_id = scr.classification_id
1065: and bt.balance_type_id = bc.balance_type_id
1066: and et.element_type_id = scr.element_type_id

Line 1458: per_business_groups_perf ivbg,

1454: from pay_input_values_f iv,
1455: pay_element_types_f et,
1456: pay_element_classifications ec,
1457: pay_balance_types bt,
1458: per_business_groups_perf ivbg,
1459: per_business_groups_perf btbg
1460: where bt.balance_type_id = p_balance_type_id
1461: and ec.classification_id = p_classification_id
1462: and ec.parent_classification_id is null

Line 1459: per_business_groups_perf btbg

1455: pay_element_types_f et,
1456: pay_element_classifications ec,
1457: pay_balance_types bt,
1458: per_business_groups_perf ivbg,
1459: per_business_groups_perf btbg
1460: where bt.balance_type_id = p_balance_type_id
1461: and ec.classification_id = p_classification_id
1462: and ec.parent_classification_id is null
1463: and et.classification_id = ec.classification_id

Line 1503: per_business_groups_perf ivbg,

1499: pay_element_types_f et,
1500: pay_input_values_f iv,
1501: pay_element_classifications ec,
1502: pay_balance_types bt,
1503: per_business_groups_perf ivbg,
1504: per_business_groups_perf btbg
1505: where bt.balance_type_id = p_balance_type_id
1506: and ec.classification_id = p_classification_id
1507: and ec.parent_classification_id is not null

Line 1504: per_business_groups_perf btbg

1500: pay_input_values_f iv,
1501: pay_element_classifications ec,
1502: pay_balance_types bt,
1503: per_business_groups_perf ivbg,
1504: per_business_groups_perf btbg
1505: where bt.balance_type_id = p_balance_type_id
1506: and ec.classification_id = p_classification_id
1507: and ec.parent_classification_id is not null
1508: and scr.classification_id = ec.classification_id

Line 1616: per_business_groups_perf ivbg,

1612: pay_element_types_f et,
1613: pay_input_values_f iv,
1614: pay_balance_classifications bc,
1615: pay_balance_types bt,
1616: per_business_groups_perf ivbg,
1617: per_business_groups_perf btbg
1618: where bc.classification_id = p_classification_id
1619: and bt.balance_type_id = bc.balance_type_id
1620: and et.element_type_id = scr.element_type_id

Line 1617: per_business_groups_perf btbg

1613: pay_input_values_f iv,
1614: pay_balance_classifications bc,
1615: pay_balance_types bt,
1616: per_business_groups_perf ivbg,
1617: per_business_groups_perf btbg
1618: where bc.classification_id = p_classification_id
1619: and bt.balance_type_id = bc.balance_type_id
1620: and et.element_type_id = scr.element_type_id
1621: and iv.element_type_id = et.element_type_id