APPS.PAY_NL_TAX_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 17: per_assignment_extra_info TARGET

13:
14: CURSOR csr_extra_info(c_flex_context IN VARCHAR2) is
15: Select TARGET.*
16: From
17: per_assignment_extra_info TARGET
18: ,pay_assignment_actions PAA
19: ,pay_payroll_actions PACT
20: ,per_time_periods TPERIOD
21: where PAA.assignment_action_id = p_assignment_action_id

Line 34: per_assignment_extra_info TARGET

30: /*
31: CURSOR csr_extra_info_Sm_job(c_flex_context IN VARCHAR2) is
32: Select TARGET.*
33: From
34: per_assignment_extra_info TARGET
35: ,pay_assignment_actions PAA
36: ,pay_payroll_actions PACT
37: ,per_time_periods TPERIOD
38: where PAA.assignment_action_id = p_assignment_action_id

Line 51: FROM per_assignment_extra_info

47: */
48:
49: /*
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'));

Line 955: per_assignment_extra_info paei

951:
952: CURSOR Cur_ttd_details IS
953: SELECT paei.AEI_INFORMATION3 Discount_Type
954: FROM
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)