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_GB_P11D_CAR_EXTRACT dependencies on BEN_EXT_PERSON

Line 45: ben_ext_person.g_effective_date ));

41: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
42: 'PAY GB P11D Car Extract',
43: 'Parameter Value',
44: 'Extract Start Date (DD-MON-YYYY)',
45: ben_ext_person.g_effective_date ));
46: EXCEPTION
47: WHEN others THEN
48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year

Line 50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))

46: EXCEPTION
47: WHEN others THEN
48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

Line 51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN

47: WHEN others THEN
48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;

Line 52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));

48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;
56: END;

Line 54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;
56: END;
57: --
58: RETURN l_ext_start_date;

Line 75: ben_ext_person.g_effective_date ));

71: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
72: 'PAY GB P11D Car Extract',
73: 'Parameter Value',
74: 'Extract End Date (DD-MON-YYYY)',
75: ben_ext_person.g_effective_date ));
76: EXCEPTION
77: WHEN others THEN
78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year

Line 80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))

76: EXCEPTION
77: WHEN others THEN
78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));

Line 81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN

77: WHEN others THEN
78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;

Line 82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;
86: END;

Line 84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));

80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;
86: END;
87: --
88: RETURN l_ext_end_date;

Line 105: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;

101: SELECT payroll_id
102: FROM pay_all_payrolls_f
103: WHERE payroll_name = l_payroll_name
104: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
105: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
106: --
107: BEGIN
108: -- Get user Table Value
109: BEGIN

Line 115: ben_ext_person.g_effective_date );

111: l_payroll_name := hruserdt.get_table_value(p_bus_group_id,
112: 'PAY GB P11D Car Extract',
113: 'Parameter Value',
114: 'Payroll Name',
115: ben_ext_person.g_effective_date );
116: --
117: -- Get Payroll_id
118: OPEN get_payroll_id;
119: FETCH get_payroll_id INTO l_payroll_id;

Line 147: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;

143: SELECT person_id
144: FROM per_all_people_f
145: WHERE employee_number = l_employee_number
146: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
147: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
148: --
149: BEGIN
150: BEGIN
151: -- Get Employee Number Parameter Value

Line 156: ben_ext_person.g_effective_date );

152: l_employee_number := hruserdt.get_table_value(p_bus_group_id,
153: 'PAY GB P11D Car Extract',
154: 'Parameter Value',
155: 'Employee Number',
156: ben_ext_person.g_effective_date );
157: --
158: -- Get Person Id
159: OPEN get_person_id;
160: FETCH get_person_id INTO l_person_id;

Line 189: ben_ext_person.g_effective_date );

185: l_tax_dist := hruserdt.get_table_value(p_bus_group_id,
186: 'PAY GB P11D Car Extract',
187: 'Parameter Value',
188: 'Tax DIstrict Reference',
189: ben_ext_person.g_effective_date );
190: --
191: EXCEPTION
192: WHEN others THEN
193: l_tax_dist := NULL;

Line 223: ben_ext_person.g_effective_date );

219: l_consolidation_set := hruserdt.get_table_value(p_bus_group_id,
220: 'PAY GB P11D Car Extract',
221: 'Parameter Value',
222: 'Consolidation Set',
223: ben_ext_person.g_effective_date );
224: --
225: -- Get Consolidation Set Id
226: OPEN get_consolidation_set_id;
227: FETCH get_consolidation_set_id INTO l_consolidation_set_id;

Line 263: ben_ext_person.g_effective_date );

259: l_assignment_set := hruserdt.get_table_value(p_bus_group_id,
260: 'PAY GB P11D Car Extract',
261: 'Parameter Value',
262: 'Assignment Set',
263: ben_ext_person.g_effective_date );
264: --
265: -- Get Assignment Set Id
266: OPEN get_assignment_set_id;
267: FETCH get_assignment_set_id INTO l_assignment_set_id;

Line 991: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date

987: per_all_assignments_f asg,
988: hr_soft_coding_keyflex flex
989: WHERE asg.assignment_id = p_asg_id
990: AND asg.payroll_id = pp.payroll_id
991: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
992: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
993: AND asg.effective_start_date < l_ext_end_date
994: AND asg.effective_end_Date > l_ext_start_date;
995: --

Line 1003: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

999: hr_assignment_sets has,
1000: per_all_assignments_f paaf
1001: WHERE has.assignment_set_id = l_ext_asg_set_id
1002: AND paaf.assignment_id = p_asg_id
1003: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1004: AND has.assignment_set_id = hasa.assignment_set_id (+)
1005: AND NVL (hasa.assignment_id, paaf.assignment_id) = paaf.assignment_id
1006: AND NVL (hasa.include_or_exclude, 'I') = 'I'
1007: AND NVL (has.payroll_id, paaf.payroll_id) = paaf.payroll_id;