[Home] [Help]
442: pee.creator_type,
443: pee.source_id,
444: pee.source_asg_action_id,
445: pee.source_run_type
446: from pay_element_entries_f pee
447: where pee.creator_type in ('RR', 'EE')
448: and pee.assignment_id = p_asg_id;
449: --
450: l_run_result_id pay_entry_process_details.run_result_id%type;
508: where assignment_action_id = l_loc_src_aa_id;
509: end loop;
510: l_src_asg_act_id := l_loc_aa_id;
511: end if;
512: update pay_element_entries_f
513: set source_asg_action_id = l_src_asg_act_id
514: where element_entry_id = eerec.element_entry_id;
515: end if;
516: else
527: select distinct pet.element_type_id
528: into l_src_et_id
529: from pay_element_types_f pet,
530: pay_element_links_f pel,
531: pay_element_entries_f pee
532: where pee.element_entry_id = l_src_entry_id
533: and pee.element_link_id = pel.element_link_id
534: and pel.element_type_id = pet.element_type_id;
535: --
662: where assignment_action_id = l_loc_src_aa_id;
663: end loop;
664: l_src_asg_act_id := l_loc_aa_id;
665: end if;
666: update pay_element_entries_f
667: set source_asg_action_id = l_src_asg_act_id
668: where element_entry_id = eerec.element_entry_id;
669: end if;
670: --
682: select distinct pet.element_type_id
683: into l_src_et_id
684: from pay_element_types_f pet,
685: pay_element_links_f pel,
686: pay_element_entries_f pee
687: where pee.element_entry_id = l_src_entry_id
688: and pee.element_link_id = pel.element_link_id
689: and pel.element_type_id = pet.element_type_id;
690: --
884: is
885: SELECT /*+ ORDERED
886: USE_NL (ASGT_ACTION, EE, ET)
887: INDEX(
888: EE PAY_ELEMENT_ENTRIES_F_N50,
889: ET PAY_ELEMENT_TYPES_F_PK)
890: */
891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
890: */
891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
893: pay_payroll_actions PAY_ACTION,
894: pay_element_entries_f EE,
895: pay_element_types_f ET
896: WHERE ASGT_ACTION.assignment_id = p_asg_id
897: AND ASGT_ACTION.payroll_action_id = PAY_ACTION.payroll_action_id
898: AND PAY_ACTION.action_type = 'Q'
1337: */
1338: procedure upg_timedef_baldate (p_asg_id in number)
1339: is
1340: --
1341: type t_ee_id is table of pay_element_entries_f.element_entry_id%type
1342: index by binary_integer;
1343: type t_rr_id is table of pay_run_results.run_result_id%type
1344: index by binary_integer;
1345: type t_td_id is table of pay_time_definitions.time_definition_id%type
1366: 'S', pet.time_definition_id,
1367: 'G', p_std_time_def_id,
1368: null)
1369: ) time_definition_id
1370: from pay_element_entries_f pee,
1371: pay_entry_process_details pepd,
1372: pay_assignment_actions paa,
1373: pay_payroll_actions ppa,
1374: per_time_periods ptp,
1473:
1474: forall i in 1..l_rr_tab.COUNT
1475: update pay_run_results prr
1476: set prr.start_date = (select pee.date_earned
1477: from pay_element_entries_f pee
1478: where pee.element_entry_id = prr.source_id
1479: ),
1480: prr.end_date = (select pee.date_earned
1481: from pay_element_entries_f pee
1477: from pay_element_entries_f pee
1478: where pee.element_entry_id = prr.source_id
1479: ),
1480: prr.end_date = (select pee.date_earned
1481: from pay_element_entries_f pee
1482: where pee.element_entry_id = prr.source_id
1483: )
1484: where prr.run_result_id = l_rr_tab(i)
1485: and exists (select ''
1482: where pee.element_entry_id = prr.source_id
1483: )
1484: where prr.run_result_id = l_rr_tab(i)
1485: and exists (select ''
1486: from pay_element_entries_f pee
1487: where pee.element_entry_id = prr.source_id
1488: and pee.date_earned is not null)
1489: and prr.start_date is null
1490: and l_action(i) <> 'V';
1527: l_end_tab,
1528: l_td_tab limit 100;
1529: --
1530: forall i in 1..l_ee_tab.COUNT
1531: update pay_element_entries_f
1532: set source_start_date = l_std_tab(i),
1533: source_end_date = l_end_tab(i)
1534: where element_entry_id = l_ee_tab(i);
1535: --