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_SE_SALARY_STRUCTURE_STATS dependencies on PAY_ACTION_INFORMATION

Line 392: pay_action_information_api.create_action_information

388: OPEN csr_legal_employer_details(g_business_group_id,g_legal_employer_id);
389: FETCH csr_legal_employer_details INTO l_legal_employer,l_Organization_Id,l_Membership_Number;
390: CLOSE csr_legal_employer_details;
391:
392: pay_action_information_api.create_action_information
393: (p_action_information_id => l_action_info_id
394: , p_action_context_id => p_payroll_action_id
395: , p_action_context_type => 'PA'
396: , p_object_version_number => l_ovn

Line 421: pay_action_information_api.create_action_information

417: OPEN csr_salary_structure_details(g_business_group_id,g_legal_employer_id);
418: FETCH csr_salary_structure_details INTO l_worksite_number,l_association_number,
419: l_legal_agreement_code,l_weekend_duty;
420: CLOSE csr_salary_structure_details;
421: pay_action_information_api.create_action_information
422: (p_action_information_id => l_action_info_id
423: , p_action_context_id => p_payroll_action_id
424: , p_action_context_type => 'PA'
425: , p_object_version_number => l_ovn

Line 447: pay_action_information_api.create_action_information

443: l_local_unit_id:=csr_legal_employer.local_unit;
444: OPEN csr_local_unit_details (l_local_unit_id);
445: FETCH csr_local_unit_details INTO l_cfar_number;
446: CLOSE csr_local_unit_details;
447: pay_action_information_api.create_action_information
448: (p_action_information_id => l_action_info_id
449: , p_action_context_id => p_payroll_action_id
450: , p_action_context_type => 'PA'
451: , p_object_version_number => l_ovn

Line 476: pay_action_information_api.create_action_information

472: OPEN csr_salary_structure_details(g_business_group_id,g_legal_employer_id);
473: FETCH csr_salary_structure_details INTO l_worksite_number,l_association_number,
474: l_legal_agreement_code,l_weekend_duty;
475: CLOSE csr_salary_structure_details;
476: pay_action_information_api.create_action_information
477: (p_action_information_id => l_action_info_id
478: , p_action_context_id => p_payroll_action_id
479: , p_action_context_type => 'PA'
480: , p_object_version_number => l_ovn

Line 502: pay_action_information_api.create_action_information

498: l_local_unit_id:=csr_legal_employer.local_unit;
499: OPEN csr_local_unit_details (l_local_unit_id);
500: FETCH csr_local_unit_details INTO l_cfar_number;
501: CLOSE csr_local_unit_details;
502: pay_action_information_api.create_action_information
503: (p_action_information_id => l_action_info_id
504: , p_action_context_id => p_payroll_action_id
505: , p_action_context_type => 'PA'
506: , p_object_version_number => l_ovn

Line 1220: pay_action_information_api.create_action_information

1216: P_VIRTUAL_DATE=>g_end_date),0);
1217: l_808_steering_code:=l_808_steering_code+l_value;
1218: END LOOP;
1219: fnd_file.put_line(fnd_file.LOG,'Before first insertion');
1220: pay_action_information_api.create_action_information
1221: (p_action_information_id => l_action_info_id
1222: , p_action_context_id => p_payroll_action_id
1223: , p_action_context_type => 'PA'
1224: , p_object_version_number => l_ovn

Line 1257: pay_action_information_api.create_action_information

1253: , p_action_information25 => l_601_steering_code
1254: , p_action_information26 => l_810_steering_code
1255: );
1256: fnd_file.put_line(fnd_file.LOG,'Before second insertion');
1257: pay_action_information_api.create_action_information
1258: (p_action_information_id => l_action_info_id
1259: , p_action_context_id => p_payroll_action_id
1260: , p_action_context_type => 'PA'
1261: , p_object_version_number => l_ovn

Line 1598: pay_action_information_api.create_action_information

1594: P_VIRTUAL_DATE=>g_end_date),0);
1595: l_808_steering_code:=l_808_steering_code+l_value;
1596: END LOOP;
1597: fnd_file.put_line(fnd_file.LOG,'Before first insertion');
1598: pay_action_information_api.create_action_information
1599: (p_action_information_id => l_action_info_id
1600: , p_action_context_id => p_payroll_action_id
1601: , p_action_context_type => 'PA'
1602: , p_object_version_number => l_ovn

Line 1635: pay_action_information_api.create_action_information

1631: , p_action_information25 => l_601_steering_code
1632: , p_action_information26 => l_810_steering_code
1633: );
1634: fnd_file.put_line(fnd_file.LOG,'Before second insertion');
1635: pay_action_information_api.create_action_information
1636: (p_action_information_id => l_action_info_id
1637: , p_action_context_id => p_payroll_action_id
1638: , p_action_context_type => 'PA'
1639: , p_object_version_number => l_ovn

Line 2021: l_action_information_id pay_action_information.action_information_id%TYPE;

2017: l_salary NUMBER:=0;
2018: l_grand_salary NUMBER:=0;
2019: l_legal_employer hr_organization_units.name%type;
2020: l_local_unit hr_organization_units.name%type;
2021: l_action_information_id pay_action_information.action_information_id%TYPE;
2022: l_month varchar2(20);
2023: l_year NUMBER;
2024: l_retroactive_date_from DATE;
2025: l_retroactive_date_to DATE;

Line 2074: pay_action_information pai,

2070: CURSOR csr_report_year(csr_v_payroll_action_id number)
2071: IS
2072: SELECT pai.action_information6 Report_Year
2073: FROM
2074: pay_action_information pai,
2075: pay_payroll_actions ppa
2076: WHERE
2077: ppa.payroll_action_id=csr_v_payroll_action_id--175110 --csr_v_payroll_action_id
2078: AND ppa.payroll_action_id=pai.action_context_id

Line 2124: pay_action_information pai1,

2120: decode(nvl(pai4.action_information10,0) ,0,'0000000',pai4.action_information10) Steering_Code_805,
2121: decode(nvl(pai4.action_information11,0) ,0,'0000000',pai4.action_information11) Steering_Code_806,
2122: decode(nvl(pai4.action_information12,0) ,0,'0000000',pai4.action_information12) Steering_Code_808
2123: FROM
2124: pay_action_information pai1,
2125: pay_action_information pai2,
2126: pay_action_information pai3,
2127: pay_action_information pai4,
2128: pay_payroll_actions ppa

Line 2125: pay_action_information pai2,

2121: decode(nvl(pai4.action_information11,0) ,0,'0000000',pai4.action_information11) Steering_Code_806,
2122: decode(nvl(pai4.action_information12,0) ,0,'0000000',pai4.action_information12) Steering_Code_808
2123: FROM
2124: pay_action_information pai1,
2125: pay_action_information pai2,
2126: pay_action_information pai3,
2127: pay_action_information pai4,
2128: pay_payroll_actions ppa
2129: WHERE

Line 2126: pay_action_information pai3,

2122: decode(nvl(pai4.action_information12,0) ,0,'0000000',pai4.action_information12) Steering_Code_808
2123: FROM
2124: pay_action_information pai1,
2125: pay_action_information pai2,
2126: pay_action_information pai3,
2127: pay_action_information pai4,
2128: pay_payroll_actions ppa
2129: WHERE
2130: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --175079 --175068 --csr_v_payroll_action_id

Line 2127: pay_action_information pai4,

2123: FROM
2124: pay_action_information pai1,
2125: pay_action_information pai2,
2126: pay_action_information pai3,
2127: pay_action_information pai4,
2128: pay_payroll_actions ppa
2129: WHERE
2130: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --175079 --175068 --csr_v_payroll_action_id
2131: AND ppa.payroll_action_id=pai1.action_context_id

Line 2167: pay_action_information pai,

2163: CURSOR csr_local_unit_count(csr_v_payroll_action_id number, csr_v_CFAR_Number VARCHAR2)
2164: IS
2165: SELECT nvl(COUNT(*),0) Local_Unit_Count
2166: FROM
2167: pay_action_information pai,
2168: pay_action_information pai1,
2169: pay_payroll_actions ppa
2170: WHERE
2171: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --csr_v_payroll_action_id

Line 2168: pay_action_information pai1,

2164: IS
2165: SELECT nvl(COUNT(*),0) Local_Unit_Count
2166: FROM
2167: pay_action_information pai,
2168: pay_action_information pai1,
2169: pay_payroll_actions ppa
2170: WHERE
2171: ppa.payroll_action_id=csr_v_payroll_action_id --175110 --csr_v_payroll_action_id
2172: AND ppa.payroll_action_id=pai.action_context_id