[Home] [Help]
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,
900: pay_org_payment_methods_f opm,
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,
1012: pay_org_payment_methods_f opm,
1072: --
1073: procedure get_ren_balance(p_bus_grp in number,
1074: p_def_bal_id in out nocopy number) is
1075: def_bal number;
1076: bus_leg pay_balance_types.legislation_code%type;
1077: bal_found boolean;
1078: begin
1079: --
1080: bal_found := FALSE;
1082: select distinct pdb.defined_balance_id,
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'
1107: select distinct pdb.defined_balance_id,
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