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_US_PSD_UPGRADE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 647: /* For tables PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES, first

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 */
650:
651: OPEN get_assignment_actions(p_assignment_id);

Line 707: /Start of PAY_RUN_RESULT_VALUES Section/

703: /*End of PAY_RUN_RESULTS Section*/
704:
705: IF SQL%ROWCOUNT > 0 THEN
706:
707: /*Start of PAY_RUN_RESULT_VALUES Section*/
708:
709: INSERT INTO pay_us_geo_update
710: (id,
711: assignment_id,

Line 725: ,'PAY_RUN_RESULT_VALUES'

721: SELECT DISTINCT p_id
722: ,p_assignment_id
723: ,l_person_id
724: ,prr.run_result_id
725: ,'PAY_RUN_RESULT_VALUES'
726: ,prv.result_value
727: ,replace(prv.result_value,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
728: ,pumg.process_type
729: ,p_date

Line 733: pay_run_result_values prv,

729: ,p_date
730: ,p_mode
731: ,substr(pumg.city_name,8,6)
732: FROM pay_run_results prr,
733: pay_run_result_values prv,
734: pay_us_modified_geocodes pumg,
735: pay_element_types_f pet,
736: pay_input_values_f piv,
737: pay_element_type_rules petr

Line 757: /End of PAY_RUN_RESULT_VALUES Section/

753: pumg.county_code,
754: pumg.old_city_code,
755: pumg.city_name)='Y';
756:
757: /*End of PAY_RUN_RESULT_VALUES Section*/
758:
759: END IF; /*SQL%ROWCOUNT IF*/
760:
761: END LOOP; /*Assignment Action ID Loop*/

Line 767: hr_utility.trace('Done with PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES');

763: END IF;
764:
765: CLOSE get_assignment_actions;
766:
767: hr_utility.trace('Done with PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES');
768:
769: /*Start of PAY_ACTION_INFORMATION Section*/
770:
771: OPEN get_archive_asg_actions(p_assignment_id);

Line 1021: 'PAY_RUN_RESULT_VALUES',5,

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
1024: WHERE pugu.id = p_id
1025: AND pugu.process_type = 'PA'

Line 1082: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN

1078: SET jurisdiction_code = l_new_jurisdiction_code
1079: WHERE run_result_id = l_table_value_id
1080: AND jurisdiction_code = l_old_jurisdiction_code;
1081:
1082: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
1083:
1084: UPDATE pay_run_result_values
1085: SET result_value = l_new_jurisdiction_code
1086: WHERE run_result_id = l_table_value_id

Line 1084: UPDATE pay_run_result_values

1080: AND jurisdiction_code = l_old_jurisdiction_code;
1081:
1082: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
1083:
1084: UPDATE pay_run_result_values
1085: SET result_value = l_new_jurisdiction_code
1086: WHERE run_result_id = l_table_value_id
1087: AND result_value = l_old_jurisdiction_code;
1088:

Line 2192: l_pay_run_result_values VARCHAR2(10);

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;
2195: l_success_assignments NUMBER;
2196: l_error_assignments NUMBER;

Line 2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');

2269: fnd_file.put_line(fnd_file.output,'Table NameAbbrevation');
2270: fnd_file.put_line(fnd_file.output,'PAY_US_ASG_REPORTINGPUAR');
2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');
2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:

Line 2302: l_pay_run_result_values := 'No';

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.
2305:
2306: WHILE (get_emp_update_details%FOUND)

Line 2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN

2322: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2323:
2324: l_pay_run_results := 'Yes';
2325:
2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2327:
2328: l_pay_run_result_values := 'Yes';
2329:
2330: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN

Line 2328: l_pay_run_result_values := 'Yes';

2324: l_pay_run_results := 'Yes';
2325:
2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2327:
2328: l_pay_run_result_values := 'Yes';
2329:
2330: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
2331:
2332: l_pay_action_information := 'Yes';

Line 2346: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');

2342:
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,''||l_print_full_name||''||l_print_emp_assignment_id||''||l_print_old_juri_code||''||l_print_new_juri_code||'');
2346: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');
2347: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');
2348:
2349: l_print_full_name := l_full_name;
2350: l_print_emp_assignment_id := l_emp_assignment_id;

Line 2356: l_pay_run_result_values := 'No';

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.
2359:
2360: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN

Line 2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN

2368: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2369:
2370: l_pay_run_results := 'Yes';
2371:
2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2373:
2374: l_pay_run_result_values := 'Yes';
2375:
2376: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN

Line 2374: l_pay_run_result_values := 'Yes';

2370: l_pay_run_results := 'Yes';
2371:
2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2373:
2374: l_pay_run_result_values := 'Yes';
2375:
2376: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
2377:
2378: l_pay_action_information := 'Yes';

Line 2397: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');

2393:
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,''||l_print_full_name||''||l_print_emp_assignment_id||''||l_print_old_juri_code||''||l_print_new_juri_code||'');
2397: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');
2398: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');
2399: END IF;
2400:
2401: END LOOP;