APPS.PAY_NL_TAX_PKG dependencies on FND_DATE

Line 27: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)

23: AND target.assignment_id = PAA.assignment_id
24: AND PAA.payroll_action_id = PACT.payroll_action_id
25: AND PACT.payroll_id = TPERIOD.payroll_id
26: AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
27: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
28: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date);
29:
30: /*
31: CURSOR csr_extra_info_Sm_job(c_flex_context IN VARCHAR2) is

Line 28: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date);

24: AND PAA.payroll_action_id = PACT.payroll_action_id
25: AND PACT.payroll_id = TPERIOD.payroll_id
26: AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
27: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
28: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date);
29:
30: /*
31: CURSOR csr_extra_info_Sm_job(c_flex_context IN VARCHAR2) is
32: Select TARGET.*

Line 44: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)

40: AND target.assignment_id = PAA.assignment_id
41: AND PAA.payroll_action_id = PACT.payroll_action_id
42: AND PACT.payroll_id = TPERIOD.payroll_id
43: AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
44: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
45: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date)
46: AND to_char(TARGET.aei_information3) = 'F';
47: */
48:

Line 45: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date)

41: AND PAA.payroll_action_id = PACT.payroll_action_id
42: AND PACT.payroll_id = TPERIOD.payroll_id
43: AND PACT.date_earned between TPERIOD.start_date and TPERIOD.end_date
44: AND TPERIOD.end_date >= FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION1)
45: AND TPERIOD.start_date <= nvl(FND_DATE.CANONICAL_TO_DATE(target.AEI_INFORMATION2), TPERIOD.start_date)
46: AND to_char(TARGET.aei_information3) = 'F';
47: */
48:
49: /*

Line 54: --AND p_date_earned between fnd_date.canonical_to_date(aei_information1)

50: SELECT *
51: FROM per_assignment_extra_info
52: WHERE assignment_id = p_assignment_id
53: AND aei_information_category = c_flex_context;
54: --AND p_date_earned between fnd_date.canonical_to_date(aei_information1)
55: --and nvl(fnd_date.canonical_to_date(aei_information2),to_Date('31/12/4712','dd/mm/yyyy'));
56: */
57:
58: l_extra_info csr_extra_info%ROWTYPE;

Line 55: --and nvl(fnd_date.canonical_to_date(aei_information2),to_Date('31/12/4712','dd/mm/yyyy'));

51: FROM per_assignment_extra_info
52: WHERE assignment_id = p_assignment_id
53: AND aei_information_category = c_flex_context;
54: --AND p_date_earned between fnd_date.canonical_to_date(aei_information1)
55: --and nvl(fnd_date.canonical_to_date(aei_information2),to_Date('31/12/4712','dd/mm/yyyy'));
56: */
57:
58: l_extra_info csr_extra_info%ROWTYPE;
59: l_marginal_flag varchar2(1):='N';

Line 959: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)

955: per_assignment_extra_info paei
956: WHERE
957: paei.assignment_id = p_assignment_id
958: AND p_date_earned between
959: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
960: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
961: and paei.INFORMATION_TYPE = 'NL_TTD';
962:
963: l_discount_type NUMBER :=-1;

Line 960: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)

956: WHERE
957: paei.assignment_id = p_assignment_id
958: AND p_date_earned between
959: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
960: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
961: and paei.INFORMATION_TYPE = 'NL_TTD';
962:
963: l_discount_type NUMBER :=-1;
964: l_proc varchar2(100) := g_package||'get_temporary_tax_discount';