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.PQP_GB_SWF_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 737: from pay_assignment_actions

733: l_ret boolean := true;
734:
735: cursor check_action_exists is
736: select assignment_action_id
737: from pay_assignment_actions
738: where payroll_action_id = p_pactid
739: and assignment_id = p_assignment_id;
740:
741: begin

Line 768: from pay_assignment_actions

764: l_ret boolean;
765:
766: cursor csr_check_action is
767: select min(assignment_action_id)
768: from pay_assignment_actions
769: where assignment_id in (select assignment_id
770: from per_all_assignments_f
771: where person_id = p_person_id)
772: and payroll_action_id = p_pactid;

Line 1009: l_ass_act_id pay_assignment_actions.assignment_action_id%type;

1005:
1006: -- Local variables
1007: l_arch boolean := true;
1008: l_proc constant varchar2(35):= g_package||'action_creation';
1009: l_ass_act_id pay_assignment_actions.assignment_action_id%type;
1010: l_asg_set hr_assignment_sets.assignment_set_id%type;
1011: l_effective_date date;
1012: e_contract_type_nt_defined exception;
1013: l_contract_type varchar2(50);

Line 1075: select pay_assignment_actions_s.nextval

1071: -- Check if assignment action already created for this assignment
1072: l_arch := check_action(pactid,asg_rec.assignment_id);
1073: if l_arch then
1074: -- hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
1075: select pay_assignment_actions_s.nextval
1076: into l_ass_act_id
1077: from dual;
1078: --
1079: -- insert into pay_assignment_actions.

Line 1079: -- insert into pay_assignment_actions.

1075: select pay_assignment_actions_s.nextval
1076: into l_ass_act_id
1077: from dual;
1078: --
1079: -- insert into pay_assignment_actions.
1080: hr_nonrun_asact.insact(l_ass_act_id,
1081: asg_rec.assignment_id,
1082: pactid,
1083: chunk,

Line 1096: select pay_assignment_actions_s.nextval

1092: -- Check if assignment action already created for this assignment
1093: l_arch := check_action(pactid,asg_rec.assignment_id);
1094: if l_arch then
1095: -- hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
1096: select pay_assignment_actions_s.nextval
1097: into l_ass_act_id
1098: from dual;
1099: --
1100: -- insert into pay_assignment_actions.

Line 1100: -- insert into pay_assignment_actions.

1096: select pay_assignment_actions_s.nextval
1097: into l_ass_act_id
1098: from dual;
1099: --
1100: -- insert into pay_assignment_actions.
1101: hr_nonrun_asact.insact(l_ass_act_id,
1102: asg_rec.assignment_id,
1103: pactid,
1104: chunk,

Line 1223: from pay_assignment_actions act,

1219: pap.previous_last_name,
1220: per_information1 ethnic_code,
1221: pap.date_of_birth date_of_birth,
1222: to_char(pap.date_of_birth,'YYYY-MM-DD') dob_dcsf
1223: from pay_assignment_actions act,
1224: per_all_assignments_f paa,
1225: per_all_people_f pap
1226: where act.assignment_action_id = p_assactid
1227: and act.assignment_id = paa.assignment_id

Line 1252: from pay_assignment_actions act,

1248: and csr_effective_date between pdf.effective_start_date and pdf.effective_end_date;
1249: --
1250: cursor csr_cont_eff_date_asg is
1251: select max(effective_end_date)
1252: from pay_assignment_actions act,
1253: per_all_assignments_f paa,
1254: per_assignment_status_types pas
1255: where act.assignment_action_id = p_assactid
1256: and act.assignment_id = paa.assignment_id

Line 1262: from pay_assignment_actions act,

1258: and pas.per_system_status = 'ACTIVE_ASSIGN';
1259:
1260: cursor csr_cont_eff_date_contract is
1261: select max(effective_end_date)
1262: from pay_assignment_actions act,
1263: pqp_assignment_attributes_f att
1264: where act.assignment_action_id = p_assactid
1265: and act.assignment_id = att.assignment_id;
1266:

Line 1269: from pay_assignment_actions act,

1265: and act.assignment_id = att.assignment_id;
1266:
1267: cursor get_person_id(p_effective_date date) is
1268: select ppf.person_id,ppf.employee_number
1269: from pay_assignment_actions act,
1270: per_all_assignments_f paa,
1271: per_all_people_f ppf
1272: where act.assignment_action_id = p_assactid
1273: and act.assignment_id = paa.assignment_id

Line 1896: pay_assignment_actions assact,

1892: pay_element_type_extra_info pexi,
1893: pay_run_results prr,
1894: pay_input_values_f piv,
1895: pay_run_result_values prrv,
1896: pay_assignment_actions assact,
1897: pay_payroll_actions pact,
1898: per_time_periods pptp
1899: where paf.assignment_id = p_assignment_id
1900: and paf.assignment_id = pee.assignment_id

Line 2698: from pay_assignment_actions act,

2694: paa.assignment_number assignment_number,
2695: paa.employment_category contract_agg_type,
2696: paa.employee_category employee_cat,
2697: paa.employment_category assignment_cat
2698: from pay_assignment_actions act,
2699: per_all_assignments_f paa
2700: where act.assignment_action_id = p_assactid
2701: and act.assignment_id = paa.assignment_id
2702: and p_effective_date between paa.effective_start_date and paa.effective_end_date;

Line 2724: pay_assignment_actions act,

2720: att.contract_type contract_agg_type,
2721: paa.employee_category employee_cat,
2722: paa.employment_category assignment_cat
2723: from per_all_assignments_f paa,
2724: pay_assignment_actions act,
2725: pqp_assignment_attributes_f att
2726: where act.assignment_action_id = p_assactid
2727: and act.assignment_id = att.assignment_id
2728: and paa.assignment_id = att.assignment_id

Line 3991: from pay_assignment_actions paa, pay_payroll_actions ppa

3987: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_ABS')) exclude_abs,
3988: (pay_gb_eoy_archive.get_parameter(legislative_parameters,'EXCLUDE_QUAL')) exclude_qual,
3989: business_group_id,
3990: ppa.payroll_action_id
3991: from pay_assignment_actions paa, pay_payroll_actions ppa
3992: where paa.assignment_action_id = p_assactid
3993: and paa.payroll_action_id = ppa.payroll_action_id;
3994:
3995: cursor csr_asg_no(p_census_day in date) is

Line 3997: from pay_assignment_actions act,

3993: and paa.payroll_action_id = ppa.payroll_action_id;
3994:
3995: cursor csr_asg_no(p_census_day in date) is
3996: select paa.assignment_id , paa.employment_category, paa.assignment_number
3997: from pay_assignment_actions act,
3998: per_all_assignments_f paa,
3999: per_assignment_status_types pas
4000: where act.assignment_action_id = p_assactid
4001: and act.assignment_id = paa.assignment_id

Line 4275: pay_assignment_actions paa,

4271: paf.assignment_number asg_no,
4272: peo.national_identifier ni_no,
4273: paa.assignment_action_id asg_act_id
4274: from pay_payroll_actions pay,
4275: pay_assignment_actions paa,
4276: per_all_assignments_f paf,
4277: per_all_people_f peo,
4278: (select max(effective_end_date) effective_date,assignment_id
4279: from per_all_assignments_f

Line 4322: pay_assignment_actions paa,

4318: paf.assignment_number asg_no,
4319: peo.national_identifier ni_no,
4320: paa.assignment_action_id asg_act_id
4321: from pay_payroll_actions pay,
4322: pay_assignment_actions paa,
4323: per_all_assignments_f paf,
4324: per_all_people_f peo,
4325: (select max(effective_end_date) effective_date,assignment_id
4326: from per_all_assignments_f

Line 4344: pay_assignment_actions paa

4340: cursor fte_hrs is
4341: select action_information4 person_id,sum(action_information7)
4342: from pay_action_information pai,
4343: pay_payroll_actions ppa,
4344: pay_assignment_actions paa
4345: where ppa.payroll_action_id = pactid
4346: and ppa.payroll_action_id = paa.payroll_action_id
4347: and paa.assignment_action_id = pai.action_context_id
4348: and pai.action_information_category = 'GB_SWF_HOURS_DETAILS'

Line 4370: pay_assignment_actions paa

4366: CURSOR hdtr_count IS
4367: select COUNT(*)
4368: from pay_action_information pai,
4369: pay_payroll_actions ppa,
4370: pay_assignment_actions paa
4371: where ppa.payroll_action_id = pactid
4372: and ppa.payroll_action_id = paa.payroll_action_id
4373: and paa.assignment_action_id = pai.action_context_id
4374: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 4387: pay_assignment_actions paa

4383: cursor epsy_head_count_prm is
4384: select COUNT(*)
4385: from pay_action_information pai,
4386: pay_payroll_actions ppa,
4387: pay_assignment_actions paa
4388: where ppa.payroll_action_id = pactid
4389: and ppa.payroll_action_id = paa.payroll_action_id
4390: and paa.assignment_action_id = pai.action_context_id
4391: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 4399: pay_assignment_actions paa

4395: cursor epsy_head_count_part_time is
4396: select COUNT(*)
4397: from pay_action_information pai,
4398: pay_payroll_actions ppa,
4399: pay_assignment_actions paa
4400: where ppa.payroll_action_id = pactid
4401: and ppa.payroll_action_id = paa.payroll_action_id
4402: and paa.assignment_action_id = pai.action_context_id
4403: and pai.action_information_category = 'GB_SWF_ROLE_DETAILS'

Line 4412: pay_assignment_actions paa

4408: select sum(pai2.action_information7)
4409: from pay_action_information pai,
4410: pay_action_information pai2,
4411: pay_payroll_actions ppa,
4412: pay_assignment_actions paa
4413: where ppa.payroll_action_id = pactid
4414: and ppa.payroll_action_id = paa.payroll_action_id
4415: and paa.assignment_action_id = pai.action_context_id
4416: and pai.action_context_id = pai2.action_context_id