APPS.PAY_FI_TELR dependencies on PAY_ACTION_INFORMATION

Line 17: l_payroll_action_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;

13: /* Start of declaration*/
14:
15: -- Variables needed for the report
16: l_counter number := 0;
17: l_payroll_action_id PAY_ACTION_INFORMATION.ACTION_INFORMATION1%TYPE;
18:
19: L_TARGET_YEAR VARCHAR2(4);
20: l_TEL_Action_id varchar2(30);
21:

Line 43: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE

39: /* End of declaration*/
40: /* Cursors */
41:
42: Cursor csr_TEL_PERSON_DETAILS(
43: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
44: )
45: IS
46: SELECT *
47: FROM PAY_ACTION_INFORMATION

Line 47: FROM PAY_ACTION_INFORMATION

43: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
44: )
45: IS
46: SELECT *
47: FROM PAY_ACTION_INFORMATION
48: WHERE ACTION_CONTEXT_TYPE = 'AAP'
49: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
50: AND ACTION_INFORMATION2='PER'
51: AND ACTION_INFORMATION1='PYFITELA'

Line 58: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE

54:
55: --lr_TEL_PERSON_DETAILS csr_TEL_PERSON_DETAILS%rowtype;
56:
57: Cursor csr_TEL_PER1_DETAILS(
58: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
59: ,CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
60: )
61: IS
62: SELECT ACTION_INFORMATION4 FIRST_CODE,

Line 78: FROM PAY_ACTION_INFORMATION PAI

74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||
76: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR
77: , PAI.*
78: FROM PAY_ACTION_INFORMATION PAI
79: WHERE ACTION_CONTEXT_TYPE = 'AAP'
80: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
81: AND ACTION_INFORMATION2='PER1'
82: AND ACTION_INFORMATION1='PYFITELA'

Line 90: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE

86:
87: lr_TEL_PER1_DETAILS csr_TEL_PER1_DETAILS%rowtype;
88:
89: Cursor CSR_REPORT_DETAILS(
90: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
91: )
92: IS
93: SELECT *
94: FROM PAY_ACTION_INFORMATION

Line 94: FROM PAY_ACTION_INFORMATION

90: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE
91: )
92: IS
93: SELECT *
94: FROM PAY_ACTION_INFORMATION
95: WHERE ACTION_CONTEXT_TYPE = 'PA'
96: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
97: AND ACTION_INFORMATION1='PYFITELA'
98: AND ACTION_CONTEXT_ID=csr_v_pa_id ;

Line 103: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,

99:
100: LR_REPORT_DETAILS CSR_REPORT_DETAILS%rowtype;
101:
102: CURSOR CSR_EIT_DETAILS (
103: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,
104: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,
105: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )
106: IS
107: SELECT *

Line 108: FROM PAY_ACTION_INFORMATION

104: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE,
105: CSR_V_COLUMN_NAME per_people_extra_info.PEI_INFORMATION3%TYPE )
106: IS
107: SELECT *
108: FROM PAY_ACTION_INFORMATION
109: WHERE ACTION_CONTEXT_TYPE = 'AAP'
110: AND ACTION_INFORMATION_CATEGORY ='EMEA REPORT INFORMATION'
111: AND ACTION_INFORMATION1 ='PYFITELA'
112: AND ACTION_INFORMATION2 ='PERSON_EIT'

Line 146: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,

142: LR_PERSON_EIT CSR_PERSON_EIT%ROWTYPE;
143:
144: -- for searching record 2 type
145: CURSOR CSR_RECORD_TWO_TYPE (
146: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,
147: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
148: )IS
149: SELECT DISTINCT(ACTION_INFORMATION3) "FOUND"
150: FROM PAY_ACTION_INFORMATION pai

Line 150: FROM PAY_ACTION_INFORMATION pai

146: csr_v_pa_id PAY_ACTION_INFORMATION. ACTION_INFORMATION1%TYPE,
147: CSR_V_PERSON_ID per_all_people_f.person_id%TYPE
148: )IS
149: SELECT DISTINCT(ACTION_INFORMATION3) "FOUND"
150: FROM PAY_ACTION_INFORMATION pai
151: WHERE pai.ACTION_CONTEXT_TYPE = 'AAP'
152: AND pai.ACTION_INFORMATION_CATEGORY ='EMEA REPORT INFORMATION'
153: AND pai.ACTION_INFORMATION2 ='PERSON_EIT'
154: AND pai.ACTION_INFORMATION1 ='PYFITELA'