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 1004: pay_defined_balances pdb,

1000: pay_bg_id
1001: from pay_all_payrolls_f pp,
1002: pay_balance_dimensions pbd,
1003: pay_balance_types pbt,
1004: pay_defined_balances pdb,
1005: pay_payment_types ppt,
1006: pay_org_pay_method_usages_f pmu,
1007: pay_org_payment_methods_f opm,
1008: pay_payroll_actions ppa

Line 1082: pay_defined_balances pdb,

1078: pbt.currency_code
1079: into def_bal,
1080: balance_currency
1081: from pay_balance_types pbt,
1082: pay_defined_balances pdb,
1083: pay_balance_dimensions pbd
1084: where pbt.business_group_id = p_bus_grp
1085: and pbt.assignment_remuneration_flag = 'Y'
1086: and pbt.balance_type_id = pdb.balance_type_id

Line 1107: pay_defined_balances pdb,

1103: pbt.currency_code
1104: into def_bal,
1105: balance_currency
1106: from pay_balance_types pbt,
1107: pay_defined_balances pdb,
1108: pay_balance_dimensions pbd
1109: where pbt.business_group_id is null
1110: and pbt.legislation_code = bus_leg
1111: and pbt.assignment_remuneration_flag = 'Y'