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

Line 22: FROM pay_action_information

18: end_date_of_birth,
19: fnd_date.canonical_to_date (action_information18) precedence_end_date,
20: fnd_date.canonical_to_date (action_information19)
21: report_date, action_information20 sort_order
22: FROM pay_action_information
23: WHERE action_context_id = p_payroll_action_id AND action_information_category = 'EMEA REPORT DETAILS';
24:
25: rec_report_parameters csr_report_parameters%ROWTYPE;
26:

Line 29: csr_v_pa_id pay_action_information.action_context_id%TYPE

25: rec_report_parameters csr_report_parameters%ROWTYPE;
26:
27: --Cursors needed for report
28: CURSOR csr_all_legal_employer (
29: csr_v_pa_id pay_action_information.action_context_id%TYPE
30: ) IS
31: SELECT action_information3 legal_emp_id, action_information4 legal_employer_name, action_information5 org_number,
32: effective_date
33: FROM pay_action_information

Line 33: FROM pay_action_information

29: csr_v_pa_id pay_action_information.action_context_id%TYPE
30: ) IS
31: SELECT action_information3 legal_emp_id, action_information4 legal_employer_name, action_information5 org_number,
32: effective_date
33: FROM pay_action_information
34: WHERE action_context_type = 'PA'
35: AND action_context_id = csr_v_pa_id
36: AND action_information_category = 'EMEA REPORT INFORMATION'
37: AND action_information1 = 'PYSETRNA'

Line 42: csr_v_pa_id pay_action_information.action_context_id%TYPE,

38: AND action_information2 = 'LE';
39:
40: /* All Division */
41: CURSOR csr_get_all_divisons (
42: csr_v_pa_id pay_action_information.action_context_id%TYPE,
43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division

Line 43: p_legal_employer_id pay_action_information.action_information13%TYPE --,

39:
40: /* All Division */
41: CURSOR csr_get_all_divisons (
42: csr_v_pa_id pay_action_information.action_context_id%TYPE,
43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division
47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

Line 44: -- p_sort_order pay_action_information.action_information20%TYPE

40: /* All Division */
41: CURSOR csr_get_all_divisons (
42: csr_v_pa_id pay_action_information.action_context_id%TYPE,
43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division
47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
48: WHERE paa.payroll_action_id = p_payroll_action_id

Line 47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division
47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
48: WHERE paa.payroll_action_id = p_payroll_action_id
49: AND assg.payroll_action_id = paa.payroll_action_id
50: AND pai.action_context_id = assg.assignment_action_id
51: AND action_context_type = 'AAP'

Line 59: csr_v_pa_id pay_action_information.action_context_id%TYPE,

55: AND action_information13 = p_legal_employer_id;
56:
57: /* All Agreement Areas */
58: CURSOR csr_get_all_areas (
59: csr_v_pa_id pay_action_information.action_context_id%TYPE,
60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area

Line 60: p_legal_employer_id pay_action_information.action_information13%TYPE,

56:
57: /* All Agreement Areas */
58: CURSOR csr_get_all_areas (
59: csr_v_pa_id pay_action_information.action_context_id%TYPE,
60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

Line 61: p_div pay_action_information.action_information14%TYPE

57: /* All Agreement Areas */
58: CURSOR csr_get_all_areas (
59: csr_v_pa_id pay_action_information.action_context_id%TYPE,
60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
65: WHERE paa.payroll_action_id = p_payroll_action_id

Line 64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
65: WHERE paa.payroll_action_id = p_payroll_action_id
66: AND assg.payroll_action_id = paa.payroll_action_id
67: AND pai.action_context_id = assg.assignment_action_id
68: AND action_context_type = 'AAP'

Line 75: l_payroll_action_id pay_action_information.action_information1%TYPE;

71: AND action_information1 = 'PYSETRNA'
72: AND action_information13 = p_legal_employer_id
73: AND action_information14 = p_div;
74:
75: l_payroll_action_id pay_action_information.action_information1%TYPE;
76: l_counter NUMBER := 0;
77: l_count NUMBER := 0;
78: p_sql VARCHAR2 (10000);
79: l_national_identifier pay_action_information.action_information4%TYPE;

Line 79: l_national_identifier pay_action_information.action_information4%TYPE;

75: l_payroll_action_id pay_action_information.action_information1%TYPE;
76: l_counter NUMBER := 0;
77: l_count NUMBER := 0;
78: p_sql VARCHAR2 (10000);
79: l_national_identifier pay_action_information.action_information4%TYPE;
80: l_assignment_number pay_action_information.action_information5%TYPE;
81: l_full_name pay_action_information.action_information6%TYPE;
82: l_hire_date DATE;
83: l_total_emp_time NUMBER;

Line 80: l_assignment_number pay_action_information.action_information5%TYPE;

76: l_counter NUMBER := 0;
77: l_count NUMBER := 0;
78: p_sql VARCHAR2 (10000);
79: l_national_identifier pay_action_information.action_information4%TYPE;
80: l_assignment_number pay_action_information.action_information5%TYPE;
81: l_full_name pay_action_information.action_information6%TYPE;
82: l_hire_date DATE;
83: l_total_emp_time NUMBER;
84: l_precedence_date DATE;

Line 81: l_full_name pay_action_information.action_information6%TYPE;

77: l_count NUMBER := 0;
78: p_sql VARCHAR2 (10000);
79: l_national_identifier pay_action_information.action_information4%TYPE;
80: l_assignment_number pay_action_information.action_information5%TYPE;
81: l_full_name pay_action_information.action_information6%TYPE;
82: l_hire_date DATE;
83: l_total_emp_time NUMBER;
84: l_precedence_date DATE;
85: l_termination_date DATE;

Line 86: l_emp_type pay_action_information.action_information11%TYPE;

82: l_hire_date DATE;
83: l_total_emp_time NUMBER;
84: l_precedence_date DATE;
85: l_termination_date DATE;
86: l_emp_type pay_action_information.action_information11%TYPE;
87: l_emp_sec pay_action_information.action_information12%TYPE;
88: l_select_str VARCHAR2 (3000);
89:
90: TYPE emp_ref IS REF CURSOR;

Line 87: l_emp_sec pay_action_information.action_information12%TYPE;

83: l_total_emp_time NUMBER;
84: l_precedence_date DATE;
85: l_termination_date DATE;
86: l_emp_type pay_action_information.action_information11%TYPE;
87: l_emp_sec pay_action_information.action_information12%TYPE;
88: l_select_str VARCHAR2 (3000);
89:
90: TYPE emp_ref IS REF CURSOR;
91:

Line 211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

207: precedence_date,
208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
209: action_information12
210: emp_sec
211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
212: WHERE paa.payroll_action_id = '
213: || l_payroll_action_id
214: || ' AND assg.payroll_action_id = paa.payroll_action_id
215: AND pai.action_context_id = assg.assignment_action_id