APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_SHADOW_BALANCE_TYPES

Line 534: from pay_shadow_balance_types psbt,

530: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',14);
531: --
532: select ptco.core_object_id
533: into l_pri_bal_id
534: from pay_shadow_balance_types psbt,
535: pay_template_core_objects ptco
536: where psbt.template_id = l_template_id
537: and psbt.balance_name = p_ele_name
538: and ptco.template_id = psbt.template_id

Line 546: from pay_shadow_balance_types psbt,

542: --
543: if l_arrearage_create = 'Y' then
544: select ptco.core_object_id
545: into l_arr_bal_id
546: from pay_shadow_balance_types psbt,
547: pay_template_core_objects ptco
548: where psbt.template_id = l_template_id
549: and psbt.balance_name = p_ele_name||' Arrears'
550: and ptco.template_id = psbt.template_id

Line 556: from pay_shadow_balance_types psbt,

552:
553: --
554: select ptco.core_object_id
555: into l_not_taken_bal_id
556: from pay_shadow_balance_types psbt,
557: pay_template_core_objects ptco
558: where psbt.template_id = l_template_id
559: and psbt.balance_name = p_ele_name||' Not Taken'
560: and ptco.template_id = psbt.template_id

Line 572: from pay_shadow_balance_types psbt,

568: --
569: if l_total_owed_create = 'Y' then
570: select ptco.core_object_id
571: into l_accr_bal_id
572: from pay_shadow_balance_types psbt,
573: pay_template_core_objects ptco
574: where psbt.template_id = l_template_id
575: and psbt.balance_name = p_ele_name||' Accrued'
576: and ptco.template_id = psbt.template_id

Line 1104: from pay_shadow_balance_types psbt,

1100:
1101: --
1102: select ptco.core_object_id
1103: into l_pri_bal_id
1104: from pay_shadow_balance_types psbt,
1105: pay_template_core_objects ptco
1106: where psbt.template_id = l_template_id
1107: and psbt.balance_name = p_ele_name
1108: and ptco.template_id = psbt.template_id

Line 1113: from pay_shadow_balance_types psbt,

1109: and ptco.shadow_object_id = psbt.balance_type_id;
1110: --
1111: select ptco.core_object_id
1112: into l_repl_bal_id
1113: from pay_shadow_balance_types psbt,
1114: pay_template_core_objects ptco
1115: where psbt.template_id = l_template_id
1116: and psbt.balance_name = p_ele_name||' Replacement'
1117: and ptco.template_id = psbt.template_id

Line 1122: from pay_shadow_balance_types psbt,

1118: and ptco.shadow_object_id = psbt.balance_type_id;
1119: --
1120: select ptco.core_object_id
1121: into l_addl_bal_id
1122: from pay_shadow_balance_types psbt,
1123: pay_template_core_objects ptco
1124: where psbt.template_id = l_template_id
1125: and psbt.balance_name = p_ele_name||' Additional'
1126: and ptco.template_id = psbt.template_id

Line 1131: from pay_shadow_balance_types psbt,

1127: and ptco.shadow_object_id = psbt.balance_type_id;
1128: --
1129: select ptco.core_object_id
1130: into l_not_taken_bal_id
1131: from pay_shadow_balance_types psbt,
1132: pay_template_core_objects ptco
1133: where psbt.template_id = l_template_id
1134: and psbt.balance_name = p_ele_name||' Not Taken'
1135: and ptco.template_id = psbt.template_id

Line 1140: from pay_shadow_balance_types psbt,

1136: and ptco.shadow_object_id = psbt.balance_type_id;
1137: --
1138: select ptco.core_object_id
1139: into l_accr_bal_id
1140: from pay_shadow_balance_types psbt,
1141: pay_template_core_objects ptco
1142: where psbt.template_id = l_template_id
1143: and psbt.balance_name = p_ele_name||' Accrued'
1144: and ptco.template_id = psbt.template_id

Line 1149: from pay_shadow_balance_types psbt,

1145: and ptco.shadow_object_id = psbt.balance_type_id;
1146: --
1147: select ptco.core_object_id
1148: into l_fees_bal_id
1149: from pay_shadow_balance_types psbt,
1150: pay_template_core_objects ptco
1151: where psbt.template_id = l_template_id
1152: and psbt.balance_name = p_ele_name||' Fees'
1153: and ptco.template_id = psbt.template_id

Line 1158: from pay_shadow_balance_types psbt,

1154: and ptco.shadow_object_id = psbt.balance_type_id;
1155: --
1156: select ptco.core_object_id
1157: into l_arr_bal_id
1158: from pay_shadow_balance_types psbt,
1159: pay_template_core_objects ptco
1160: where psbt.template_id = l_template_id
1161: and psbt.balance_name = p_ele_name||' Arrears'
1162: and ptco.template_id = psbt.template_id