APPS.PAY_NO_TAX_LEVY dependencies on PAY_ACTION_INFORMATION

Line 127: from pay_action_information

123:
124: --cursor to check current archive exists
125: cursor csr_count is
126: select count(*)
127: from pay_action_information
128: where action_information_category = 'EMEA REPORT DETAILS'
129: and action_information1 = 'PYNOTAXLEVYA'
130: and action_context_id = pactid;
131:

Line 189: pay_action_information_api.create_action_information (

185: close csr_bimonth_year;
186:
187: -- archive the report details
188:
189: pay_action_information_api.create_action_information (
190: p_action_information_id => l_action_info_id -- out parameter
191: ,p_object_version_number => l_ovn -- out parameter
192: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
193: ,p_action_context_type => 'PA' -- context type

Line 409: pay_action_information_api.create_action_information (

405: -- Create the archive assignment action
406: hr_nonrun_asact.insact(l_actid ,csr_rec.asg_id ,p_payroll_action_id ,p_chunk ,NULL);
407:
408: -- Creating Initial Archive Entries
409: pay_action_information_api.create_action_information (
410:
411: p_action_information_id => l_action_info_id -- out parameter
412: ,p_object_version_number => l_ovn -- out parameter
413: ,p_action_context_id => l_actid -- context id = assignment action id (of Archive)

Line 449: from pay_action_information

445:
446: cursor csr_get_act_info (p_assignment_action_id NUMBER , p_effective_date DATE) is
447: select to_number(ACTION_INFORMATION_ID) , to_number(ACTION_INFORMATION4)
448: ,to_number(ACTION_INFORMATION3)
449: from pay_action_information
450: where ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'
451: and ACTION_INFORMATION1 = 'PYNOTAXLEVYA'
452: and ACTION_CONTEXT_TYPE = 'AAP'
453: and ACTION_CONTEXT_ID = p_assignment_action_id

Line 681: pay_action_information_api.update_action_information (

677: substr(l_third_party_dest_acc,5,2)||'.'||
678: substr(l_third_party_dest_acc,7,5) ;
679:
680: -- Updating the Initial Archive Entries
681: pay_action_information_api.update_action_information (
682: p_action_information_id => l_action_info_id -- in parameter
683: ,p_object_version_number => l_ovn -- in out parameter
684: ,p_action_information5 => l_third_party_id --Third Party ID (Tax Collector ID)
685: ,p_action_information6 => l_third_party_name --Third Party Name (Tax Collector's Name)

Line 727: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';

723: l_employer hr_all_organization_units.name%type;
724: l_orgnumber hr_organization_information.org_information1%type;
725: l_term varchar2(30);
726: l_year varchar2(8);
727: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';
728: l_payroll_action_id varchar2(150);
729: l_archiver varchar2(150);
730: xml_ctr number;
731: l_IANA_charset VARCHAR2 (50);

Line 737: from pay_action_information pai

733: cursor csr_legalemployer is
734: select pai.action_information3 employer,pai.action_information4 orgnumber,
735: pai.action_information5 term,pai.action_information6 year,
736: pai.effective_date || ' (' ||pai.action_context_id||')' archiver
737: from pay_action_information pai
738: where to_char(pai.action_context_id)=l_payroll_action_id;
739:
740: --Bug 5116700 fix - Taking the sum of TaxDeductionBasis
741: cursor csr_emp is

Line 772: from pay_action_information pai

768: ,pai.action_information22 incomeyear
769: ,pai.action_information23 percentage
770: ,pai.action_information24 amount
771: ,pai.action_information25 deductedthisperiod
772: from pay_action_information pai
773: where pai.action_information3=l_payroll_action_id)
774: group by
775: thirdparty_id,thirdparty_name,thirdparty_address,
776: bankaccountno,ni,last_name,first_name,order_name,