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 410: pay_action_information_api.create_action_information (

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

Line 450: from pay_action_information

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

Line 683: pay_action_information_api.update_action_information (

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

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

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

Line 739: from pay_action_information pai

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

Line 774: from pay_action_information pai

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