APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 535: pay_template_core_objects ptco

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
539: and ptco.shadow_object_id = psbt.balance_type_id;

Line 547: pay_template_core_objects ptco

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
551: and ptco.shadow_object_id = psbt.balance_type_id;

Line 557: pay_template_core_objects ptco

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
561: and ptco.shadow_object_id = psbt.balance_type_id;

Line 573: pay_template_core_objects ptco

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
577: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1105: pay_template_core_objects ptco

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
1109: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1114: pay_template_core_objects ptco

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
1118: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1123: pay_template_core_objects ptco

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
1127: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1132: pay_template_core_objects ptco

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
1136: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1141: pay_template_core_objects ptco

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
1145: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1150: pay_template_core_objects ptco

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
1154: and ptco.shadow_object_id = psbt.balance_type_id;

Line 1159: pay_template_core_objects ptco

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
1163: and ptco.shadow_object_id = psbt.balance_type_id;