APPS.PAY_NO_UNION_DUES dependencies on PAY_ACTION_INFORMATION

Line 132: from pay_action_information

128:
129: --cursor to check current archive exists
130: cursor csr_count is
131: select count(*)
132: from pay_action_information
133: where action_information_category = 'EMEA REPORT DETAILS'
134: and action_information1 = 'PYNOTAXLEVYA'
135: and action_context_id = pactid;
136:

Line 194: pay_action_information_api.create_action_information (

190: end;
191:
192: -- Archive the REPORT DETAILS
193:
194: pay_action_information_api.create_action_information (
195: p_action_information_id => l_action_info_id -- out parameter
196: ,p_object_version_number => l_ovn -- out parameter
197: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
198: ,p_action_context_type => 'PA' -- context type

Line 406: pay_action_information_api.create_action_information (

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

Line 444: from pay_action_information

440: -- Cursor to get the action_information_id and original/main assignment_action_id
441:
442: cursor csr_get_act_info (p_assignment_action_id NUMBER , p_effective_date DATE) is
443: select to_number(ACTION_INFORMATION_ID) , to_number(ACTION_INFORMATION4)
444: from pay_action_information
445: where ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'
446: and ACTION_INFORMATION1 = 'PYNOUNDUEA'
447: and ACTION_CONTEXT_TYPE = 'AAP'
448: and ACTION_CONTEXT_ID = p_assignment_action_id

Line 675: pay_action_information_api.update_action_information (

671: substr(l_third_party_dest_acc,5,2)||'.'||
672: substr(l_third_party_dest_acc,7,5) ;
673:
674: -- Updating the Initial Archive Entries
675: pay_action_information_api.update_action_information (
676: p_action_information_id => l_action_info_id -- in parameter
677: ,p_object_version_number => l_ovn -- in out parameter
678: ,p_action_information5 => l_third_party_id --Third Party ID (Tax Collector ID)
679: ,p_action_information6 => l_third_party_name --Third Party Name (Tax Collector's Name)

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

720: l_employer hr_all_organization_units.name%type;
721: l_orgnumber hr_organization_information.org_information1%type;
722: l_from_date DATE;
723: l_to_date DATE;
724: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';
725: l_payroll_action_id varchar2(150);
726: l_archiver varchar2(150);
727: xml_ctr number;
728: l_IANA_charset VARCHAR2 (50);

Line 734: from pay_action_information pai

730: cursor csr_legalemployer is
731: select pai.action_information3 employer,pai.action_information4 orgnumber,
732: pai.action_information5 from_date,pai.action_information6 to_date1,
733: pai.effective_date || ' (' ||pai.action_context_id||')' archiver
734: from pay_action_information pai
735: where to_char(pai.action_context_id)=l_payroll_action_id;
736:
737: /* Bug 5107535 fix-Taking the sum of TaxDeductionBasis*/
738: cursor csr_emp is

Line 769: from pay_action_information pai

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