DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_ACTION_INFORMATION

Line 664: pay_action_information ee_ats

660: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)
661: and not exists
662: (select 1
663: from
664: pay_action_information ee_ats
665: WHERE ee_ats.action_context_type='AAP'
666: AND ee_ats.action_information_category = 'NL ASI EMPLOYEE DETAILS'
667: AND ee_ats.action_information1 =p_employer_id
668: AND ee_ats.action_information4 =pap.person_id

Line 776: NL ATS EMPLOYEE DETAILS Context of the Pay Action Information Table

772: END IF;
773:
774:
775: /*Archive the Employee Fiscal Record Details in the
776: NL ATS EMPLOYEE DETAILS Context of the Pay Action Information Table
777: */
778:
779: /* Obtain the following
780:

Line 794: pay_action_information_api.create_action_information

790: PAY_NL_ANNUAL_SI_FILE.get_si_special_indicator(l_assignment_id,l_si_special_indicator);
791: l_number_of_days := NVL(PAY_NL_ANNUAL_SI_FILE.get_number_of_days(l_max_assgt_act_id),0);
792: --hr_utility.trace('NUMBER OF DAYS'||to_char(l_number_of_days));
793:
794: pay_action_information_api.create_action_information
795: (
796: p_action_information_id => l_action_info_id
797: ,p_action_context_id => l_asg_act_id
798: ,p_action_context_type => 'AAP'