APPS.PAY_NL_NSI_PROCESS dependencies on PAY_PAYROLL_ACTIONS

Line 25: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

21: ,p_token in varchar2
22: ,p_segment_number in number default null ) RETURN varchar2
23: IS
24:
25: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
26: l_start_pos NUMBER;
27: l_delimiter varchar2(1):=' ';
28: l_proc VARCHAR2(40):= g_package||' get parameter ';
29:

Line 90: FROM pay_payroll_actions

86: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'PAYROLL_ID')
87: ,PAY_NL_NSI_PROCESS.get_parameter(legislative_parameters,'WITHDRAW_ASG_SET_ID')
88: ,business_group_id
89: ,report_type
90: FROM pay_payroll_actions
91: WHERE payroll_action_id = p_payroll_action_id;
92:
93: --
94:

Line 213: l_report_type pay_payroll_actions.report_type%TYPE;

209: l_nsi_month VARCHAR2(10);
210: l_output_media_type VARCHAR2(10);
211: l_payroll_id NUMBER;
212: l_withdraw_asg_set_id NUMBER;
213: l_report_type pay_payroll_actions.report_type%TYPE;
214: --
215:
216: --
217: l_Sender_Reg_Number VARCHAR2(15);

Line 412: ,pay_payroll_actions ppa

408: ,p_action_information8 => l_Employer_Reg_Number
409: );
410: sqlstr := 'SELECT DISTINCT person_id
411: FROM per_people_f ppf
412: ,pay_payroll_actions ppa
413: WHERE ppa.payroll_action_id = :payroll_action_id
414: AND ppa.business_group_id = ppf.business_group_id
415: ORDER BY ppf.person_id';
416: ELSE

Line 419: ,pay_payroll_actions ppa

415: ORDER BY ppf.person_id';
416: ELSE
417: sqlstr := 'SELECT DISTINCT person_id
418: FROM per_people_f ppf
419: ,pay_payroll_actions ppa
420: WHERE ppa.payroll_action_id = :payroll_action_id
421: AND 1 = 2
422: AND ppa.business_group_id = ppf.business_group_id
423: ORDER BY ppf.person_id';

Line 1965: l_report_type pay_payroll_actions.report_type%TYPE;

1961: l_nsi_month VARCHAR2(10);
1962: l_output_media_type VARCHAR2(10);
1963: l_payroll_id NUMBER;
1964: l_withdraw_asg_set_id NUMBER;
1965: l_report_type pay_payroll_actions.report_type%TYPE;
1966:
1967: --
1968: --
1969: l_prepay_action_id NUMBER;