APPS.PAY_SE_TETR dependencies on PAY_ACTION_INFORMATION

Line 16: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;

12: /* Start of declaration*/
13:
14: -- Variables needed for the report
15: l_counter number := 0;
16: l_payroll_action_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE;
17:
18: /* End of declaration*/
19:
20: /* Cursors */

Line 22: Cursor csr_tetr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)

18: /* End of declaration*/
19:
20: /* Cursors */
21:
22: Cursor csr_tetr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
23: IS
24: SELECT *
25: FROM PAY_ACTION_INFORMATION
26: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 25: FROM PAY_ACTION_INFORMATION

21:
22: Cursor csr_tetr_header_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
23: IS
24: SELECT *
25: FROM PAY_ACTION_INFORMATION
26: WHERE ACTION_CONTEXT_TYPE = 'PA'
27: AND ACTION_CONTEXT_ID = csr_v_pa_id
28: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
29: AND ACTION_INFORMATION1='PYSETETA';

Line 32: Cursor csr_tetr_ph_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

28: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
29: AND ACTION_INFORMATION1='PYSETETA';
30:
31:
32: Cursor csr_tetr_ph_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
33: IS
34: SELECT *
35: FROM PAY_ACTION_INFORMATION
36: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 35: FROM PAY_ACTION_INFORMATION

31:
32: Cursor csr_tetr_ph_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
33: IS
34: SELECT *
35: FROM PAY_ACTION_INFORMATION
36: WHERE ACTION_CONTEXT_TYPE = 'PA'
37: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
38: AND ACTION_INFORMATION1='PYSETETA'
39: AND ACTION_INFORMATION2=csr_v_pa_id

Line 43: Cursor csr_tetr_ch_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

39: AND ACTION_INFORMATION2=csr_v_pa_id
40: AND ACTION_INFORMATION11='PH'
41: ORDER BY TO_DATE(action_information8) DESC;
42:
43: Cursor csr_tetr_ch_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
44: IS
45: SELECT *
46: FROM PAY_ACTION_INFORMATION
47: WHERE ACTION_CONTEXT_TYPE = 'AAP'

Line 46: FROM PAY_ACTION_INFORMATION

42:
43: Cursor csr_tetr_ch_body(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
44: IS
45: SELECT *
46: FROM PAY_ACTION_INFORMATION
47: WHERE ACTION_CONTEXT_TYPE = 'AAP'
48: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
49: AND ACTION_INFORMATION1='PYSETETA'
50: AND ACTION_INFORMATION2=csr_v_pa_id

Line 55: Cursor csr_tetr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)

51: AND ACTION_INFORMATION11='CH'
52: ORDER BY TO_DATE(action_information8) DESC;
53:
54:
55: Cursor csr_tetr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
56: IS
57: SELECT *
58: FROM PAY_ACTION_INFORMATION
59: WHERE ACTION_CONTEXT_TYPE = 'AAP'

Line 58: FROM PAY_ACTION_INFORMATION

54:
55: Cursor csr_tetr_body_rpt(csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE)
56: IS
57: SELECT *
58: FROM PAY_ACTION_INFORMATION
59: WHERE ACTION_CONTEXT_TYPE = 'AAP'
60: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
61: AND ACTION_INFORMATION1='PYSETETA'
62: AND ACTION_INFORMATION2=csr_v_pa_id

Line 67: Cursor csr_tetr_footer_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)

63: AND ACTION_INFORMATION11='CS'
64: ORDER BY action_information4,action_information6;
65:
66:
67: Cursor csr_tetr_footer_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
68: IS
69: SELECT *
70: FROM PAY_ACTION_INFORMATION
71: WHERE ACTION_CONTEXT_TYPE = 'PA'

Line 70: FROM PAY_ACTION_INFORMATION

66:
67: Cursor csr_tetr_footer_rpt(csr_v_pa_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE)
68: IS
69: SELECT *
70: FROM PAY_ACTION_INFORMATION
71: WHERE ACTION_CONTEXT_TYPE = 'PA'
72: AND ACTION_CONTEXT_ID = csr_v_pa_id
73: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
74: AND ACTION_INFORMATION1='PYSETETA'