APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_SFR_INS

Line 891: pay_sfr_ins.ins

887: --
888: -- Formula rules.
889: --
890:
891: pay_sfr_ins.ins
892: (p_formula_result_rule_id => l_id
893: ,p_shadow_element_type_id => l_base_element_id
894: ,p_result_name => 'dedn_amt'
895: ,p_result_rule_type => 'D'

Line 904: pay_sfr_ins.ins

900: );
901:
902: hr_utility.trace('Formula Rule - dedn_amt created.');
903:
904: pay_sfr_ins.ins
905: (p_formula_result_rule_id => l_id
906: ,p_shadow_element_type_id => l_base_element_id
907: ,p_result_name => 'STOP_ENTRY'
908: ,p_result_rule_type => 'S'

Line 917: pay_sfr_ins.ins

913: );
914:
915: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
916:
917: pay_sfr_ins.ins
918: (p_formula_result_rule_id => l_id
919: ,p_shadow_element_type_id => l_base_element_id
920: ,p_result_name => 'set_clear'
921: ,p_result_rule_type => 'U'

Line 931: pay_sfr_ins.ins

927: );
928:
929: hr_utility.trace('Formula Rule - set_clear created.');
930:
931: pay_sfr_ins.ins
932: (p_formula_result_rule_id => l_id
933: ,p_shadow_element_type_id => l_base_element_id
934: ,p_result_name => 'mesg'
935: ,p_result_rule_type => 'M'

Line 943: pay_sfr_ins.ins

939: );
940:
941: hr_utility.trace('Formula Rule - mesg created.');
942:
943: pay_sfr_ins.ins
944: (p_formula_result_rule_id => l_id
945: ,p_shadow_element_type_id => l_base_element_id
946: ,p_result_name => 'to_not_taken'
947: ,p_result_rule_type => 'I'

Line 956: pay_sfr_ins.ins

952: );
953:
954: hr_utility.trace('Formula Rule - to_not_taken created.');
955:
956: pay_sfr_ins.ins
957: (p_formula_result_rule_id => l_id
958: ,p_shadow_element_type_id => l_base_element_id
959: ,p_result_name => 'to_total_owed'
960: ,p_result_rule_type => 'I'

Line 970: pay_sfr_ins.ins

966: );
967:
968: hr_utility.trace('Formula Rule - to_total_owed created.');
969:
970: pay_sfr_ins.ins
971: (p_formula_result_rule_id => l_id
972: ,p_shadow_element_type_id => l_base_element_id
973: ,p_result_name => 'to_arrears'
974: ,p_result_rule_type => 'I'

Line 1450: pay_sfr_ins.ins

1446: --
1447: -- Formula rules.
1448: --
1449:
1450: pay_sfr_ins.ins
1451: (p_formula_result_rule_id => l_id
1452: ,p_shadow_element_type_id => l_base_element_id
1453: ,p_result_name => 'flat_amount'
1454: ,p_result_rule_type => 'D'

Line 1463: pay_sfr_ins.ins

1459: );
1460:
1461: hr_utility.trace('Formula Rule - flat_amount created.');
1462:
1463: pay_sfr_ins.ins
1464: (p_formula_result_rule_id => l_id
1465: ,p_shadow_element_type_id => l_base_element_id
1466: ,p_result_name => 'mesg'
1467: ,p_result_rule_type => 'M'

Line 2091: pay_sfr_ins.ins

2087: --
2088: -- Formula rules.
2089: --
2090:
2091: pay_sfr_ins.ins
2092: (p_formula_result_rule_id => l_id
2093: ,p_shadow_element_type_id => l_base_element_id
2094: ,p_result_name => 'earnings_amount'
2095: ,p_result_rule_type => 'D'

Line 2109: pay_sfr_ins.ins

2105: ** This is Indirect result to special feature element for
2106: ** Hours X Rate template check pycaehxr.sql
2107: ************/
2108:
2109: pay_sfr_ins.ins
2110: (p_formula_result_rule_id => l_id
2111: ,p_shadow_element_type_id => l_base_element_id
2112: ,p_result_name => 'earnings_hours'
2113: ,p_result_rule_type => 'D'

Line 2122: pay_sfr_ins.ins

2118: );
2119:
2120: hr_utility.trace('Formula Rule - earnings_hours created.');
2121:
2122: pay_sfr_ins.ins
2123: (p_formula_result_rule_id => l_id
2124: ,p_shadow_element_type_id => l_base_element_id
2125: ,p_result_name => 'mesg'
2126: ,p_result_rule_type => 'M'

Line 3103: pay_sfr_ins.ins

3099: --
3100: -- Formula rules.
3101: --
3102:
3103: pay_sfr_ins.ins
3104: (p_formula_result_rule_id => l_id
3105: ,p_shadow_element_type_id => l_base_element_id
3106: ,p_result_name => 'dedn_amt'
3107: ,p_result_rule_type => 'D'

Line 3116: pay_sfr_ins.ins

3112: );
3113:
3114: hr_utility.trace('Formula Rule - dedn_amt created.');
3115:
3116: pay_sfr_ins.ins
3117: (p_formula_result_rule_id => l_id
3118: ,p_shadow_element_type_id => l_base_element_id
3119: ,p_result_name => 'STOP_ENTRY'
3120: ,p_result_rule_type => 'S'

Line 3129: pay_sfr_ins.ins

3125: );
3126:
3127: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
3128:
3129: pay_sfr_ins.ins
3130: (p_formula_result_rule_id => l_id
3131: ,p_shadow_element_type_id => l_base_element_id
3132: ,p_result_name => 'set_clear'
3133: ,p_result_rule_type => 'U'

Line 3143: pay_sfr_ins.ins

3139: );
3140:
3141: hr_utility.trace('Formula Rule - set_clear created.');
3142:
3143: pay_sfr_ins.ins
3144: (p_formula_result_rule_id => l_id
3145: ,p_shadow_element_type_id => l_base_element_id
3146: ,p_result_name => 'mesg'
3147: ,p_result_rule_type => 'M'

Line 3155: pay_sfr_ins.ins

3151: );
3152:
3153: hr_utility.trace('Formula Rule - mesg created.');
3154:
3155: pay_sfr_ins.ins
3156: (p_formula_result_rule_id => l_id
3157: ,p_shadow_element_type_id => l_base_element_id
3158: ,p_result_name => 'to_not_taken'
3159: ,p_result_rule_type => 'I'

Line 3168: pay_sfr_ins.ins

3164: );
3165:
3166: hr_utility.trace('Formula Rule - to_not_taken created.');
3167:
3168: pay_sfr_ins.ins
3169: (p_formula_result_rule_id => l_id
3170: ,p_shadow_element_type_id => l_base_element_id
3171: ,p_result_name => 'to_total_owed'
3172: ,p_result_rule_type => 'I'

Line 3182: pay_sfr_ins.ins

3178: );
3179:
3180: hr_utility.trace('Formula Rule - to_total_owed created.');
3181:
3182: pay_sfr_ins.ins
3183: (p_formula_result_rule_id => l_id
3184: ,p_shadow_element_type_id => l_base_element_id
3185: ,p_result_name => 'to_arrears'
3186: ,p_result_rule_type => 'I'

Line 3790: pay_sfr_ins.ins

3786: --
3787: -- Formula rules.
3788: --
3789:
3790: pay_sfr_ins.ins
3791: (p_formula_result_rule_id => l_id
3792: ,p_shadow_element_type_id => l_base_element_id
3793: ,p_result_name => 'earnings_amount'
3794: ,p_result_rule_type => 'D'

Line 3803: pay_sfr_ins.ins

3799: );
3800:
3801: hr_utility.trace('Formula Rule - earnings_amount created.');
3802:
3803: pay_sfr_ins.ins
3804: (p_formula_result_rule_id => l_id
3805: ,p_shadow_element_type_id => l_base_element_id
3806: ,p_result_name => 'mesg'
3807: ,p_result_rule_type => 'M'