DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_BALANCE_DIMENSIONS

Line 895: from pay_balance_dimensions pbd,

891: pre_payment_date,
892: negative_pay,
893: payroll,
894: pay_bg_id
895: from pay_balance_dimensions pbd,
896: pay_balance_types pbt,
897: pay_defined_balances pdb,
898: pay_payment_types ppt,
899: pay_all_payrolls_f pp,

Line 1007: pay_balance_dimensions pbd,

1003: negative_pay,
1004: pre_payment_date,
1005: pay_bg_id
1006: from pay_all_payrolls_f pp,
1007: pay_balance_dimensions pbd,
1008: pay_balance_types pbt,
1009: pay_defined_balances pdb,
1010: pay_payment_types ppt,
1011: pay_org_pay_method_usages_f pmu,

Line 1088: pay_balance_dimensions pbd

1084: into def_bal,
1085: balance_currency
1086: from pay_balance_types pbt,
1087: pay_defined_balances pdb,
1088: pay_balance_dimensions pbd
1089: where pbt.business_group_id = p_bus_grp
1090: and pbt.assignment_remuneration_flag = 'Y'
1091: and pbt.balance_type_id = pdb.balance_type_id
1092: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1113: pay_balance_dimensions pbd

1109: into def_bal,
1110: balance_currency
1111: from pay_balance_types pbt,
1112: pay_defined_balances pdb,
1113: pay_balance_dimensions pbd
1114: where pbt.business_group_id is null
1115: and pbt.legislation_code = bus_leg
1116: and pbt.assignment_remuneration_flag = 'Y'
1117: and pbt.balance_type_id = pdb.balance_type_id