APPS.PAY_GENERIC_UPGRADE dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 562: l_action_id pay_temp_object_actions.object_action_id%type;

558: p_pactid in number,
559: p_chunk in number
560: )
561: is
562: l_action_id pay_temp_object_actions.object_action_id%type;
563: l_qualified boolean;
564: begin
565:
566: --

Line 951: object_id pay_temp_object_actions.object_id%type;

947: upgrade_proc pay_upgrade_definitions.upgrade_procedure%TYPE;
948: statem varchar2(256);
949: l_upg_def_id pay_upgrade_definitions.upgrade_definition_id%type;
950: l_upg_def_nm pay_upgrade_definitions.short_name%type;
951: object_id pay_temp_object_actions.object_id%type;
952: --
953: begin
954: --
955: select pay_core_utils.get_parameter('UPG_DEF_NAME',

Line 961: pay_temp_object_actions ptoa

957: ptoa.object_id
958: into l_upg_def_nm,
959: object_id
960: from pay_payroll_actions ppa,
961: pay_temp_object_actions ptoa
962: where ppa.payroll_action_id = ptoa.payroll_action_id
963: and ptoa.object_action_id = p_assactid;
964: --
965: select upgrade_procedure,

Line 1029: from pay_temp_object_actions

1025: if l_report_type='GENERIC_REPORT'
1026: then
1027: select count(*)
1028: into cnt_incomplete_actions
1029: from pay_temp_object_actions
1030: where payroll_action_id = pactid
1031: and action_status <> 'C';
1032:
1033: if (l_remove_act is null or l_remove_act = 'Y') then

Line 1036: FROM pay_temp_object_actions ptoa

1032:
1033: if (l_remove_act is null or l_remove_act = 'Y') then
1034: DELETE FROM pay_file_details pfd
1035: WHERE EXISTS (SELECT 1
1036: FROM pay_temp_object_actions ptoa
1037: WHERE ptoa.object_action_id = pfd.source_id
1038: AND pfd.source_type = 'PAA') OR
1039: (pfd.source_id = pactid
1040: AND pfd.source_type = 'PPA') ;

Line 1053: from pay_temp_object_actions

1049: where short_name = l_upg_def_nm;
1050: --
1051: select count(*)
1052: into cnt_incomplete_actions
1053: from pay_temp_object_actions
1054: where payroll_action_id = pactid
1055: and action_status <> 'C';
1056: --
1057: --