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.PER_PL_ASSIGNMENT dependencies on PAY_PL_PAYE_DETAILS_F

Line 20: from pay_pl_paye_details_f

16: and r_date between effective_start_date and effective_end_date;
17:
18: cursor csr_check_paye_exists(r_join_variable in number,r_date date) is
19: select '1'
20: from pay_pl_paye_details_f
21: where per_or_asg_id=r_join_variable
22: and r_date between effective_start_date and effective_end_date;
23:
24: cursor csr_assgt_type(r_assignment_id number,r_date date) is

Line 713: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

709:
710:
711: declare --declare2
712: l_paye_already char(1):='0';
713: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
714: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
715: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
716: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
717: l_effective_date_warning boolean;

Line 714: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

710:
711: declare --declare2
712: l_paye_already char(1):='0';
713: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
714: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
715: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
716: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
717: l_effective_date_warning boolean;
718: l_person_id number(10);

Line 715: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

711: declare --declare2
712: l_paye_already char(1):='0';
713: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
714: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
715: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
716: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
717: l_effective_date_warning boolean;
718: l_person_id number(10);
719: l_business_group_id number(10);

Line 716: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

712: l_paye_already char(1):='0';
713: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
714: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
715: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
716: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
717: l_effective_date_warning boolean;
718: l_person_id number(10);
719: l_business_group_id number(10);
720:

Line 729: select '1' from pay_pl_paye_details_f

725: where assignment_id=p_assignment_id
726: and p_effective_date between effective_start_date and effective_end_date;
727:
728: cursor csr_paye_already_exists is
729: select '1' from pay_pl_paye_details_f
730: where contract_category='TERM_NORMAL'
731: and p_effective_date between effective_start_date and effective_end_date
732: and per_or_asg_id=p_assignment_id;
733:

Line 736: from pay_pl_paye_details_f

732: and per_or_asg_id=p_assignment_id;
733:
734: cursor csr_paye_details(r_person_id number) is
735: select tax_reduction,tax_calc_with_spouse_child,income_reduction,income_reduction_amount,rate_of_tax
736: from pay_pl_paye_details_f
737: where per_or_asg_id=r_person_id
738: and contract_category='NORMAL'
739: and p_effective_date between effective_start_date and effective_end_date;
740: l_csr_paye_details csr_paye_details%rowtype;

Line 986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

982: where assignment_id = p_assignment_id;
983:
984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
985:
986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
989: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
990: l_effective_date_warning boolean;

Line 987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

983:
984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
985:
986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
989: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
990: l_effective_date_warning boolean;
991: l_proc varchar2(30);

Line 988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
985:
986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
989: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
990: l_effective_date_warning boolean;
991: l_proc varchar2(30);
992:

Line 989: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

985:
986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
989: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
990: l_effective_date_warning boolean;
991: l_proc varchar2(30);
992:
993: BEGIN

Line 1045: l_object_version_number pay_pl_paye_details_f.object_version_number%type;

1041: where paaf.soft_coding_keyflex_id = soft.soft_coding_keyflex_id
1042: and paaf.assignment_id = p_assignment_id
1043: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1044:
1045: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1046: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;

Line 1046: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;

1042: and paaf.assignment_id = p_assignment_id
1043: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1044:
1045: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1046: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;
1050: l_record_exists varchar2(1);

Line 1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

1043: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1044:
1045: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1046: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;
1050: l_record_exists varchar2(1);
1051: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;

Line 1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

1044:
1045: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1046: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;
1050: l_record_exists varchar2(1);
1051: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1052: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;

Line 1051: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;

1047: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;
1050: l_record_exists varchar2(1);
1051: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1052: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1053: l_proc varchar2(19);
1054: cursor csr_paye_exists is
1055: select '1'

Line 1056: from pay_pl_paye_details_f

1052: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1053: l_proc varchar2(19);
1054: cursor csr_paye_exists is
1055: select '1'
1056: from pay_pl_paye_details_f
1057: where per_or_asg_id = p_assignment_id
1058: and contract_category = l_segment3;
1059:
1060: BEGIN