APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/

590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');
591:
592: /*End of PAY_US_ASG_REPORTING Section*/
593:
594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/
595:
596: INSERT INTO pay_us_geo_update
597: (id,
598: assignment_id,

Line 612: ,'PAY_ELEMENT_ENTRY_VALUES_F'

608: SELECT DISTINCT p_id
609: ,p_assignment_id
610: ,l_person_id
611: ,peev.element_entry_value_id
612: ,'PAY_ELEMENT_ENTRY_VALUES_F'
613: ,peev.screen_entry_value
614: ,replace(peev.screen_entry_value,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
615: ,pumg.process_type
616: ,p_date

Line 620: pay_element_entry_values_f peev,

616: ,p_date
617: ,p_mode
618: ,substr(pumg.city_name,8,6)
619: FROM pay_element_entries_f pee,
620: pay_element_entry_values_f peev,
621: pay_input_values_f piv,
622: pay_element_type_rules petr,
623: pay_us_modified_geocodes pumg
624: WHERE pee.assignment_id = p_assignment_id

Line 643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');

639: pumg.county_code,
640: pumg.old_city_code,
641: pumg.city_name)='Y';
642:
643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');
644:
645: /*End of PAY_ELEMENT_ENTRY_VALUES_F Section*/
646:
647: /* For tables PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES, first

Line 645: /*End of PAY_ELEMENT_ENTRY_VALUES_F Section*/

641: pumg.city_name)='Y';
642:
643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');
644:
645: /*End of PAY_ELEMENT_ENTRY_VALUES_F Section*/
646:
647: /* For tables PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES, first
648: assignment_action_id will be queried and using that we will look into these
649: tables */

Line 1019: 'PAY_ELEMENT_ENTRY_VALUES_F',3,

1015: pugu.new_juri_code,
1016: decode(pugu.table_name,
1017: 'PAY_US_ASG_REPORTING',1,
1018: 'PAY_ACTION_INFORMATION',2,
1019: 'PAY_ELEMENT_ENTRY_VALUES_F',3,
1020: 'PAY_RUN_RESULTS',4,
1021: 'PAY_RUN_RESULT_VALUES',5,
1022: 'FF_ARCHVIE_ITEM_CONTEXTS', 6) table_order -- Added for bug 14213838.
1023: FROM pay_us_geo_update pugu

Line 1068: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

1064: SET jurisdiction_code= l_new_jurisdiction_code
1065: WHERE assignment_id = p_assignment_id
1066: AND jurisdiction_code = l_old_jurisdiction_code;
1067:
1068: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
1069:
1070: UPDATE pay_element_entry_values_f
1071: SET screen_entry_value = l_new_jurisdiction_code
1072: WHERE element_entry_value_id = l_table_value_id

Line 1070: UPDATE pay_element_entry_values_f

1066: AND jurisdiction_code = l_old_jurisdiction_code;
1067:
1068: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
1069:
1070: UPDATE pay_element_entry_values_f
1071: SET screen_entry_value = l_new_jurisdiction_code
1072: WHERE element_entry_value_id = l_table_value_id
1073: AND screen_entry_value = l_old_jurisdiction_code;
1074:

Line 2190: l_pay_element_entry_values_f VARCHAR2(10);

2186: l_print_emp_assignment_id NUMBER;
2187: l_print_old_juri_code VARCHAR2(16);
2188: l_print_new_juri_code VARCHAR2(16);
2189: l_pay_us_asg_reporting VARCHAR2(10);
2190: l_pay_element_entry_values_f VARCHAR2(10);
2191: l_pay_run_results VARCHAR2(10);
2192: l_pay_run_result_values VARCHAR2(10);
2193: l_pay_action_information VARCHAR2(10);
2194: l_total_assignments NUMBER;

Line 2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');

2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

Line 2300: l_pay_element_entry_values_f := 'No';

2296: l_print_emp_assignment_id := l_emp_assignment_id;
2297: l_print_old_juri_code := l_old_jurisdiction_code;
2298: l_print_new_juri_code := l_new_jurisdiction_code;
2299: l_pay_us_asg_reporting := 'No';
2300: l_pay_element_entry_values_f := 'No';
2301: l_pay_run_results := 'No';
2302: l_pay_run_result_values := 'No';
2303: l_pay_action_information := 'No';
2304: l_ff_archive_item_contexts := 'No'; -- Added for bug 14213838.

Line 2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

2314: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2315:
2316: l_pay_us_asg_reporting := 'Yes';
2317:
2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2319:
2320: l_pay_element_entry_values_f := 'Yes';
2321:
2322: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN

Line 2320: l_pay_element_entry_values_f := 'Yes';

2316: l_pay_us_asg_reporting := 'Yes';
2317:
2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2319:
2320: l_pay_element_entry_values_f := 'Yes';
2321:
2322: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2323:
2324: l_pay_run_results := 'Yes';

Line 2346: fnd_file.put_line(fnd_file.output,'

2342:
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'

Line 2354: l_pay_element_entry_values_f := 'No';

2350: l_print_emp_assignment_id := l_emp_assignment_id;
2351: l_print_old_juri_code := l_old_jurisdiction_code;
2352: l_print_new_juri_code := l_new_jurisdiction_code;
2353: l_pay_us_asg_reporting := 'No';
2354: l_pay_element_entry_values_f := 'No';
2355: l_pay_run_results := 'No';
2356: l_pay_run_result_values := 'No';
2357: l_pay_action_information := 'No';
2358: l_ff_archive_item_contexts :='No'; -- Added for bug 14213838.

Line 2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

2360: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2361:
2362: l_pay_us_asg_reporting := 'Yes';
2363:
2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2365:
2366: l_pay_element_entry_values_f := 'Yes';
2367:
2368: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN

Line 2366: l_pay_element_entry_values_f := 'Yes';

2362: l_pay_us_asg_reporting := 'Yes';
2363:
2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2365:
2366: l_pay_element_entry_values_f := 'Yes';
2367:
2368: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2369:
2370: l_pay_run_results := 'Yes';

Line 2397: fnd_file.put_line(fnd_file.output,'

2393:
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'