APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_SHADOW_BALANCE_TYPES

Line 531: from pay_shadow_balance_types psbt,

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

Line 543: from pay_shadow_balance_types psbt,

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

Line 553: from pay_shadow_balance_types psbt,

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

Line 569: from pay_shadow_balance_types psbt,

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

Line 1101: from pay_shadow_balance_types psbt,

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

Line 1110: from pay_shadow_balance_types psbt,

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

Line 1119: from pay_shadow_balance_types psbt,

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

Line 1128: from pay_shadow_balance_types psbt,

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

Line 1137: from pay_shadow_balance_types psbt,

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

Line 1146: from pay_shadow_balance_types psbt,

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

Line 1155: from pay_shadow_balance_types psbt,

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