DBA Data[Home] [Help]

APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_SFR_INS

Line 912: pay_sfr_ins.ins

908: --
909: -- Formula rules.
910: --
911:
912: pay_sfr_ins.ins
913: (p_formula_result_rule_id => l_id
914: ,p_shadow_element_type_id => l_base_element_id
915: ,p_result_name => 'dedn_amt'
916: ,p_result_rule_type => 'D'

Line 925: pay_sfr_ins.ins

921: );
922:
923: hr_utility.trace('Formula Rule - dedn_amt created.');
924:
925: pay_sfr_ins.ins
926: (p_formula_result_rule_id => l_id
927: ,p_shadow_element_type_id => l_base_element_id
928: ,p_result_name => 'STOP_ENTRY'
929: ,p_result_rule_type => 'S'

Line 938: pay_sfr_ins.ins

934: );
935:
936: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
937:
938: pay_sfr_ins.ins
939: (p_formula_result_rule_id => l_id
940: ,p_shadow_element_type_id => l_base_element_id
941: ,p_result_name => 'set_clear'
942: ,p_result_rule_type => 'U'

Line 952: pay_sfr_ins.ins

948: );
949:
950: hr_utility.trace('Formula Rule - set_clear created.');
951:
952: pay_sfr_ins.ins
953: (p_formula_result_rule_id => l_id
954: ,p_shadow_element_type_id => l_base_element_id
955: ,p_result_name => 'mesg'
956: ,p_result_rule_type => 'M'

Line 964: pay_sfr_ins.ins

960: );
961:
962: hr_utility.trace('Formula Rule - mesg created.');
963:
964: pay_sfr_ins.ins
965: (p_formula_result_rule_id => l_id
966: ,p_shadow_element_type_id => l_base_element_id
967: ,p_result_name => 'to_not_taken'
968: ,p_result_rule_type => 'I'

Line 977: pay_sfr_ins.ins

973: );
974:
975: hr_utility.trace('Formula Rule - to_not_taken created.');
976:
977: pay_sfr_ins.ins
978: (p_formula_result_rule_id => l_id
979: ,p_shadow_element_type_id => l_base_element_id
980: ,p_result_name => 'to_total_owed'
981: ,p_result_rule_type => 'I'

Line 991: pay_sfr_ins.ins

987: );
988:
989: hr_utility.trace('Formula Rule - to_total_owed created.');
990:
991: pay_sfr_ins.ins
992: (p_formula_result_rule_id => l_id
993: ,p_shadow_element_type_id => l_base_element_id
994: ,p_result_name => 'to_arrears'
995: ,p_result_rule_type => 'I'

Line 1671: pay_sfr_ins.ins

1667: --
1668: -- Formula rules.
1669: --
1670:
1671: pay_sfr_ins.ins
1672: (p_formula_result_rule_id => l_id
1673: ,p_shadow_element_type_id => l_base_element_id
1674: ,p_result_name => 'flat_amount'
1675: ,p_result_rule_type => 'D'

Line 1684: pay_sfr_ins.ins

1680: );
1681:
1682: hr_utility.trace('Formula Rule - flat_amount created.');
1683:
1684: pay_sfr_ins.ins
1685: (p_formula_result_rule_id => l_id
1686: ,p_shadow_element_type_id => l_base_element_id
1687: ,p_result_name => 'mesg'
1688: ,p_result_rule_type => 'M'

Line 2472: pay_sfr_ins.ins

2468: --
2469: -- Formula rules.
2470: --
2471:
2472: pay_sfr_ins.ins
2473: (p_formula_result_rule_id => l_id
2474: ,p_shadow_element_type_id => l_base_element_id
2475: ,p_result_name => 'earnings_amount'
2476: ,p_result_rule_type => 'D'

Line 2490: pay_sfr_ins.ins

2486: ** This is Indirect result to special feature element for
2487: ** Hours X Rate template check pycaehxr.sql
2488: ************/
2489:
2490: pay_sfr_ins.ins
2491: (p_formula_result_rule_id => l_id
2492: ,p_shadow_element_type_id => l_base_element_id
2493: ,p_result_name => 'earnings_hours'
2494: ,p_result_rule_type => 'D'

Line 2503: pay_sfr_ins.ins

2499: );
2500:
2501: hr_utility.trace('Formula Rule - earnings_hours created.');
2502:
2503: pay_sfr_ins.ins
2504: (p_formula_result_rule_id => l_id
2505: ,p_shadow_element_type_id => l_base_element_id
2506: ,p_result_name => 'mesg'
2507: ,p_result_rule_type => 'M'

Line 3692: pay_sfr_ins.ins

3688: --
3689: -- Formula rules.
3690: --
3691:
3692: pay_sfr_ins.ins
3693: (p_formula_result_rule_id => l_id
3694: ,p_shadow_element_type_id => l_base_element_id
3695: ,p_result_name => 'dedn_amt'
3696: ,p_result_rule_type => 'D'

Line 3705: pay_sfr_ins.ins

3701: );
3702:
3703: hr_utility.trace('Formula Rule - dedn_amt created.');
3704:
3705: pay_sfr_ins.ins
3706: (p_formula_result_rule_id => l_id
3707: ,p_shadow_element_type_id => l_base_element_id
3708: ,p_result_name => 'STOP_ENTRY'
3709: ,p_result_rule_type => 'S'

Line 3718: pay_sfr_ins.ins

3714: );
3715:
3716: hr_utility.trace('Formula Rule - STOP_ENTRY created.');
3717:
3718: pay_sfr_ins.ins
3719: (p_formula_result_rule_id => l_id
3720: ,p_shadow_element_type_id => l_base_element_id
3721: ,p_result_name => 'set_clear'
3722: ,p_result_rule_type => 'U'

Line 3732: pay_sfr_ins.ins

3728: );
3729:
3730: hr_utility.trace('Formula Rule - set_clear created.');
3731:
3732: pay_sfr_ins.ins
3733: (p_formula_result_rule_id => l_id
3734: ,p_shadow_element_type_id => l_base_element_id
3735: ,p_result_name => 'mesg'
3736: ,p_result_rule_type => 'M'

Line 3744: pay_sfr_ins.ins

3740: );
3741:
3742: hr_utility.trace('Formula Rule - mesg created.');
3743:
3744: pay_sfr_ins.ins
3745: (p_formula_result_rule_id => l_id
3746: ,p_shadow_element_type_id => l_base_element_id
3747: ,p_result_name => 'to_not_taken'
3748: ,p_result_rule_type => 'I'

Line 3757: pay_sfr_ins.ins

3753: );
3754:
3755: hr_utility.trace('Formula Rule - to_not_taken created.');
3756:
3757: pay_sfr_ins.ins
3758: (p_formula_result_rule_id => l_id
3759: ,p_shadow_element_type_id => l_base_element_id
3760: ,p_result_name => 'to_total_owed'
3761: ,p_result_rule_type => 'I'

Line 3771: pay_sfr_ins.ins

3767: );
3768:
3769: hr_utility.trace('Formula Rule - to_total_owed created.');
3770:
3771: pay_sfr_ins.ins
3772: (p_formula_result_rule_id => l_id
3773: ,p_shadow_element_type_id => l_base_element_id
3774: ,p_result_name => 'to_arrears'
3775: ,p_result_rule_type => 'I'

Line 4593: pay_sfr_ins.ins

4589: --
4590: -- Formula rules.
4591: --
4592:
4593: pay_sfr_ins.ins
4594: (p_formula_result_rule_id => l_id
4595: ,p_shadow_element_type_id => l_base_element_id
4596: ,p_result_name => 'earnings_amount'
4597: ,p_result_rule_type => 'D'

Line 4606: pay_sfr_ins.ins

4602: );
4603:
4604: hr_utility.trace('Formula Rule - earnings_amount created.');
4605:
4606: pay_sfr_ins.ins
4607: (p_formula_result_rule_id => l_id
4608: ,p_shadow_element_type_id => l_base_element_id
4609: ,p_result_name => 'mesg'
4610: ,p_result_rule_type => 'M'