eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_PIFSS dependencies on PAY_KW_PIFSS_REPORT

Line 18: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Report_Type')

14: procedure spawn_archive_reports;
15: --
16: CURSOR CSR_KW_PIFSS_HEADER IS
17: SELECT 'REPORT_TYPE=P'
18: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Report_Type')
19: ,'EMPLOYER_KEY=P'
20: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Key')
21: ,'FILE_ID=P'
22: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'File_ID')

Line 20: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Key')

16: CURSOR CSR_KW_PIFSS_HEADER IS
17: SELECT 'REPORT_TYPE=P'
18: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Report_Type')
19: ,'EMPLOYER_KEY=P'
20: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Key')
21: ,'FILE_ID=P'
22: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'File_ID')
23: ,'CREATION_DATE=P'
24: ,to_char(ppa.effective_date, 'YYYYMMDD')

Line 22: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'File_ID')

18: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Report_Type')
19: ,'EMPLOYER_KEY=P'
20: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Key')
21: ,'FILE_ID=P'
22: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'File_ID')
23: ,'CREATION_DATE=P'
24: ,to_char(ppa.effective_date, 'YYYYMMDD')
25: ,'ACTUAL_DATE=P'
26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')

Line 26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')

22: ,pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'File_ID')
23: ,'CREATION_DATE=P'
24: ,to_char(ppa.effective_date, 'YYYYMMDD')
25: ,'ACTUAL_DATE=P'
26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')
27: ,'TOT_EMPLOYEE=P'
28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

Line 28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

24: ,to_char(ppa.effective_date, 'YYYYMMDD')
25: ,'ACTUAL_DATE=P'
26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')
27: ,'TOT_EMPLOYEE=P'
28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'

Line 29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

25: ,'ACTUAL_DATE=P'
26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')
27: ,'TOT_EMPLOYEE=P'
28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

Line 30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

26: ,to_char(trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM'),'YYYYMMDD')
27: ,'TOT_EMPLOYEE=P'
28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

Line 31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))

27: ,'TOT_EMPLOYEE=P'
28: ,pay_kw_pifss_report.get_total_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

Line 33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

29: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'

Line 34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

30: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

Line 35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

31: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

Line 36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))

32: ,'CHANGE_EMPLOYEE=P'
33: ,pay_kw_pifss_report.get_change_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

Line 38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

34: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'

Line 39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

35: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

Line 40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

36: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

Line 41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))

37: ,'TERM_EMPLOYEE=P'
38: ,pay_kw_pifss_report.get_term_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

Line 43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),

39: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
46: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
47: ,'DATE_EARNED=C'

Line 44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),

40: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
46: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
47: ,'DATE_EARNED=C'
48: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')

Line 45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),

41: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
46: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
47: ,'DATE_EARNED=C'
48: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
49: ,'ORG_PAY_METHOD_ID=C'

Line 46: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))

42: ,'NEW_EMPLOYEE=P'
43: ,pay_kw_pifss_report.get_new_count(pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Employer_Id'),
44: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Month'),
45: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'Year'),
46: pay_kw_pifss_report.get_parameter(ppa.legislative_parameters,'LOCAL_NATIONALITY'))
47: ,'DATE_EARNED=C'
48: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
49: ,'ORG_PAY_METHOD_ID=C'
50: ,ppa.org_payment_method_id

Line 62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')

58: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
59: --
60: CURSOR CSR_KW_PIFSS_BODY IS
61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
63: ,'AMOUNT=P'
64: , pay_kw_pifss_report.get_amount_cont(
65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')
66: ||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'))

Line 64: , pay_kw_pifss_report.get_amount_cont(

60: CURSOR CSR_KW_PIFSS_BODY IS
61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
63: ,'AMOUNT=P'
64: , pay_kw_pifss_report.get_amount_cont(
65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')
66: ||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'))
67: ,'SSN=P'
68: ,nvl(hscl.segment2,' ')

Line 65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')

61: SELECT /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
63: ,'AMOUNT=P'
64: , pay_kw_pifss_report.get_amount_cont(
65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')
66: ||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'))
67: ,'SSN=P'
68: ,nvl(hscl.segment2,' ')
69: ,'CIVIL_ID=P'

Line 66: ||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'))

62: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
63: ,'AMOUNT=P'
64: , pay_kw_pifss_report.get_amount_cont(
65: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id'),paa.assignment_action_id,pef.person_id , to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')
66: ||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'))
67: ,'SSN=P'
68: ,nvl(hscl.segment2,' ')
69: ,'CIVIL_ID=P'
70: ,nvl(pef.national_identifier,' ')

Line 79: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||

75: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),
76: 'L',
77: NVL(hr_person_name.get_person_name
78: (pef.person_id
79: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
80: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
81: ,'DISPLAY_NAME'
82: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
83: pef.full_name)

Line 80: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

76: 'L',
77: NVL(hr_person_name.get_person_name
78: (pef.person_id
79: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
80: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
81: ,'DISPLAY_NAME'
82: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
83: pef.full_name)
84: ,'EFFECTIVE_DATE=P'

Line 87: ,nvl(pay_kw_pifss_report.get_change_indicator(pef.person_id),' ')

83: pef.full_name)
84: ,'EFFECTIVE_DATE=P'
85: ,to_char(ppa.effective_date,'YYYYMMDD')
86: ,'CHANGE_IND=P'
87: ,nvl(pay_kw_pifss_report.get_change_indicator(pef.person_id),' ')
88: ,'ASSIGNMENT_ID=C' , asg.assignment_id
89: ,'BUSINESS_GROUP_ID=C' , asg.business_group_id
90: ,'DATE_EARNED=C' , to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
91: ,'ORGANIZATION_ID=C' , asg.organization_id

Line 106: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

102: AND paa.payroll_action_id = ppa.payroll_action_id
103: AND ppa.action_type in ('R','Q')
104: AND ppa.action_status = 'C'
105: AND paa.action_status = 'C'
106: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
107: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
108: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
109: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
110: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date

Line 107: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

103: AND ppa.action_type in ('R','Q')
104: AND ppa.action_status = 'C'
105: AND paa.action_status = 'C'
106: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
107: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
108: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
109: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
110: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
111: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 109: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

105: AND paa.action_status = 'C'
106: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
107: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
108: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
109: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
110: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
111: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
112: AND hscl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
113: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')

Line 113: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')

109: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
110: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
111: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
112: AND hscl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
113: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')
114: AND leg.legislation_code = 'KW'
115: AND leg.rule_type = 'S'
116: AND leg.rule_mode = hscl.id_flex_num
117: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');

Line 117: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');

113: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')
114: AND leg.legislation_code = 'KW'
115: AND leg.rule_type = 'S'
116: AND leg.rule_mode = hscl.id_flex_num
117: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');
118: --
119: CURSOR CSR_KW_PIFSS_FOOTER IS
120: SELECT /*+ INDEX(hscl,HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
121: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')

Line 121: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')

117: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');
118: --
119: CURSOR CSR_KW_PIFSS_FOOTER IS
120: SELECT /*+ INDEX(hscl,HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
121: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
122: ,'EMPLOYER_KEY=P'
123: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Key')
124: ,'DED_SSN=P'
125: ,nvl(hscl.segment2,' ')

Line 123: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Key')

119: CURSOR CSR_KW_PIFSS_FOOTER IS
120: SELECT /*+ INDEX(hscl,HR_SOFT_CODING_KEYFLEX_PK) */ distinct 'REPORT_TYPE=P'
121: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type')
122: ,'EMPLOYER_KEY=P'
123: ,pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Key')
124: ,'DED_SSN=P'
125: ,nvl(hscl.segment2,' ')
126: ,'DED_CIVIL_ID=P'
127: ,nvl(pef.national_identifier,' ')

Line 136: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||

132: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),
133: 'L',
134: NVL(hr_person_name.get_person_name
135: (pef.person_id
136: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
137: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
138: ,'DISPLAY_NAME'
139: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
140: pef.full_name)

Line 137: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

133: 'L',
134: NVL(hr_person_name.get_person_name
135: (pef.person_id
136: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
137: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
138: ,'DISPLAY_NAME'
139: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
140: pef.full_name)
141: ,'DED_DETAIL=P'

Line 142: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),1,63),' ')

138: ,'DISPLAY_NAME'
139: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
140: pef.full_name)
141: ,'DED_DETAIL=P'
142: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),1,63),' ')
143: ,'DED_DETAIL2=P'
144: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),64,63),' ')
145: ,'DED_DETAIL3=P'
146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')

Line 144: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),64,63),' ')

140: pef.full_name)
141: ,'DED_DETAIL=P'
142: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),1,63),' ')
143: ,'DED_DETAIL2=P'
144: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),64,63),' ')
145: ,'DED_DETAIL3=P'
146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')
147: ,'DED_DETAIL4=P'
148: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),190,63),' ')

Line 146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')

142: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),1,63),' ')
143: ,'DED_DETAIL2=P'
144: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),64,63),' ')
145: ,'DED_DETAIL3=P'
146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')
147: ,'DED_DETAIL4=P'
148: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),190,63),' ')
149: ,'DED_DETAIL5=P'
150: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),253,63),' ')

Line 148: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),190,63),' ')

144: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),64,63),' ')
145: ,'DED_DETAIL3=P'
146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')
147: ,'DED_DETAIL4=P'
148: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),190,63),' ')
149: ,'DED_DETAIL5=P'
150: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),253,63),' ')
151: ,'ASSIGNMENT_ID=C' , asg.assignment_id
152: ,'BUSINESS_GROUP_ID=C' , asg.business_group_id

Line 150: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),253,63),' ')

146: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),127,63),' ')
147: ,'DED_DETAIL4=P'
148: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),190,63),' ')
149: ,'DED_DETAIL5=P'
150: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),253,63),' ')
151: ,'ASSIGNMENT_ID=C' , asg.assignment_id
152: ,'BUSINESS_GROUP_ID=C' , asg.business_group_id
153: ,'DATE_EARNED=C' , to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
154: ,'ORGANIZATION_ID=C' , asg.organization_id

Line 169: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

165: AND paa.payroll_action_id = ppa.payroll_action_id
166: AND ppa.action_type in ('R','Q')
167: AND ppa.action_status = 'C'
168: AND paa.action_status = 'C'
169: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
170: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
171: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
172: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
173: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date

Line 170: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

166: AND ppa.action_type in ('R','Q')
167: AND ppa.action_status = 'C'
168: AND paa.action_status = 'C'
169: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
170: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
171: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
172: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
173: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
174: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 172: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')

168: AND paa.action_status = 'C'
169: AND trunc(ppa.date_earned,'MM') = TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
170: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
171: between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
172: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
173: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
174: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
175: AND hscl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
176: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')

Line 176: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')

172: AND trunc(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
173: between trunc(pef.effective_start_date,'MM') and pef.effective_end_date
174: AND ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
175: AND hscl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
176: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')
177: AND leg.legislation_code = 'KW'
178: AND leg.rule_type = 'S'
179: AND leg.rule_mode = hscl.id_flex_num
180: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');

Line 180: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');

176: AND hscl.segment1 = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Employer_Id')
177: AND leg.legislation_code = 'KW'
178: AND leg.rule_type = 'S'
179: AND leg.rule_mode = hscl.id_flex_num
180: AND pef.nationality = pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'LOCAL_NATIONALITY');
181: --
182: END PAY_KW_PIFSS;