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.PAY_PL_SII_API dependencies on PAY_PL_SII_DETAILS_F

Line 55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;

51: l_effective_start_date date;
52: l_effective_end_date date;
53: l_reset_date date;
54:
55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;
56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;

Line 56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;

52: l_effective_end_date date;
53: l_reset_date date;
54:
55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;
56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;

Line 57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;

53: l_reset_date date;
54:
55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;
56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;

Line 58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;

54:
55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;
56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:

Line 59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;

55: l_old_age_contribution pay_pl_sii_details_f.old_age_contribution%type;
56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:
63: l_emp per_person_types.system_person_type%TYPE;

Line 60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;

56: l_pension_contribution pay_pl_sii_details_f.pension_contribution%type;
57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:
63: l_emp per_person_types.system_person_type%TYPE;
64: l_emp_apl per_person_types.system_person_type%TYPE;

Line 61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;

57: l_sickness_contribution pay_pl_sii_details_f.sickness_contribution%type;
58: l_work_injury_contribution pay_pl_sii_details_f.work_injury_contribution%type;
59: l_labor_contribution pay_pl_sii_details_f.labor_contribution%type;
60: l_health_contribution pay_pl_sii_details_f.health_contribution%type;
61: l_unemployment_contribution pay_pl_sii_details_f.unemployment_contribution%type;
62:
63: l_emp per_person_types.system_person_type%TYPE;
64: l_emp_apl per_person_types.system_person_type%TYPE;
65: l_active_assign per_assignment_status_types.per_system_status%TYPE;

Line 343: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;

339: --
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;
342: l_legislation_code per_business_groups.legislation_code%TYPE;
343: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
344:
345: l_effective_date date;
346: l_effective_start_date date;
347: l_effective_end_date date;

Line 444: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;

440: --
441:
442: l_business_group_id per_business_groups.business_group_id%TYPE;
443: l_legislation_code per_business_groups.legislation_code%TYPE;
444: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
445:
446: l_effective_date date;
447: l_effective_start_date date;
448: l_effective_end_date date;

Line 545: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;

541: --
542:
543: l_business_group_id per_business_groups.business_group_id%TYPE;
544: l_legislation_code per_business_groups.legislation_code%TYPE;
545: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
546:
547: l_effective_date date;
548: l_effective_start_date date;
549: l_effective_end_date date;

Line 655: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;

651: l_effective_end_date date;
652: l_object_version_number number;
653: l_sii_details_id number;
654: l_proc varchar2(72) := g_package||'create_pl_civil_sii_details';
655: l_contract_category pay_pl_sii_details_f.contract_category%TYPE;
656:
657: cursor csr_get_derived_details is
658: select bus.business_group_id
659: , bus.legislation_code

Line 765: l_norm_term pay_pl_sii_details_f.contract_category%TYPE;

761: l_effective_start_date date;
762: l_effective_end_date date;
763: l_object_version_number number;
764: l_in_out_parameter1 number;
765: l_norm_term pay_pl_sii_details_f.contract_category%TYPE;
766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;
767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;
768:
769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;

Line 766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;

762: l_effective_end_date date;
763: l_object_version_number number;
764: l_in_out_parameter1 number;
765: l_norm_term pay_pl_sii_details_f.contract_category%TYPE;
766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;
767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;
768:
769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;
770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;

Line 767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;

763: l_object_version_number number;
764: l_in_out_parameter1 number;
765: l_norm_term pay_pl_sii_details_f.contract_category%TYPE;
766: l_norm_active pay_pl_sii_details_f.contract_category%TYPE;
767: l_exists pay_pl_sii_details_f.per_or_asg_id%TYPE;
768:
769: l_assg_type1 per_assignment_status_types.per_system_status%TYPE;
770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;
771: l_flag varchar2(1);

Line 774: select per_or_asg_id from pay_pl_sii_details_f

770: l_assg_type2 per_assignment_status_types.per_system_status%TYPE;
771: l_flag varchar2(1);
772:
773: cursor csr_term_catg(p_contract_catg char) is
774: select per_or_asg_id from pay_pl_sii_details_f
775: where sii_details_id = p_sii_details_id and
776: p_effective_date between effective_start_date and effective_end_date and
777: contract_category = p_contract_catg;
778:

Line 787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f

783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f
788: where sii_details_id = p_sii_details_id and
789: p_effective_date between effective_start_date
790: and effective_end_date)
791: and pap.person_id = paf1.person_id