APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PAY_DEFINED_BALANCES

Line 1093: ,pay_defined_balances PDB

1089: IS
1090: SELECT PDB.defined_balance_id
1091: FROM pay_balance_types PBT
1092: ,pay_balance_dimensions PBD
1093: ,pay_defined_balances PDB
1094: WHERE PBT.balance_name = 'B_TRM_INCOME_EXM'
1095: AND PBD.database_item_suffix = '_ASG_RUN'
1096: AND PBT.balance_type_id = PDB.balance_type_id
1097: AND PBD.balance_dimension_id = PDB.balance_dimension_id;

Line 1104: ,pay_defined_balances PDB

1100: IS
1101: SELECT PDB.defined_balance_id
1102: FROM pay_balance_types PBT
1103: ,pay_balance_dimensions PBD
1104: ,pay_defined_balances PDB
1105: WHERE PBT.balance_name = 'B_TRM_INC_DEDN_SPC_EXC'
1106: AND PBD.database_item_suffix = '_ASG_RUN'
1107: AND PBT.balance_type_id = PDB.balance_type_id
1108: AND PBD.balance_dimension_id = PDB.balance_dimension_id;

Line 1165: ln_def_balance_id pay_defined_balances.defined_balance_id%TYPE;

1161: ln_termination_money NUMBER;
1162: ln_withholidng_tax NUMBER;
1163: ln_muncipal_tax NUMBER;
1164: ln_prefectural_tax NUMBER;
1165: ln_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
1166: ln_def_balance_id_spc pay_defined_balances.defined_balance_id%TYPE;
1167: ln_term_ded_amt NUMBER;
1168: ln_term_ded_amt_spc NUMBER;
1169: ln_amt NUMBER;

Line 1166: ln_def_balance_id_spc pay_defined_balances.defined_balance_id%TYPE;

1162: ln_withholidng_tax NUMBER;
1163: ln_muncipal_tax NUMBER;
1164: ln_prefectural_tax NUMBER;
1165: ln_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
1166: ln_def_balance_id_spc pay_defined_balances.defined_balance_id%TYPE;
1167: ln_term_ded_amt NUMBER;
1168: ln_term_ded_amt_spc NUMBER;
1169: ln_amt NUMBER;
1170: ln_term_ass_act_id pay_assignment_actions.assignment_action_id%TYPE;