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.PQP_PENSION_FUNCTIONS dependencies on FND_DATE

Line 2113: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)

2109: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2110: AND information_type = 'NL_ABP_PAR_INFO'
2111: AND assignment_id = p_assignment_id
2112: AND aei_information10 IS NOT NULL
2113: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2114: AND fnd_date.canonical_to_date(nvl(aei_information2
2115: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2116:
2117: -- =======================================================================

Line 2114: AND fnd_date.canonical_to_date(nvl(aei_information2

2110: AND information_type = 'NL_ABP_PAR_INFO'
2111: AND assignment_id = p_assignment_id
2112: AND aei_information10 IS NOT NULL
2113: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2114: AND fnd_date.canonical_to_date(nvl(aei_information2
2115: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2116:
2117: -- =======================================================================
2118: -- Cursor to get the choice for average PTP calculation from ORG EIT

Line 2115: ,fnd_date.date_to_canonical(hr_api.g_eot)));

2111: AND assignment_id = p_assignment_id
2112: AND aei_information10 IS NOT NULL
2113: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2114: AND fnd_date.canonical_to_date(nvl(aei_information2
2115: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2116:
2117: -- =======================================================================
2118: -- Cursor to get the choice for average PTP calculation from ORG EIT
2119: -- =======================================================================

Line 2137: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)

2133: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2134: AND information_type = 'NL_ABP_PAR_INFO'
2135: AND assignment_id = p_assignment_id
2136: AND aei_information11 IS NOT NULL
2137: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2138: AND fnd_date.canonical_to_date(nvl(aei_information2
2139: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2140:
2141: -- =======================================================================

Line 2138: AND fnd_date.canonical_to_date(nvl(aei_information2

2134: AND information_type = 'NL_ABP_PAR_INFO'
2135: AND assignment_id = p_assignment_id
2136: AND aei_information11 IS NOT NULL
2137: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2138: AND fnd_date.canonical_to_date(nvl(aei_information2
2139: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2140:
2141: -- =======================================================================
2142: -- Cursor to get the choice for OHT from ORG EIT

Line 2139: ,fnd_date.date_to_canonical(hr_api.g_eot)));

2135: AND assignment_id = p_assignment_id
2136: AND aei_information11 IS NOT NULL
2137: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2138: AND fnd_date.canonical_to_date(nvl(aei_information2
2139: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2140:
2141: -- =======================================================================
2142: -- Cursor to get the choice for OHT from ORG EIT
2143: -- =======================================================================

Line 3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)

3304: select 1 from dual
3305: where exists (select 1 from hr_organization_information
3306: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3307: AND organization_id = c_org_id
3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3309: and fnd_date.canonical_to_date(nvl(org_information5,
3310: fnd_date.date_to_canonical(hr_api.g_eot)))
3311: );
3312:

Line 3309: and fnd_date.canonical_to_date(nvl(org_information5,

3305: where exists (select 1 from hr_organization_information
3306: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3307: AND organization_id = c_org_id
3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3309: and fnd_date.canonical_to_date(nvl(org_information5,
3310: fnd_date.date_to_canonical(hr_api.g_eot)))
3311: );
3312:
3313: --Cursor to find the parent id from the org id

Line 3310: fnd_date.date_to_canonical(hr_api.g_eot)))

3306: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3307: AND organization_id = c_org_id
3308: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3309: and fnd_date.canonical_to_date(nvl(org_information5,
3310: fnd_date.date_to_canonical(hr_api.g_eot)))
3311: );
3312:
3313: --Cursor to find the parent id from the org id
3314: CURSOR c_find_parent_id(c_org_id in number

Line 3333: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)

3329: AND hoi.organization_id = c_org_id
3330: AND pty.pension_type_id = p_pension_type_id
3331: AND p_date_earned between pty.effective_start_date
3332: and pty.effective_end_date
3333: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3334: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3335: fnd_date.date_to_canonical(hr_api.g_eot))
3336: );
3337: --Cursor to find the pension type name from the pension type id

Line 3334: and fnd_date.canonical_to_date(nvl(hoi.org_information5,

3330: AND pty.pension_type_id = p_pension_type_id
3331: AND p_date_earned between pty.effective_start_date
3332: and pty.effective_end_date
3333: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3334: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3335: fnd_date.date_to_canonical(hr_api.g_eot))
3336: );
3337: --Cursor to find the pension type name from the pension type id
3338: CURSOR c_find_pen_type_name Is

Line 3335: fnd_date.date_to_canonical(hr_api.g_eot))

3331: AND p_date_earned between pty.effective_start_date
3332: and pty.effective_end_date
3333: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3334: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3335: fnd_date.date_to_canonical(hr_api.g_eot))
3336: );
3337: --Cursor to find the pension type name from the pension type id
3338: CURSOR c_find_pen_type_name Is
3339: SELECT pension_type_name

Line 4744: AND p_date_earned BETWEEN fnd_date.canonical_to_date(nvl(aei_information4,fnd_date.date_to_canonical(to_date('01-01-1951','dd-mm-yyyy'))))

4740: FROM per_assignment_extra_info
4741: WHERE assignment_id = p_assignment_id
4742: AND aei_information1 = to_char(p_pension_type_id)
4743: AND aei_information2 = to_char(p_payroll_period_number)
4744: AND p_date_earned BETWEEN fnd_date.canonical_to_date(nvl(aei_information4,fnd_date.date_to_canonical(to_date('01-01-1951','dd-mm-yyyy'))))
4745: AND fnd_date.canonical_to_date(nvl(aei_information5,fnd_date.date_to_canonical(to_date('31-12-4712','dd-mm-yyyy'))))
4746: AND aei_information_category = 'NL_SAV_INFO'
4747: AND information_type = 'NL_SAV_INFO';
4748:

Line 4745: AND fnd_date.canonical_to_date(nvl(aei_information5,fnd_date.date_to_canonical(to_date('31-12-4712','dd-mm-yyyy'))))

4741: WHERE assignment_id = p_assignment_id
4742: AND aei_information1 = to_char(p_pension_type_id)
4743: AND aei_information2 = to_char(p_payroll_period_number)
4744: AND p_date_earned BETWEEN fnd_date.canonical_to_date(nvl(aei_information4,fnd_date.date_to_canonical(to_date('01-01-1951','dd-mm-yyyy'))))
4745: AND fnd_date.canonical_to_date(nvl(aei_information5,fnd_date.date_to_canonical(to_date('31-12-4712','dd-mm-yyyy'))))
4746: AND aei_information_category = 'NL_SAV_INFO'
4747: AND information_type = 'NL_SAV_INFO';
4748:
4749: l_ret_val NUMBER;

Line 4971: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

4967: --
4968: l_inputs(1).name := 'ASSIGNMENT_ID';
4969: l_inputs(1).value := p_assignment_id;
4970: l_inputs(2).name := 'DATE_EARNED';
4971: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
4972: l_inputs(3).name := 'BUSINESS_GROUP_ID';
4973: l_inputs(3).value := p_business_group_id;
4974: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
4975: l_inputs(4).value := p_assignment_action_id;

Line 4979: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

4975: l_inputs(4).value := p_assignment_action_id;
4976: l_inputs(5).name := 'PAYROLL_ACTION_ID';
4977: l_inputs(5).value := l_payroll_action_id;
4978: l_inputs(6).name := 'BALANCE_DATE';
4979: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
4980: --
4981: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
4982: --
4983: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,

Line 5058: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

5054: --
5055: l_inputs(1).name := 'ASSIGNMENT_ID';
5056: l_inputs(1).value := p_assignment_id;
5057: l_inputs(2).name := 'DATE_EARNED';
5058: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
5059: l_inputs(3).name := 'BUSINESS_GROUP_ID';
5060: l_inputs(3).value := p_business_group_id;
5061: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
5062: l_inputs(4).value := p_assignment_action_id;

Line 5066: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

5062: l_inputs(4).value := p_assignment_action_id;
5063: l_inputs(5).name := 'PAYROLL_ACTION_ID';
5064: l_inputs(5).value := l_payroll_action_id;
5065: l_inputs(6).name := 'BALANCE_DATE';
5066: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
5067: --
5068: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
5069: --
5070: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,