APPS.HR_NMF_SYNC dependencies on PAY_PAYROLL_ACTIONS

Line 733: from pay_payroll_actions ppa

729: BEGIN
730: select pay_core_utils.get_parameter('LEGISLATION_CODE',
731: ppa.legislative_parameters)
732: into l_leg_code
733: from pay_payroll_actions ppa
734: where ppa.payroll_action_id = pactid;
735: /*
736: ** Define the SQL statement to get the people we want to process. Provide
737: ** initial filtering based on business group if appropriate.

Line 785: ,pay_payroll_actions ppa

781: ,cp_leg_code varchar2) is -- #4571033
782: select distinct ppf.person_id
783: from per_all_people_f ppf
784: ,per_business_groups_perf bg
785: ,pay_payroll_actions ppa
786: where ppf.person_id between cp_stperson and cp_endperson
787: and ppa.payroll_action_id = cp_pactid
788: and ppf.business_group_id = bg.business_group_id
789: and bg.legislation_code = cp_leg_code;

Line 796: ,pay_payroll_actions ppa

792: ,cp_stperson number
793: ,cp_endperson number) is
794: select distinct ppf.person_id
795: from per_all_people_f ppf
796: ,pay_payroll_actions ppa
797: where ppf.person_id between cp_stperson and cp_endperson
798: and ppa.payroll_action_id = cp_pactid;
799: --
800: BEGIN

Line 804: from pay_payroll_actions ppa

800: BEGIN
801: select pay_core_utils.get_parameter('LEGISLATION_CODE',
802: ppa.legislative_parameters)
803: into l_legislation_code
804: from pay_payroll_actions ppa
805: where ppa.payroll_action_id = pactid;
806: if l_legislation_code is null then
807: --
808: for people_rec in csr_actions_no_leg(pactid, stperson, endperson) loop

Line 863: from pay_payroll_actions ppa

859: ppa.legislative_parameters)
860: ,pay_core_utils.get_parameter('FORMAT_NAME_CHOICE',
861: ppa.legislative_parameters)
862: into g_prm_legislation_code, p_format_name_choice
863: from pay_payroll_actions ppa
864: where ppa.payroll_action_id = pactid;
865:
866: if p_format_name_choice = 'A' then
867: g_prm_format_name := null;