eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_ACTION_INFORMATION

Line 690: pay_action_information_api.create_action_information

686: OPEN csr_month(g_month);
687: FETCH csr_month INTO l_month;
688: CLOSE csr_month;
689: -- Insert the report Parameters
690: pay_action_information_api.create_action_information
691: (p_action_information_id => l_action_info_id
692: , p_action_context_id => p_payroll_action_id
693: , p_action_context_type => 'PA'
694: , p_object_version_number => l_ovn

Line 1120: select 1 from pay_action_information

1116: AND papf.CURRENT_EMPLOYEE_FLAG='Y' ;
1117:
1118: cursor csr_category_insert(csr_v_payroll_action_id number, csr_v_category varchar2, csr_v_local_unit_id number )
1119: is
1120: select 1 from pay_action_information
1121: where action_context_id=csr_v_payroll_action_id --45446
1122: and action_information2=csr_v_category --'BH'
1123: AND action_information3=csr_v_local_unit_id;
1124:

Line 1127: select 1 from pay_action_information

1123: AND action_information3=csr_v_local_unit_id;
1124:
1125: cursor csr_local_unit_insert(csr_v_payroll_action_id number, csr_v_category varchar2, csr_v_local_unit_id number )
1126: is
1127: select 1 from pay_action_information
1128: where action_context_id=csr_v_payroll_action_id --45446
1129: and action_information2=csr_v_category --'BH'
1130: and action_information3=csr_v_local_unit_id;
1131:

Line 1360: pay_action_information_api.create_action_information

1356: open csr_local_unit_insert(p_payroll_action_id,'LU',g_local_unit_id);
1357: fetch csr_local_unit_insert into l_check_insert;
1358: close csr_local_unit_insert;
1359: if l_check_insert is null then
1360: pay_action_information_api.create_action_information
1361: (p_action_information_id => l_action_info_id
1362: , p_action_context_id => p_payroll_action_id
1363: , p_action_context_type => 'PA'
1364: , p_object_version_number => l_ovn

Line 2105: pay_action_information_api.create_action_information

2101: --close csr_category_insert;
2102: --if l_check_insert is null then
2103: IF csr_category_insert%NOTFOUND THEN
2104: /*Insert the record*/
2105: pay_action_information_api.create_action_information
2106: (p_action_information_id => l_action_info_id
2107: , p_action_context_id => p_payroll_action_id
2108: , p_action_context_type => 'PA'
2109: , p_object_version_number => l_ovn

Line 2136: update pay_action_information set

2132: , p_action_information19 => l_bh_total_employees
2133: );
2134: else
2135: /*update the record*/
2136: update pay_action_information set
2137: --action_information4=action_information4+l_bh_worked_calendar_month,
2138: action_information5=action_information5+l_bh_worked_payment_period,
2139: action_information12=action_information12+l_bh_pbt_value,
2140: action_information13=action_information13+l_bh_pcow_value,

Line 2164: pay_action_information_api.create_action_information

2160: --close csr_category_insert;
2161: --if l_check_insert is null then
2162: IF csr_category_insert%NOTFOUND THEN
2163: /*Insert the record*/
2164: pay_action_information_api.create_action_information
2165: (p_action_information_id => l_action_info_id
2166: , p_action_context_id => p_payroll_action_id
2167: , p_action_context_type => 'PA'
2168: , p_object_version_number => l_ovn

Line 2195: update pay_action_information set

2191: , p_action_information19 => l_bs_total_employees
2192: );
2193: else
2194: /*update the record*/
2195: update pay_action_information set
2196: action_information7=action_information7+l_bs_gross_pay,
2197: action_information8=action_information8+l_bs_working_agreement,
2198: action_information9=action_information9+l_bs_tcdp_value,
2199: action_information10=action_information10+l_bs_tcow_value,

Line 2223: pay_action_information_api.create_action_information

2219: --close csr_category_insert;
2220: --if l_check_insert is null then
2221: IF csr_category_insert%NOTFOUND THEN
2222: /*Insert the record*/
2223: pay_action_information_api.create_action_information
2224: (p_action_information_id => l_action_info_id
2225: , p_action_context_id => p_payroll_action_id
2226: , p_action_context_type => 'PA'
2227: , p_object_version_number => l_ovn

Line 2254: update pay_action_information set

2250: , p_action_information19 => l_ws_total_employees
2251: );
2252: else
2253: /*update the record*/
2254: update pay_action_information set
2255: action_information6=action_information6+l_ws_full_time_employee,
2256: action_information7=action_information7+l_ws_gross_pay,
2257: action_information8=action_information8+l_ws_working_agreement,
2258: action_information9=action_information9+l_ws_tcdp_value,

Line 2291: pay_action_information_api.create_action_information

2287: open csr_local_unit_insert(p_payroll_action_id,'LU',l_local_unit_id);
2288: fetch csr_local_unit_insert into l_check_insert;
2289: close csr_local_unit_insert;
2290: if l_check_insert is null then
2291: pay_action_information_api.create_action_information
2292: (p_action_information_id => l_action_info_id
2293: , p_action_context_id => p_payroll_action_id
2294: , p_action_context_type => 'PA'
2295: , p_object_version_number => l_ovn

Line 3037: pay_action_information_api.create_action_information

3033: -- close csr_category_insert;
3034: --if l_check_insert is null then
3035: IF csr_category_insert%NOTFOUND THEN
3036: /*Insert the record*/
3037: pay_action_information_api.create_action_information
3038: (p_action_information_id => l_action_info_id
3039: , p_action_context_id => p_payroll_action_id
3040: , p_action_context_type => 'PA'
3041: , p_object_version_number => l_ovn

Line 3068: update pay_action_information set

3064: , p_action_information19 => l_bh_total_employees
3065: );
3066: else
3067: /*update the record*/
3068: update pay_action_information set
3069: --action_information4=action_information4+l_bh_worked_calendar_month,
3070: action_information5=action_information5+l_bh_worked_payment_period,
3071: action_information12=action_information12+l_bh_pbt_value,
3072: action_information13=action_information13+l_bh_pcow_value,

Line 3096: pay_action_information_api.create_action_information

3092: --close csr_category_insert;
3093: --if l_check_insert is null then
3094: IF csr_category_insert%NOTFOUND THEN
3095: /*Insert the record*/
3096: pay_action_information_api.create_action_information
3097: (p_action_information_id => l_action_info_id
3098: , p_action_context_id => p_payroll_action_id
3099: , p_action_context_type => 'PA'
3100: , p_object_version_number => l_ovn

Line 3127: update pay_action_information set

3123: , p_action_information19 => l_bs_total_employees
3124: );
3125: else
3126: /*update the record*/
3127: update pay_action_information set
3128: action_information7=action_information7+l_bs_gross_pay,
3129: action_information8=action_information8+l_bs_working_agreement,
3130: action_information9=action_information9+l_bs_tcdp_value,
3131: action_information10=action_information10+l_bs_tcow_value,

Line 3155: pay_action_information_api.create_action_information

3151: --close csr_category_insert;
3152: --if l_check_insert is null then
3153: IF csr_category_insert%NOTFOUND THEN
3154: /*Insert the record*/
3155: pay_action_information_api.create_action_information
3156: (p_action_information_id => l_action_info_id
3157: , p_action_context_id => p_payroll_action_id
3158: , p_action_context_type => 'PA'
3159: , p_object_version_number => l_ovn

Line 3186: update pay_action_information set

3182: , p_action_information19 => l_ws_total_employees
3183: );
3184: else
3185: /*update the record*/
3186: update pay_action_information set
3187: action_information6=action_information6+l_ws_full_time_employee,
3188: action_information7=action_information7+l_ws_gross_pay,
3189: action_information8=action_information8+l_ws_working_agreement,
3190: action_information9=action_information9+l_ws_tcdp_value,

Line 3599: l_action_information_id pay_action_information.action_information_id%TYPE;

3595: l_salary NUMBER:=0;
3596: l_grand_salary NUMBER:=0;
3597: l_legal_employer hr_organization_units.name%type;
3598: l_local_unit hr_organization_units.name%type;
3599: l_action_information_id pay_action_information.action_information_id%TYPE;
3600: l_month varchar2(20);
3601: l_year NUMBER;
3602: l_retroactive_date_from DATE;
3603: l_retroactive_date_to DATE;

Line 3662: pay_action_information pai,

3658: pai1.ACTION_INFORMATION10 Gross_Salary,
3659: pai1.ACTION_INFORMATION11 Terminated,
3660: pai1.ACTION_INFORMATION12 Painter*/
3661: /*FROM
3662: pay_action_information pai,
3663: pay_payroll_actions ppa,
3664: pay_action_information pai1
3665: WHERE
3666: pai.action_context_id = ppa.payroll_action_id

Line 3664: pay_action_information pai1

3660: pai1.ACTION_INFORMATION12 Painter*/
3661: /*FROM
3662: pay_action_information pai,
3663: pay_payroll_actions ppa,
3664: pay_action_information pai1
3665: WHERE
3666: pai.action_context_id = ppa.payroll_action_id
3667: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
3668: AND pai.action_context_id = pai1.action_context_id

Line 3698: pay_action_information pai,

3694: pai1.ACTION_INFORMATION10 Gross_Salary,
3695: pai1.ACTION_INFORMATION11 Terminated,
3696: pai1.ACTION_INFORMATION12 Painter*/
3697: /*FROM
3698: pay_action_information pai,
3699: pay_payroll_actions ppa,
3700: pay_action_information pai1
3701: WHERE
3702: pai.action_context_id = ppa.payroll_action_id

Line 3700: pay_action_information pai1

3696: pai1.ACTION_INFORMATION12 Painter*/
3697: /*FROM
3698: pay_action_information pai,
3699: pay_payroll_actions ppa,
3700: pay_action_information pai1
3701: WHERE
3702: pai.action_context_id = ppa.payroll_action_id
3703: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
3704: AND pai.action_context_id = pai1.action_context_id

Line 3730: --pay_action_information pai,

3726: nvl(pai1.ACTION_INFORMATION11,0) Gross_Salary,
3727: pai1.ACTION_INFORMATION12 Terminated,
3728: pai1.ACTION_INFORMATION13 Painter
3729: FROM
3730: --pay_action_information pai,
3731: pay_payroll_actions ppa,
3732: pay_action_information pai1
3733: WHERE
3734: pai1.action_context_id = ppa.payroll_action_id

Line 3732: pay_action_information pai1

3728: pai1.ACTION_INFORMATION13 Painter
3729: FROM
3730: --pay_action_information pai,
3731: pay_payroll_actions ppa,
3732: pay_action_information pai1
3733: WHERE
3734: pai1.action_context_id = ppa.payroll_action_id
3735: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
3736: /*AND pai.action_context_id = pai1.action_context_id*/

Line 3753: FROM pay_action_information pai

3749:
3750: CURSOR csr_local_unit(csr_v_payroll_action_id number)
3751: IS
3752: SELECT action_information3 local_unit_id
3753: FROM pay_action_information pai
3754: WHERE pai.action_context_id= csr_v_payroll_action_id
3755: AND pai.action_context_type='PA'
3756: AND pai.action_information2 = 'LU'
3757: AND pai.action_information1 = 'PYSEWSSA'

Line 3811: pay_action_information pai,

3807: decode(pai5.action_information17,0,NULL,pai5.action_information17) wh_ppo_value,
3808: decode(pai5.action_information18,0,NULL,pai5.action_information18) wh_sick_pay,
3809: decode(pai5.action_information19,0,NULL,pai5.action_information19) wh_total_employees
3810: FROM
3811: pay_action_information pai,
3812: pay_payroll_actions ppa,
3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,

Line 3813: pay_action_information pai1,

3809: decode(pai5.action_information19,0,NULL,pai5.action_information19) wh_total_employees
3810: FROM
3811: pay_action_information pai,
3812: pay_payroll_actions ppa,
3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,
3816: pay_action_information pai4,
3817: pay_action_information pai5

Line 3814: pay_action_information pai2,

3810: FROM
3811: pay_action_information pai,
3812: pay_payroll_actions ppa,
3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,
3816: pay_action_information pai4,
3817: pay_action_information pai5
3818: WHERE

Line 3815: pay_action_information pai3,

3811: pay_action_information pai,
3812: pay_payroll_actions ppa,
3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,
3816: pay_action_information pai4,
3817: pay_action_information pai5
3818: WHERE
3819: ppa.payroll_action_id=csr_v_payroll_action_id --45660 --p_payroll_action_id

Line 3816: pay_action_information pai4,

3812: pay_payroll_actions ppa,
3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,
3816: pay_action_information pai4,
3817: pay_action_information pai5
3818: WHERE
3819: ppa.payroll_action_id=csr_v_payroll_action_id --45660 --p_payroll_action_id
3820: AND ppa.payroll_action_id=pai.action_context_id

Line 3817: pay_action_information pai5

3813: pay_action_information pai1,
3814: pay_action_information pai2,
3815: pay_action_information pai3,
3816: pay_action_information pai4,
3817: pay_action_information pai5
3818: WHERE
3819: ppa.payroll_action_id=csr_v_payroll_action_id --45660 --p_payroll_action_id
3820: AND ppa.payroll_action_id=pai.action_context_id
3821: AND pai.action_context_id=pai1.action_context_id

Line 3866: pay_action_information pai,

3862: --pai.action_information8 year,
3863: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3864: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3865: FROM
3866: pay_action_information pai,
3867: pay_action_information pai1,
3868: pay_payroll_actions ppa
3869: WHERE
3870: ppa.payroll_action_id=csr_v_payroll_action_id

Line 3867: pay_action_information pai1,

3863: fnd_date.canonical_to_date(pai.action_information9) retroactive_date_from,
3864: fnd_date.canonical_to_date(pai.action_information10) retroactive_date_to
3865: FROM
3866: pay_action_information pai,
3867: pay_action_information pai1,
3868: pay_payroll_actions ppa
3869: WHERE
3870: ppa.payroll_action_id=csr_v_payroll_action_id
3871: AND ppa.payroll_action_id=pai.action_context_id

Line 3896: pay_action_information pai1,

3892: decode(sum(pai2.action_information17),0,NULL,sum(pai2.action_information17)) bh_ppo_value,
3893: decode(sum(pai2.action_information18),0,NULL,sum(pai2.action_information18)) bh_sick_pay,
3894: decode(sum(pai2.action_information19),0,NULL,sum(pai2.action_information19)) bh_total_employees
3895: FROM
3896: pay_action_information pai1,
3897: pay_action_information pai2,
3898: pay_payroll_actions ppa
3899: WHERE
3900: ppa.payroll_action_id=csr_v_payroll_action_id

Line 3897: pay_action_information pai2,

3893: decode(sum(pai2.action_information18),0,NULL,sum(pai2.action_information18)) bh_sick_pay,
3894: decode(sum(pai2.action_information19),0,NULL,sum(pai2.action_information19)) bh_total_employees
3895: FROM
3896: pay_action_information pai1,
3897: pay_action_information pai2,
3898: pay_payroll_actions ppa
3899: WHERE
3900: ppa.payroll_action_id=csr_v_payroll_action_id
3901: AND ppa.payroll_action_id=pai1.action_context_id

Line 3918: pay_action_information pai1,

3914:
3915: CURSOR csr_blue_hour_calendar(csr_v_payroll_action_id number, csr_v_local_unit_id number, csr_v_action_information_id number )
3916: IS SELECT pai2.action_information4 bh_worked_calendar_month
3917: FROM
3918: pay_action_information pai1,
3919: pay_action_information pai2,
3920: pay_payroll_actions ppa
3921: WHERE
3922: ppa.payroll_action_id=csr_v_payroll_action_id

Line 3919: pay_action_information pai2,

3915: CURSOR csr_blue_hour_calendar(csr_v_payroll_action_id number, csr_v_local_unit_id number, csr_v_action_information_id number )
3916: IS SELECT pai2.action_information4 bh_worked_calendar_month
3917: FROM
3918: pay_action_information pai1,
3919: pay_action_information pai2,
3920: pay_payroll_actions ppa
3921: WHERE
3922: ppa.payroll_action_id=csr_v_payroll_action_id
3923: AND ppa.payroll_action_id=pai1.action_context_id

Line 3952: pay_action_information pai1,

3948: decode(sum(pai3.action_information17),0,NULL,sum(pai3.action_information17)) bs_ppo_value,
3949: decode(sum(pai3.action_information18),0,NULL,sum(pai3.action_information18)) bs_sick_pay,
3950: decode(sum(pai3.action_information19),0,NULL,sum(pai3.action_information19)) bs_total_employees
3951: FROM
3952: pay_action_information pai1,
3953: pay_action_information pai3,
3954: pay_payroll_actions ppa
3955: WHERE
3956: ppa.payroll_action_id=csr_v_payroll_action_id

Line 3953: pay_action_information pai3,

3949: decode(sum(pai3.action_information18),0,NULL,sum(pai3.action_information18)) bs_sick_pay,
3950: decode(sum(pai3.action_information19),0,NULL,sum(pai3.action_information19)) bs_total_employees
3951: FROM
3952: pay_action_information pai1,
3953: pay_action_information pai3,
3954: pay_payroll_actions ppa
3955: WHERE
3956: ppa.payroll_action_id=csr_v_payroll_action_id
3957: AND ppa.payroll_action_id=pai1.action_context_id

Line 3986: pay_action_information pai1,

3982: decode(sum(pai4.action_information17),0,NULL,sum(pai4.action_information17)) ws_ppo_value,
3983: decode(sum(pai4.action_information18),0,NULL,sum(pai4.action_information18)) ws_sick_pay,
3984: decode(sum(pai4.action_information19),0,NULL,sum(pai4.action_information19)) ws_total_employees
3985: FROM
3986: pay_action_information pai1,
3987: pay_action_information pai4,
3988: pay_payroll_actions ppa
3989: WHERE
3990: ppa.payroll_action_id=csr_v_payroll_action_id

Line 3987: pay_action_information pai4,

3983: decode(sum(pai4.action_information18),0,NULL,sum(pai4.action_information18)) ws_sick_pay,
3984: decode(sum(pai4.action_information19),0,NULL,sum(pai4.action_information19)) ws_total_employees
3985: FROM
3986: pay_action_information pai1,
3987: pay_action_information pai4,
3988: pay_payroll_actions ppa
3989: WHERE
3990: ppa.payroll_action_id=csr_v_payroll_action_id
3991: AND ppa.payroll_action_id=pai1.action_context_id

Line 4017: pay_action_information pai1,

4013: decode(sum(pai5.action_information17),0,NULL,sum(pai5.action_information17)) wh_ppo_value,
4014: decode(sum(pai5.action_information18),0,NULL,sum(pai5.action_information18)) wh_sick_pay,
4015: decode(sum(pai5.action_information19),0,NULL,sum(pai5.action_information19)) wh_total_employees
4016: FROM
4017: pay_action_information pai1,
4018: pay_action_information pai5,
4019: pay_payroll_actions ppa
4020: WHERE
4021: ppa.payroll_action_id=csr_v_payroll_action_id

Line 4018: pay_action_information pai5,

4014: decode(sum(pai5.action_information18),0,NULL,sum(pai5.action_information18)) wh_sick_pay,
4015: decode(sum(pai5.action_information19),0,NULL,sum(pai5.action_information19)) wh_total_employees
4016: FROM
4017: pay_action_information pai1,
4018: pay_action_information pai5,
4019: pay_payroll_actions ppa
4020: WHERE
4021: ppa.payroll_action_id=csr_v_payroll_action_id
4022: AND ppa.payroll_action_id=pai1.action_context_id

Line 4041: FROM pay_action_information pai

4037:
4038: CURSOR csr_unique_local_unit(csr_v_payroll_action_id number, csr_v_local_unit_id number )
4039: IS
4040: SELECT MIN(action_information_id)
4041: FROM pay_action_information pai
4042: WHERE pai.action_context_id= csr_v_payroll_action_id
4043: AND pai.action_context_type='PA'
4044: AND pai.action_information2 = 'LU'
4045: AND pai.action_information1 = 'PYSEWSSA'