DBA Data[Home] [Help]

APPS.PAY_IE_P45PART3_P46_PKG dependencies on PAY_ACTION_INFORMATION

Line 313: pay_action_information_api.create_action_information

309: l_fax_no := l_employer_details.fax;
310:
311: IF l_regst_no IS NOT NULL AND l_employer_name IS NOT NULL THEN
312: l_errflag := 'N';
313: pay_action_information_api.create_action_information
314: ( p_action_information_id => l_action_info_id
315: ,p_action_context_id => pactid
316: ,p_action_context_type => 'PA'
317: ,p_object_version_number => l_ovn

Line 413: PAY_ACTION_INFORMATION pai

409: select 'Y'
410: FROM
411: pay_payroll_actions ppa,
412: pay_assignment_actions paa,
413: PAY_ACTION_INFORMATION pai
414: WHERE
415: paa.payroll_action_id = ppa.payroll_action_id
416: AND ppa.action_type = 'X'
417: AND ppa.business_group_id = p_bg_id

Line 762: pay_action_information_api.create_action_information

758: l_contact_name := l_employer_details.contact_name;
759: l_telphone_no:= l_employer_details.telphone_no;
760: l_fax_no:= l_employer_details.fax;
761:
762: pay_action_information_api.create_action_information
763: ( p_action_information_id => l_action_info_id
764: ,p_action_context_id => p_payroll_action_id
765: ,p_action_context_type => 'PA'
766: ,p_object_version_number => l_ovn

Line 1072: pay_action_information_api.create_action_information (

1068: )
1069: )
1070: THEN
1071: l_errflag := 'N';
1072: pay_action_information_api.create_action_information (
1073: p_action_information_id => l_action_info_id
1074: , p_action_context_id => p_assactid
1075: , p_action_context_type => 'AAP'
1076: , p_object_version_number => l_ovn

Line 1219: FROM pay_action_information

1215: trim(to_char(fnd_number.canonical_to_number(nvl(action_information26,0)) ,'99999990.99')) totalusctodate,
1216: trim(to_char(fnd_number.canonical_to_number(nvl(action_information27,0)) ,'99999990.99')) totalpaythisemp,
1217: trim(to_char(fnd_number.canonical_to_number(nvl(action_information28,0)) ,'99999990.99')) totaluscthisemp,
1218: action_information29 uscrefunded
1219: FROM pay_action_information
1220: WHERE
1221: action_information_category = c_action_type
1222: AND Action_context_id = c_asg_act_id;
1223:

Line 1361: FROM pay_action_information

1357: action_information11 addr3,
1358: action_information12 contact_name,
1359: action_information13 phone,
1360: action_information14 fax
1361: FROM pay_action_information
1362: WHERE action_context_id = c_pact_id
1363: AND action_context_type = 'PA'
1364: AND action_information_category ='IE P45P3 P46 EMPLOYER';
1365: