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_IE_SB_API dependencies on PAY_IE_SOCIAL_BENEFITS_F

Line 53: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;

49: FROM per_all_assignments_f
50: WHERE assignment_id = p_assignment_id
51: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
52: --
53: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
54: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
55: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
56: --
57: begin

Line 54: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;

50: WHERE assignment_id = p_assignment_id
51: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
52: --
53: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
54: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
55: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
56: --
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 55: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;

51: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
52: --
53: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
54: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
55: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
56: --
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --

Line 240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;

236: l_request_id number;
237: l_prog_appl_id number;
238: l_program_id number;
239: --
240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;
244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;

Line 241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;

237: l_prog_appl_id number;
238: l_program_id number;
239: --
240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;
244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;
245:

Line 242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;

238: l_program_id number;
239: --
240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;
244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;
245:
246: --

Line 243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;

239: --
240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;
244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;
245:
246: --
247: CURSOR asg_csr IS

Line 244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;

240: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;
241: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
242: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
243: l_reduced_tax_credit pay_ie_social_benefits_f.reduced_tax_credit%type := p_reduced_tax_credit;
244: l_reduced_standard_cutoff pay_ie_social_benefits_f.reduced_standard_cutoff%type := p_reduced_standard_cutoff;
245:
246: --
247: CURSOR asg_csr IS
248: SELECT assignment_id,calculation_option

Line 249: FROM pay_ie_social_benefits_f

245:
246: --
247: CURSOR asg_csr IS
248: SELECT assignment_id,calculation_option
249: FROM pay_ie_social_benefits_f
250: WHERE social_benefit_id = p_social_benefit_id
251: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
252: --
253: CURSOR business_group_csr IS

Line 259: t_calculation_option pay_ie_social_benefits_f.calculation_option%type;

255: FROM per_all_assignments_f
256: WHERE assignment_id = l_assignment_id
257: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
258: --
259: t_calculation_option pay_ie_social_benefits_f.calculation_option%type;
260: begin
261: hr_utility.set_location('Entering:'|| l_proc, 10);
262: --
263: -- Issue a savepoint

Line 470: FROM pay_ie_social_benefits_f

466: l_effective_end_date date;
467: --
468: CURSOR asg_csr IS
469: SELECT assignment_id
470: FROM pay_ie_social_benefits_f
471: WHERE social_benefit_id = p_social_benefit_id
472: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
473: --
474: CURSOR business_group_csr IS