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_ZA_EOY_VAL dependencies on PAY_ACTION_INFORMATION

Line 3963: from pay_action_information pai

3959: ,cert_num varchar2) IS
3960: select nvl(pai.action_information3,0) SITE,
3961: nvl(pai.action_information11,0) PAYE,
3962: nvl(pai.action_information10,0) TAX
3963: from pay_action_information pai
3964: where pai.action_context_id = asgn_ac_id
3965: and pai.action_context_type = 'AAP'
3966: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'
3967: and pai.action_information30 = cert_num;

Line 3975: from pay_action_information pai

3971: -- lumpsum certificate cannot exceed 13.
3972: CURSOR csr_num_inc_codes ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE
3973: ,cert_num varchar2) IS
3974: select count(1)
3975: from pay_action_information pai
3976: where pai.action_context_id = asgn_ac_id
3977: and pai.action_context_type = 'AAP'
3978: and ( pai.action_information_category = 'ZATYE_EMPLOYEE_INCOME'
3979: OR

Line 3990: from pay_action_information pai

3986:
3987: CURSOR csr_num_3907 ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE
3988: ,cert_num varchar2) IS
3989: select 1
3990: from pay_action_information pai
3991: where pai.action_context_id = asgn_ac_id
3992: and pai.action_context_type = 'AAP'
3993: and ( pai.action_information_category = 'ZATYE_EMPLOYEE_INCOME'
3994: OR

Line 4007: from pay_action_information pai

4003: -- Retrieve the number of deduction codes. These exist in main certificate only
4004: CURSOR csr_num_ded_codes ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE
4005: ,cert_num varchar2) IS
4006: select count(1)
4007: from pay_action_information pai
4008: where pai.action_context_id = asgn_ac_id
4009: and pai.action_context_type = 'AAP'
4010: and pai.action_information_category = 'ZATYE_EMPLOYEE_DEDUCTIONS'
4011: and pai.action_information30 = cert_num

Line 4020: from pay_action_information pai

4016: -- Retrieve main certificate number
4017: CURSOR csr_cert_num( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
4018: select pai.action_information30 temp_cert_num
4019: ,pai2.action_information2 cert_type --IRP5/IT3A/ITREG
4020: from pay_action_information pai
4021: ,pay_action_information pai2
4022: where pai.action_context_id = asgn_ac_id
4023: and pai.action_context_type = 'AAP'
4024: and pai.action_information_category = 'ZATYE_EMPLOYEE_CONTACT_INFO'

Line 4021: ,pay_action_information pai2

4017: CURSOR csr_cert_num( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
4018: select pai.action_information30 temp_cert_num
4019: ,pai2.action_information2 cert_type --IRP5/IT3A/ITREG
4020: from pay_action_information pai
4021: ,pay_action_information pai2
4022: where pai.action_context_id = asgn_ac_id
4023: and pai.action_context_type = 'AAP'
4024: and pai.action_information_category = 'ZATYE_EMPLOYEE_CONTACT_INFO'
4025: and pai2.action_information_category ='ZATYE_EMPLOYEE_INFO'

Line 4037: FROM pay_action_information pai

4033: CURSOR csr_neg_income(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE
4034: ,p_cert_num varchar2 ) IS
4035: select pai.action_information2 code,
4036: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(pai.action_information5,0)))) value --code_group_value
4037: FROM pay_action_information pai
4038: where pai.action_context_id = p_asgn_action_id
4039: and pai.action_context_type = 'AAP'
4040: and pai.action_information_category = 'ZATYE_EMPLOYEE_INCOME'
4041: and pai.action_information30 = p_cert_num

Line 4058: FROM pay_action_information pai

4054: pai.action_information9 direct2,
4055: nvl(pai.action_information10,0) value2,
4056: pai.action_information11 direct3,
4057: nvl(pai.action_information12,0) value3
4058: FROM pay_action_information pai
4059: where pai.action_context_id = p_asgn_action_id
4060: and pai.action_context_type = 'AAP'
4061: and pai.action_information_category = 'ZATYE_EMPLOYEE_LUMPSUMS'
4062: and pai.action_information30 = p_cert_num

Line 4075: FROM pay_action_information pai,

4071: ,p_cert_num varchar2 ) IS
4072: select pai.action_information2 code,
4073: pai.action_information5 value,
4074: pai2.action_information18 direct1
4075: FROM pay_action_information pai,
4076: pay_action_information pai2
4077: where pai.action_context_id = p_asgn_action_id
4078: and pai.action_context_type = 'AAP'
4079: and pai.action_information_category = 'ZATYE_EMPLOYEE_LUMPSUMS'

Line 4076: pay_action_information pai2

4072: select pai.action_information2 code,
4073: pai.action_information5 value,
4074: pai2.action_information18 direct1
4075: FROM pay_action_information pai,
4076: pay_action_information pai2
4077: where pai.action_context_id = p_asgn_action_id
4078: and pai.action_context_type = 'AAP'
4079: and pai.action_information_category = 'ZATYE_EMPLOYEE_LUMPSUMS'
4080: and pai2.action_information_category ='ZATYE_EMPLOYEE_INFO'

Line 4096: FROM pay_action_information pai

4092: CURSOR csr_neg_deduct(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE
4093: ,p_cert_num varchar2 ) IS
4094: select pai.action_information2 code,
4095: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(pai.action_information5,0)))) value --code_group_value
4096: FROM pay_action_information pai
4097: where pai.action_context_id = p_asgn_action_id
4098: and pai.action_context_type = 'AAP'
4099: and pai.action_information_category = 'ZATYE_EMPLOYEE_DEDUCTIONS'
4100: and pai.action_information30 = p_cert_num

Line 4108: FROM pay_action_information pai

4104:
4105: -- Retrieve the PAYE Reference number of the employer
4106: CURSOR csr_paye_ref_num IS
4107: SELECT pai.action_information2 PAYE_REF_NUM
4108: FROM pay_action_information pai
4109: WHERE pai.action_context_id = p_payroll_action_id
4110: AND pai.action_context_type = 'PA'
4111: AND pai.action_information_category = 'ZATYE_EMPLOYER_INFO';
4112:

Line 4116: from pay_action_information pai

4112:
4113: -- Retrieve the value for Tax and Tax on Retirement Fund
4114: CURSOR tax_codes ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
4115: select '1'
4116: from pay_action_information pai
4117: where pai.action_context_id = asgn_ac_id
4118: and pai.action_context_type = 'AAP'
4119: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'
4120: and ( trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(pai.action_information10,0)))) <> 0

Line 4131: FROM pay_action_information pai,

4127: --Check whether the employee on specific income has PKG balances
4128: CURSOR fetch_pkg_balances( p_asgn_action_id pay_assignment_actions.assignment_action_id%type
4129: , p_cert_num varchar2 ) IS
4130: select '1' flag
4131: FROM pay_action_information pai,
4132: per_assignment_extra_info paei
4133: where pai.action_context_id = p_asgn_action_id
4134: and paei.assignment_id = pai.assignment_id
4135: AND paei.AEI_INFORMATION8 <> '1' -- 'Pension Basis:1 is Fixed Percentage of Specific Income

Line 4188: FROM pay_action_information pai,

4184: CURSOR chk_tax_ret_fund_ls ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
4185: select pai.action_information5,
4186: pai.action_information30 temp_cert_num,
4187: pai2.action_information18 direct1 --Directive1
4188: FROM pay_action_information pai,
4189: pay_action_information pai2
4190: where pai.action_context_id = p_asgn_action_id
4191: and pai.action_context_type = 'AAP'
4192: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'

Line 4189: pay_action_information pai2

4185: select pai.action_information5,
4186: pai.action_information30 temp_cert_num,
4187: pai2.action_information18 direct1 --Directive1
4188: FROM pay_action_information pai,
4189: pay_action_information pai2
4190: where pai.action_context_id = p_asgn_action_id
4191: and pai.action_context_type = 'AAP'
4192: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'
4193: and pai2.action_information_category = 'ZATYE_EMPLOYEE_INFO'

Line 4205: FROM pay_action_information pai

4201: /*CURSOR chk_ret_fund_ls ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type
4202: ,p_cert_num varchar2) IS
4203: select pai.action_information2 code, --either 3901, 3920, 3921, 3915 (added 3901 for bug 11899934)
4204: pai.action_information30 temp_cert_num
4205: FROM pay_action_information pai
4206: where pai.action_context_id = p_asgn_action_id
4207: and pai.action_context_type = 'AAP'
4208: and pai.action_information_category = 'ZATYE_EMPLOYEE_LUMPSUMS'
4209: and pai.action_information30 = p_cert_num

Line 4222: from pay_action_information pai

4218: ,p_cert_num varchar2) IS
4219: select to_number(pai.action_information2) code --income code
4220: ,trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(pai.action_information5,0)))) value--income value
4221: ,pai.action_information30 temp_cert_num
4222: from pay_action_information pai
4223: where pai.action_context_id = p_asgn_action_id
4224: and pai.action_context_type='AAP'
4225: and pai.action_information_category = 'ZATYE_EMPLOYEE_INCOME'
4226: and pai.action_information3 is null

Line 4237: from pay_action_information pai

4233: ,p_cert_num varchar2) IS
4234: select to_number(pai.action_information2) code --deduction code
4235: ,trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(pai.action_information5,0)))) value--deduction value
4236: ,pai.action_information30 temp_cert_num
4237: from pay_action_information pai
4238: where pai.action_context_id = p_asgn_action_id
4239: and pai.action_context_type='AAP'
4240: and pai.action_information_category = 'ZATYE_EMPLOYEE_DEDUCTIONS'
4241: and pai.action_information3 is null

Line 4257: FROM pay_action_information pai,

4253: nvl(pai.action_information5,0) tax_ret,
4254: nvl(pai.action_information6,0) uif,
4255: nvl(pai.action_information7,0) sdl,
4256: nvl(pai.action_information8,0) total
4257: FROM pay_action_information pai,
4258: pay_action_information pai2
4259: where pai.action_context_id = p_asgn_action_id
4260: and pai.action_context_type = 'AAP'
4261: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'

Line 4258: pay_action_information pai2

4254: nvl(pai.action_information6,0) uif,
4255: nvl(pai.action_information7,0) sdl,
4256: nvl(pai.action_information8,0) total
4257: FROM pay_action_information pai,
4258: pay_action_information pai2
4259: where pai.action_context_id = p_asgn_action_id
4260: and pai.action_context_type = 'AAP'
4261: and pai.action_information_category = 'ZATYE_EMPLOYEE_TAX_AND_REASONS'
4262: -- Fix for bug#14128085

Line 4286: FROM pay_action_information

4282: IS
4283: SELECT nvl(ACTION_INFORMATION2, '0') Non_Taxable_Income,
4284: nvl(ACTION_INFORMATION3, '0') Gross_Retire_Fund_Income,
4285: nvl(ACTION_INFORMATION4, '0') Gross_Non_Retire_Fund_In
4286: FROM pay_action_information
4287: WHERE action_context_id = p_asgn_action_id
4288: AND action_information_category = 'ZATYE_EMPLOYEE_GROSS_REMUNERATIONS' ;
4289:
4290: -- Added for bug#10287216

Line 4298: FROM pay_action_information pai

4294:
4295: CURSOR csr_3922_rep_err( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4296: IS
4297: SELECT pai2.action_information14
4298: FROM pay_action_information pai
4299: , pay_action_information pai2
4300: WHERE pai.action_context_id = p_asgn_action_id
4301: AND pai.action_context_type = 'AAP'
4302: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'

Line 4299: , pay_action_information pai2

4295: CURSOR csr_3922_rep_err( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4296: IS
4297: SELECT pai2.action_information14
4298: FROM pay_action_information pai
4299: , pay_action_information pai2
4300: WHERE pai.action_context_id = p_asgn_action_id
4301: AND pai.action_context_type = 'AAP'
4302: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'
4303: AND pai.action_information2 in ('IRP5','IT3(a)')

Line 4347: FROM pay_action_information pai

4343: -- Code 4116 is Applicable only if nature of person in A/B/C/N
4344: CURSOR csr_4116_nature_of_person( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4345: IS
4346: SELECT 'X'
4347: FROM pay_action_information pai
4348: , pay_action_information pai2
4349: WHERE pai.action_context_id = p_asgn_action_id
4350: AND pai.action_context_type = 'AAP'
4351: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'

Line 4348: , pay_action_information pai2

4344: CURSOR csr_4116_nature_of_person( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4345: IS
4346: SELECT 'X'
4347: FROM pay_action_information pai
4348: , pay_action_information pai2
4349: WHERE pai.action_context_id = p_asgn_action_id
4350: AND pai.action_context_type = 'AAP'
4351: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'
4352: AND pai.action_information2 in ('IRP5','IT3(a)')

Line 4367: FROM pay_action_information pai

4363: IS
4364: SELECT decode (sign (add_months (to_date (pai.action_information11, 'YYYYMMDD'), 780) - to_date (pai.action_information4 || '-03-01', 'yyyy-mm-dd')-1), 1
4365: , 'B', 'A') age
4366: , pai3.action_information13
4367: FROM pay_action_information pai
4368: , pay_action_information pai2
4369: , pay_action_information pai3
4370: WHERE pai.action_context_id = p_asgn_action_id
4371: AND pai.action_context_type = 'AAP'

Line 4368: , pay_action_information pai2

4364: SELECT decode (sign (add_months (to_date (pai.action_information11, 'YYYYMMDD'), 780) - to_date (pai.action_information4 || '-03-01', 'yyyy-mm-dd')-1), 1
4365: , 'B', 'A') age
4366: , pai3.action_information13
4367: FROM pay_action_information pai
4368: , pay_action_information pai2
4369: , pay_action_information pai3
4370: WHERE pai.action_context_id = p_asgn_action_id
4371: AND pai.action_context_type = 'AAP'
4372: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'

Line 4369: , pay_action_information pai3

4365: , 'B', 'A') age
4366: , pai3.action_information13
4367: FROM pay_action_information pai
4368: , pay_action_information pai2
4369: , pay_action_information pai3
4370: WHERE pai.action_context_id = p_asgn_action_id
4371: AND pai.action_context_type = 'AAP'
4372: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'
4373: AND pai.action_information2 in ('IRP5','IT3(a)')

Line 4389: FROM pay_action_information pai

4385: -- Code 4115 is only mandatory if there is a value for 3901,3915, 3920, 3921 or 3922 AND 4150 does not have a value
4386: CURSOR csr_4115_is_mandatory( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4387: IS
4388: SELECT 'X'
4389: FROM pay_action_information pai
4390: , pay_action_information pai2
4391: , pay_action_information pai3
4392: WHERE pai.action_context_id = p_asgn_action_id
4393: AND pai.action_context_type = 'AAP'

Line 4390: , pay_action_information pai2

4386: CURSOR csr_4115_is_mandatory( p_asgn_action_id pay_assignment_actions.assignment_action_id%type)
4387: IS
4388: SELECT 'X'
4389: FROM pay_action_information pai
4390: , pay_action_information pai2
4391: , pay_action_information pai3
4392: WHERE pai.action_context_id = p_asgn_action_id
4393: AND pai.action_context_type = 'AAP'
4394: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'

Line 4391: , pay_action_information pai3

4387: IS
4388: SELECT 'X'
4389: FROM pay_action_information pai
4390: , pay_action_information pai2
4391: , pay_action_information pai3
4392: WHERE pai.action_context_id = p_asgn_action_id
4393: AND pai.action_context_type = 'AAP'
4394: AND pai.action_information_category = 'ZATYE_EMPLOYEE_INFO'
4395: AND pai.action_information2 in ('IRP5','IT3(a)')