DBA Data[Home] [Help]

APPS.HR_BALANCE_FEEDS dependencies on PER_BUSINESS_GROUPS_PERF

Line 588: per_business_groups_perf ivbg,

584: pay_element_types_f et,
585: pay_element_classifications ec,
586: pay_balance_classifications bc,
587: pay_balance_types bt,
588: per_business_groups_perf ivbg,
589: per_business_groups_perf btbg
590: where bc.balance_classification_id = p_balance_classification_id
591: and ec.classification_id = bc.classification_id
592: and ec.parent_classification_id is null

Line 589: per_business_groups_perf btbg

585: pay_element_classifications ec,
586: pay_balance_classifications bc,
587: pay_balance_types bt,
588: per_business_groups_perf ivbg,
589: per_business_groups_perf btbg
590: where bc.balance_classification_id = p_balance_classification_id
591: and ec.classification_id = bc.classification_id
592: and ec.parent_classification_id is null
593: and bt.balance_type_id = bc.balance_type_id

Line 659: per_business_groups_perf ivbg,

655: pay_input_values_f iv,
656: pay_element_classifications ec,
657: pay_balance_classifications bc,
658: pay_balance_types bt,
659: per_business_groups_perf ivbg,
660: per_business_groups_perf btbg
661: where bc.balance_classification_id = p_balance_classification_id
662: and ec.classification_id = bc.classification_id
663: and ec.parent_classification_id is not null

Line 660: per_business_groups_perf btbg

656: pay_element_classifications ec,
657: pay_balance_classifications bc,
658: pay_balance_types bt,
659: per_business_groups_perf ivbg,
660: per_business_groups_perf btbg
661: where bc.balance_classification_id = p_balance_classification_id
662: and ec.classification_id = bc.classification_id
663: and ec.parent_classification_id is not null
664: and bt.balance_type_id = bc.balance_type_id

Line 866: per_business_groups_perf ivbg,

862: from pay_balance_types bt,
863: pay_balance_classifications bc,
864: pay_element_types_f et,
865: pay_input_values_f iv,
866: per_business_groups_perf ivbg,
867: per_business_groups_perf btbg
868: where iv.input_value_id = p_input_value_id
869: and et.element_type_id = iv.element_type_id
870: and bc.classification_id = et.classification_id

Line 867: per_business_groups_perf btbg

863: pay_balance_classifications bc,
864: pay_element_types_f et,
865: pay_input_values_f iv,
866: per_business_groups_perf ivbg,
867: per_business_groups_perf btbg
868: where iv.input_value_id = p_input_value_id
869: and et.element_type_id = iv.element_type_id
870: and bc.classification_id = et.classification_id
871: and bt.balance_type_id = bc.balance_type_id

Line 929: per_business_groups_perf ivbg,

925: pay_balance_classifications bc,
926: pay_balance_types bt,
927: pay_element_types_f et,
928: pay_sub_classification_rules_f scr,
929: per_business_groups_perf ivbg,
930: per_business_groups_perf btbg
931: where iv.input_value_id = p_input_value_id
932: and et.element_type_id = iv.element_type_id
933: and scr.element_type_id = et.element_type_id

Line 930: per_business_groups_perf btbg

926: pay_balance_types bt,
927: pay_element_types_f et,
928: pay_sub_classification_rules_f scr,
929: per_business_groups_perf ivbg,
930: per_business_groups_perf btbg
931: where iv.input_value_id = p_input_value_id
932: and et.element_type_id = iv.element_type_id
933: and scr.element_type_id = et.element_type_id
934: and bc.classification_id = scr.classification_id

Line 1051: per_business_groups_perf ivbg,

1047: pay_element_types_f et,
1048: pay_input_values_f iv,
1049: pay_balance_classifications bc,
1050: pay_balance_types bt,
1051: per_business_groups_perf ivbg,
1052: per_business_groups_perf btbg
1053: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1054: and bc.classification_id = scr.classification_id
1055: and bt.balance_type_id = bc.balance_type_id

Line 1052: per_business_groups_perf btbg

1048: pay_input_values_f iv,
1049: pay_balance_classifications bc,
1050: pay_balance_types bt,
1051: per_business_groups_perf ivbg,
1052: per_business_groups_perf btbg
1053: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1054: and bc.classification_id = scr.classification_id
1055: and bt.balance_type_id = bc.balance_type_id
1056: and et.element_type_id = scr.element_type_id

Line 1448: per_business_groups_perf ivbg,

1444: from pay_input_values_f iv,
1445: pay_element_types_f et,
1446: pay_element_classifications ec,
1447: pay_balance_types bt,
1448: per_business_groups_perf ivbg,
1449: per_business_groups_perf btbg
1450: where bt.balance_type_id = p_balance_type_id
1451: and ec.classification_id = p_classification_id
1452: and ec.parent_classification_id is null

Line 1449: per_business_groups_perf btbg

1445: pay_element_types_f et,
1446: pay_element_classifications ec,
1447: pay_balance_types bt,
1448: per_business_groups_perf ivbg,
1449: per_business_groups_perf btbg
1450: where bt.balance_type_id = p_balance_type_id
1451: and ec.classification_id = p_classification_id
1452: and ec.parent_classification_id is null
1453: and et.classification_id = ec.classification_id

Line 1493: per_business_groups_perf ivbg,

1489: pay_element_types_f et,
1490: pay_input_values_f iv,
1491: pay_element_classifications ec,
1492: pay_balance_types bt,
1493: per_business_groups_perf ivbg,
1494: per_business_groups_perf btbg
1495: where bt.balance_type_id = p_balance_type_id
1496: and ec.classification_id = p_classification_id
1497: and ec.parent_classification_id is not null

Line 1494: per_business_groups_perf btbg

1490: pay_input_values_f iv,
1491: pay_element_classifications ec,
1492: pay_balance_types bt,
1493: per_business_groups_perf ivbg,
1494: per_business_groups_perf btbg
1495: where bt.balance_type_id = p_balance_type_id
1496: and ec.classification_id = p_classification_id
1497: and ec.parent_classification_id is not null
1498: and scr.classification_id = ec.classification_id

Line 1606: per_business_groups_perf ivbg,

1602: pay_element_types_f et,
1603: pay_input_values_f iv,
1604: pay_balance_classifications bc,
1605: pay_balance_types bt,
1606: per_business_groups_perf ivbg,
1607: per_business_groups_perf btbg
1608: where bc.classification_id = p_classification_id
1609: and bt.balance_type_id = bc.balance_type_id
1610: and et.element_type_id = scr.element_type_id

Line 1607: per_business_groups_perf btbg

1603: pay_input_values_f iv,
1604: pay_balance_classifications bc,
1605: pay_balance_types bt,
1606: per_business_groups_perf ivbg,
1607: per_business_groups_perf btbg
1608: where bc.classification_id = p_classification_id
1609: and bt.balance_type_id = bc.balance_type_id
1610: and et.element_type_id = scr.element_type_id
1611: and iv.element_type_id = et.element_type_id