APPS.PER_PL_ASSIGNMENT dependencies on PAY_PL_SII_DETAILS_F

Line 14: from pay_pl_sii_details_f

10: and r_date between effective_start_date and effective_end_date ;
11:
12: cursor csr_check_sii_exists(r_join_variable in number,r_date date) is
13: select '1'
14: from pay_pl_sii_details_f
15: where per_or_asg_id=r_join_variable
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

Line 633: l_object_version_number pay_pl_sii_details_f.object_version_number%type;

629: --check if record already exists with contract category as term_normal?
630:
631: declare --declare 1
632: l_sii_already char(1):='0';
633: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
634: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
635: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
636: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
637: l_effective_date_warning boolean;

Line 634: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;

630:
631: declare --declare 1
632: l_sii_already char(1):='0';
633: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
634: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
635: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
636: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
637: l_effective_date_warning boolean;
638: l_person_id number(10);

Line 635: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;

631: declare --declare 1
632: l_sii_already char(1):='0';
633: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
634: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
635: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
636: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
637: l_effective_date_warning boolean;
638: l_person_id number(10);
639: l_business_group_id number(10);

Line 636: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;

632: l_sii_already char(1):='0';
633: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
634: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
635: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
636: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
637: l_effective_date_warning boolean;
638: l_person_id number(10);
639: l_business_group_id number(10);
640:

Line 648: select '1' from pay_pl_sii_details_f

644: where assignment_id=p_assignment_id
645: and p_effective_date between effective_start_date and effective_end_date;
646:
647: cursor csr_sii_already_exists is
648: select '1' from pay_pl_sii_details_f
649: where contract_category='TERM_NORMAL'
650: and p_effective_date between effective_start_date and effective_end_date
651: and per_or_asg_id=p_assignment_id;
652:

Line 658: from pay_pl_sii_details_f

654: select emp_social_security_info,old_age_contribution,pension_contribution,sickness_contribution,
655: work_injury_contribution,labor_contribution,health_contribution,unemployment_contribution,
656: old_age_cont_end_reason,pension_cont_end_reason,sickness_cont_end_reason,
657: work_injury_cont_end_reason,labor_fund_cont_end_reason,health_cont_end_reason,unemployment_cont_end_reason
658: from pay_pl_sii_details_f
659: where per_or_asg_id=r_person_id
660: and contract_category='NORMAL'
661: and p_effective_date between effective_start_date and effective_end_date;
662: l_csr_sii_details csr_sii_details%rowtype;