DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_DEFINED_BALANCES

Line 897: pay_defined_balances pdb,

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,
900: pay_org_payment_methods_f opm,
901: pay_payroll_actions ppa

Line 1009: pay_defined_balances pdb,

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,
1012: pay_org_payment_methods_f opm,
1013: pay_payroll_actions ppa

Line 1087: pay_defined_balances pdb,

1083: pbt.currency_code
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

Line 1112: pay_defined_balances pdb,

1108: pbt.currency_code
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'