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_JP_ITWB_REPORT_PKG dependencies on FND_DATE

Line 1322: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_FROM',l_csr_action.legislative_parameters));

1318: g_location_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('LOCATION_ID',l_csr_action.legislative_parameters));
1319: g_inc_org_hier_flag := pay_core_utils.get_parameter('INC_ORG_HIERARCHY',l_csr_action.legislative_parameters);
1320: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('HR_ORGANIZATION_ID',l_csr_action.legislative_parameters));
1321: g_inc_term_flag := pay_core_utils.get_parameter('INC_TERM',l_csr_action.legislative_parameters);
1322: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_FROM',l_csr_action.legislative_parameters));
1323: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_TO',l_csr_action.legislative_parameters));
1324: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1325: g_sort_order1 := pay_core_utils.get_parameter('SORT_ORDER1',l_csr_action.legislative_parameters);
1326: g_sort_order2 := pay_core_utils.get_parameter('SORT_ORDER2',l_csr_action.legislative_parameters);

Line 1323: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_TO',l_csr_action.legislative_parameters));

1319: g_inc_org_hier_flag := pay_core_utils.get_parameter('INC_ORG_HIERARCHY',l_csr_action.legislative_parameters);
1320: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('HR_ORGANIZATION_ID',l_csr_action.legislative_parameters));
1321: g_inc_term_flag := pay_core_utils.get_parameter('INC_TERM',l_csr_action.legislative_parameters);
1322: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_FROM',l_csr_action.legislative_parameters));
1323: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERM_DATE_TO',l_csr_action.legislative_parameters));
1324: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1325: g_sort_order1 := pay_core_utils.get_parameter('SORT_ORDER1',l_csr_action.legislative_parameters);
1326: g_sort_order2 := pay_core_utils.get_parameter('SORT_ORDER2',l_csr_action.legislative_parameters);
1327: g_sort_order3 := pay_core_utils.get_parameter('SORT_ORDER3',l_csr_action.legislative_parameters);

Line 1461: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')

1457: where ppa.payroll_action_id = :payroll_action_id
1458: and pp.business_group_id = ppa.business_group_id + 0
1459: and ppos.person_id = pp.person_id
1460: and ppos.business_group_id + 0 = pp.business_group_id
1461: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
1462: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1463: order by
1464: ppos.person_id';
1465: --

Line 1462: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')

1458: and pp.business_group_id = ppa.business_group_id + 0
1459: and ppos.person_id = pp.person_id
1460: and ppos.business_group_id + 0 = pp.business_group_id
1461: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
1462: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1463: order by
1464: ppos.person_id';
1465: --
1466: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

Line 1466: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

1462: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1463: order by
1464: ppos.person_id';
1465: --
1466: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
1467: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
1468: --
1469: if g_debug then
1470: hr_utility.set_location(l_proc,1000);

Line 1467: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

1463: order by
1464: ppos.person_id';
1465: --
1466: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
1467: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
1468: --
1469: if g_debug then
1470: hr_utility.set_location(l_proc,1000);
1471: end if;

Line 3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);

3887: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_txt_info25 := l_csr_data_ass_cust.information25;
3888: --
3889: elsif l_csr_data_ass_cust.data_type = 'D' then
3890: --
3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);
3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);

Line 3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);

3888: --
3889: elsif l_csr_data_ass_cust.data_type = 'D' then
3890: --
3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);
3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);

Line 3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);

3889: elsif l_csr_data_ass_cust.data_type = 'D' then
3890: --
3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);
3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);

Line 3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);

3890: --
3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);
3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);

Line 3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);

3891: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info1 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information1);
3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);

Line 3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);

3892: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info2 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information2);
3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);

Line 3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);

3893: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info3 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information3);
3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);

Line 3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);

3894: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info4 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information4);
3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);

Line 3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);

3895: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info5 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information5);
3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);

Line 3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);

3896: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info6 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information6);
3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);

Line 3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);

3897: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info7 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information7);
3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);

Line 3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);

3898: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info8 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information8);
3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);

Line 3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);

3899: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info9 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information9);
3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);

Line 3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);

3900: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info10 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information10);
3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);

Line 3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);

3901: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info11 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information11);
3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);

Line 3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);

3902: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info12 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information12);
3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);

Line 3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);

3903: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info13 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information13);
3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);

Line 3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);

3904: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info14 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information14);
3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);

Line 3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);

3905: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info15 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information15);
3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);

Line 3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);

3906: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info16 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information16);
3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);

Line 3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);

3907: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info17 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information17);
3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);
3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);

Line 3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);

3908: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info18 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information18);
3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);
3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);
3916: --

Line 3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);

3909: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info19 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information19);
3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);
3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);
3916: --
3917: elsif l_csr_data_ass_cust.data_type = 'N' then

Line 3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);

3910: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info20 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information20);
3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);
3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);
3916: --
3917: elsif l_csr_data_ass_cust.data_type = 'N' then
3918: --

Line 3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);

3911: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info21 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information21);
3912: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info22 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information22);
3913: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info23 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information23);
3914: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info24 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information24);
3915: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_date_info25 := fnd_date.canonical_to_date(l_csr_data_ass_cust.information25);
3916: --
3917: elsif l_csr_data_ass_cust.data_type = 'N' then
3918: --
3919: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_cust_num_info1 := fnd_number.canonical_to_number(l_csr_data_ass_cust.information1);