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 2178: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)

2174: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2175: AND information_type = 'NL_ABP_PAR_INFO'
2176: AND assignment_id = p_assignment_id
2177: AND aei_information10 IS NOT NULL
2178: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2179: AND fnd_date.canonical_to_date(nvl(aei_information2
2180: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2181:
2182: -- =======================================================================

Line 2179: AND fnd_date.canonical_to_date(nvl(aei_information2

2175: AND information_type = 'NL_ABP_PAR_INFO'
2176: AND assignment_id = p_assignment_id
2177: AND aei_information10 IS NOT NULL
2178: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2179: AND fnd_date.canonical_to_date(nvl(aei_information2
2180: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2181:
2182: -- =======================================================================
2183: -- Cursor to get the choice for average PTP calculation from ORG EIT

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

2176: AND assignment_id = p_assignment_id
2177: AND aei_information10 IS NOT NULL
2178: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2179: AND fnd_date.canonical_to_date(nvl(aei_information2
2180: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2181:
2182: -- =======================================================================
2183: -- Cursor to get the choice for average PTP calculation from ORG EIT
2184: -- =======================================================================

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

2198: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2199: AND information_type = 'NL_ABP_PAR_INFO'
2200: AND assignment_id = p_assignment_id
2201: AND aei_information11 IS NOT NULL
2202: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2203: AND fnd_date.canonical_to_date(nvl(aei_information2
2204: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2205:
2206: -- =======================================================================

Line 2203: AND fnd_date.canonical_to_date(nvl(aei_information2

2199: AND information_type = 'NL_ABP_PAR_INFO'
2200: AND assignment_id = p_assignment_id
2201: AND aei_information11 IS NOT NULL
2202: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2203: AND fnd_date.canonical_to_date(nvl(aei_information2
2204: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2205:
2206: -- =======================================================================
2207: -- Cursor to get the choice for OHT from ORG EIT

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

2200: AND assignment_id = p_assignment_id
2201: AND aei_information11 IS NOT NULL
2202: AND c_eff_date BETWEEN fnd_date.canonical_to_date(aei_information1)
2203: AND fnd_date.canonical_to_date(nvl(aei_information2
2204: ,fnd_date.date_to_canonical(hr_api.g_eot)));
2205:
2206: -- =======================================================================
2207: -- Cursor to get the choice for OHT from ORG EIT
2208: -- =======================================================================

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

3401: select 1 from dual
3402: where exists (select 1 from hr_organization_information
3403: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3404: AND organization_id = c_org_id
3405: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3406: and fnd_date.canonical_to_date(nvl(org_information5,
3407: fnd_date.date_to_canonical(hr_api.g_eot)))
3408: );
3409:

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

3402: where exists (select 1 from hr_organization_information
3403: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3404: AND organization_id = c_org_id
3405: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3406: and fnd_date.canonical_to_date(nvl(org_information5,
3407: fnd_date.date_to_canonical(hr_api.g_eot)))
3408: );
3409:
3410: --Cursor to find the parent id from the org id

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

3403: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3404: AND organization_id = c_org_id
3405: AND p_date_earned between fnd_date.canonical_to_date(org_information4)
3406: and fnd_date.canonical_to_date(nvl(org_information5,
3407: fnd_date.date_to_canonical(hr_api.g_eot)))
3408: );
3409:
3410: --Cursor to find the parent id from the org id
3411: CURSOR c_find_parent_id(c_org_id in number

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

3426: AND hoi.organization_id = c_org_id
3427: AND pty.pension_type_id = p_pension_type_id
3428: AND p_date_earned between pty.effective_start_date
3429: and pty.effective_end_date
3430: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3431: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3432: fnd_date.date_to_canonical(hr_api.g_eot))
3433: );
3434: --Cursor to find the pension type name from the pension type id

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

3427: AND pty.pension_type_id = p_pension_type_id
3428: AND p_date_earned between pty.effective_start_date
3429: and pty.effective_end_date
3430: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3431: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3432: fnd_date.date_to_canonical(hr_api.g_eot))
3433: );
3434: --Cursor to find the pension type name from the pension type id
3435: CURSOR c_find_pen_type_name Is

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

3428: AND p_date_earned between pty.effective_start_date
3429: and pty.effective_end_date
3430: AND p_date_earned between fnd_date.canonical_to_date(hoi.org_information4)
3431: and fnd_date.canonical_to_date(nvl(hoi.org_information5,
3432: fnd_date.date_to_canonical(hr_api.g_eot))
3433: );
3434: --Cursor to find the pension type name from the pension type id
3435: CURSOR c_find_pen_type_name Is
3436: SELECT pension_type_name

Line 4841: 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'))))

4837: FROM per_assignment_extra_info
4838: WHERE assignment_id = p_assignment_id
4839: AND aei_information1 = to_char(p_pension_type_id)
4840: AND aei_information2 = to_char(p_payroll_period_number)
4841: 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'))))
4842: AND fnd_date.canonical_to_date(nvl(aei_information5,fnd_date.date_to_canonical(to_date('31-12-4712','dd-mm-yyyy'))))
4843: AND aei_information_category = 'NL_SAV_INFO'
4844: AND information_type = 'NL_SAV_INFO';
4845:

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

4838: WHERE assignment_id = p_assignment_id
4839: AND aei_information1 = to_char(p_pension_type_id)
4840: AND aei_information2 = to_char(p_payroll_period_number)
4841: 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'))))
4842: AND fnd_date.canonical_to_date(nvl(aei_information5,fnd_date.date_to_canonical(to_date('31-12-4712','dd-mm-yyyy'))))
4843: AND aei_information_category = 'NL_SAV_INFO'
4844: AND information_type = 'NL_SAV_INFO';
4845:
4846: l_ret_val NUMBER;

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

5064: --
5065: l_inputs(1).name := 'ASSIGNMENT_ID';
5066: l_inputs(1).value := p_assignment_id;
5067: l_inputs(2).name := 'DATE_EARNED';
5068: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
5069: l_inputs(3).name := 'BUSINESS_GROUP_ID';
5070: l_inputs(3).value := p_business_group_id;
5071: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
5072: l_inputs(4).value := p_assignment_action_id;

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

5072: l_inputs(4).value := p_assignment_action_id;
5073: l_inputs(5).name := 'PAYROLL_ACTION_ID';
5074: l_inputs(5).value := l_payroll_action_id;
5075: l_inputs(6).name := 'BALANCE_DATE';
5076: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
5077: --
5078: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
5079: --
5080: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,

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

5151: --
5152: l_inputs(1).name := 'ASSIGNMENT_ID';
5153: l_inputs(1).value := p_assignment_id;
5154: l_inputs(2).name := 'DATE_EARNED';
5155: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
5156: l_inputs(3).name := 'BUSINESS_GROUP_ID';
5157: l_inputs(3).value := p_business_group_id;
5158: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
5159: l_inputs(4).value := p_assignment_action_id;

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

5159: l_inputs(4).value := p_assignment_action_id;
5160: l_inputs(5).name := 'PAYROLL_ACTION_ID';
5161: l_inputs(5).value := l_payroll_action_id;
5162: l_inputs(6).name := 'BALANCE_DATE';
5163: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
5164: --
5165: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
5166: --
5167: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,