APPS.HR_PRE_PAY dependencies on PAY_BALANCE_TYPES

Line 896: pay_balance_types pbt,

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,

Line 1003: pay_balance_types pbt,

999: pre_payment_date,
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,

Line 1071: bus_leg pay_balance_types.legislation_code%type;

1067: --
1068: procedure get_ren_balance(p_bus_grp in number,
1069: p_def_bal_id in out nocopy number) is
1070: def_bal number;
1071: bus_leg pay_balance_types.legislation_code%type;
1072: bal_found boolean;
1073: begin
1074: --
1075: bal_found := FALSE;

Line 1081: from pay_balance_types pbt,

1077: select distinct pdb.defined_balance_id,
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'

Line 1106: from pay_balance_types pbt,

1102: select distinct pdb.defined_balance_id,
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