APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_ENTRY_PROCESS_DETAILS

Line 450: l_run_result_id pay_entry_process_details.run_result_id%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;
451: l_src_entry_id pay_entry_process_details.source_entry_id%type;
452: l_ppath pay_entry_process_details.process_path%type;
453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;
454: l_src_et_id pay_entry_process_details.source_element_type_id%type;

Line 451: l_src_entry_id pay_entry_process_details.source_entry_id%type;

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;
451: l_src_entry_id pay_entry_process_details.source_entry_id%type;
452: l_ppath pay_entry_process_details.process_path%type;
453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;
454: l_src_et_id pay_entry_process_details.source_element_type_id%type;
455: l_dummy varchar2(2);

Line 452: l_ppath pay_entry_process_details.process_path%type;

448: and pee.assignment_id = p_asg_id;
449: --
450: l_run_result_id pay_entry_process_details.run_result_id%type;
451: l_src_entry_id pay_entry_process_details.source_entry_id%type;
452: l_ppath pay_entry_process_details.process_path%type;
453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;
454: l_src_et_id pay_entry_process_details.source_element_type_id%type;
455: l_dummy varchar2(2);
456: l_loc_aa_id number;

Line 453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;

449: --
450: l_run_result_id pay_entry_process_details.run_result_id%type;
451: l_src_entry_id pay_entry_process_details.source_entry_id%type;
452: l_ppath pay_entry_process_details.process_path%type;
453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;
454: l_src_et_id pay_entry_process_details.source_element_type_id%type;
455: l_dummy varchar2(2);
456: l_loc_aa_id number;
457: l_loc_src_aa_id number;

Line 454: l_src_et_id pay_entry_process_details.source_element_type_id%type;

450: l_run_result_id pay_entry_process_details.run_result_id%type;
451: l_src_entry_id pay_entry_process_details.source_entry_id%type;
452: l_ppath pay_entry_process_details.process_path%type;
453: l_src_asg_act_id pay_entry_process_details.source_asg_action_id%type;
454: l_src_et_id pay_entry_process_details.source_element_type_id%type;
455: l_dummy varchar2(2);
456: l_loc_aa_id number;
457: l_loc_src_aa_id number;
458: l_upgrade boolean;

Line 467: from pay_entry_process_details

463: begin
464: --
465: select ''
466: into l_dummy
467: from pay_entry_process_details
468: where element_entry_id = eerec.element_entry_id;
469: --
470: l_src_asg_act_id := eerec.source_asg_action_id;
471: --

Line 613: update pay_entry_process_details

609: end;
610: end if;
611: --
612: --
613: update pay_entry_process_details
614: set run_result_id = l_run_result_id,
615: source_entry_id = l_src_entry_id,
616: process_path = l_ppath,
617: source_asg_action_id = l_src_asg_act_id,

Line 769: insert into pay_entry_process_details

765: l_ppath := '.';
766: end;
767: end if;
768: --
769: insert into pay_entry_process_details
770: (element_entry_id,
771: run_result_id,
772: source_entry_id,
773: process_path,

Line 1371: pay_entry_process_details pepd,

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,
1375: pay_element_types_f pet

Line 1542: update pay_entry_process_details

1538: --
1539: if (l_std_time_def_id is not null) then
1540: --
1541: forall i in 1..l_ee_tab.COUNT
1542: update pay_entry_process_details
1543: set time_definition_id = l_td_tab(i)
1544: where element_entry_id = l_ee_tab(i);
1545: --
1546: end if;