APPS.PAY_DK_TC_DP_UPLOAD dependencies on PAY_INPUT_VALUES_F

Line 445: from pay_input_values_f_tl tl, pay_input_values_f t

441: /* Fix for Flugger - starts */
442:
443: select tl.name
444: into l_input_value_name1
445: from pay_input_values_f_tl tl, pay_input_values_f t
446: where t.input_value_id = tl.input_value_id
447: and t.legislation_code ='DK'
448: and t.name = l_input_value_name1
449: and tl.language ='US';

Line 455: from pay_input_values_f_tl tl, pay_input_values_f t

451: --fnd_file.put_line(fnd_file.LOG,'Debug14_1');
452:
453: select tl.name
454: into l_input_value_name2
455: from pay_input_values_f_tl tl, pay_input_values_f t
456: where t.input_value_id = tl.input_value_id
457: and t.legislation_code ='DK'
458: and t.name = l_input_value_name2
459: and tl.language ='US';

Line 465: from pay_input_values_f_tl tl, pay_input_values_f t

461: --fnd_file.put_line(fnd_file.LOG,'Debug14_2');
462:
463: select tl.name
464: into l_input_value_name3
465: from pay_input_values_f_tl tl, pay_input_values_f t
466: where t.input_value_id = tl.input_value_id
467: and t.legislation_code ='DK'
468: and t.name = l_input_value_name3
469: and tl.language ='US';

Line 474: from pay_input_values_f_tl tl, pay_input_values_f t

470:
471: --fnd_file.put_line(fnd_file.LOG,'Debug14_3');
472: select tl.name
473: into l_input_value_name4
474: from pay_input_values_f_tl tl, pay_input_values_f t
475: where t.input_value_id = tl.input_value_id
476: and t.legislation_code ='DK'
477: and t.name = l_input_value_name4
478: and tl.language ='US';

Line 483: from pay_input_values_f_tl tl, pay_input_values_f t

479:
480: --fnd_file.put_line(fnd_file.LOG,'Debug14_4');
481: select tl.name
482: into l_input_value_name5
483: from pay_input_values_f_tl tl, pay_input_values_f t
484: where t.input_value_id = tl.input_value_id
485: and t.legislation_code ='DK'
486: and t.name = l_input_value_name5
487: and tl.language ='US';

Line 492: from pay_input_values_f_tl tl, pay_input_values_f t

488:
489: --fnd_file.put_line(fnd_file.LOG,'Debug14_5');
490: select tl.name
491: into l_input_value_name6
492: from pay_input_values_f_tl tl, pay_input_values_f t
493: where t.input_value_id = tl.input_value_id
494: and t.legislation_code ='DK'
495: and t.name = l_input_value_name6
496: and tl.language ='US';

Line 501: from pay_input_values_f_tl tl, pay_input_values_f t

497:
498: --fnd_file.put_line(fnd_file.LOG,'Debug14_6');
499: select tl.name
500: into l_input_value_name7
501: from pay_input_values_f_tl tl, pay_input_values_f t
502: where t.input_value_id = tl.input_value_id
503: and t.legislation_code ='DK'
504: and t.name = l_input_value_name7
505: and tl.language ='US';

Line 509: from pay_input_values_f_tl tl, pay_input_values_f t

505: and tl.language ='US';
506:
507: select tl.name
508: into l_input_value_name8
509: from pay_input_values_f_tl tl, pay_input_values_f t
510: where t.input_value_id = tl.input_value_id
511: and t.legislation_code ='DK'
512: and t.name = l_input_value_name8
513: and tl.language ='US';