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

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

Line 446: from pay_action_information

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

Line 678: pay_action_information_api.update_action_information (

674: substr(l_third_party_dest_acc,5,2)||'.'||
675: substr(l_third_party_dest_acc,7,5) ;
676:
677: -- Updating the Initial Archive Entries
678: pay_action_information_api.update_action_information (
679: p_action_information_id => l_action_info_id -- in parameter
680: ,p_object_version_number => l_ovn -- in out parameter
681: ,p_action_information5 => l_third_party_id --Third Party ID (Tax Collector ID)
682: ,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_from_date DATE;
726: l_to_date DATE;
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 from_date,pai.action_information6 to_date1,
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 5107535 fix-Taking the sum of TaxDeductionBasis*/
741: cursor csr_emp is

Line 772: from pay_action_information pai

768: ,pai.action_information22 Unionmemberno
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,