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 758: l_object_version_number pay_pl_sii_details_f.object_version_number%type;

754: --check if record already exists with contract category as term_normal?
755:
756: declare --declare 1
757: l_sii_already char(1):='0';
758: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
759: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
760: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
761: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
762: l_effective_date_warning boolean;

Line 759: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;

755:
756: declare --declare 1
757: l_sii_already char(1):='0';
758: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
759: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
760: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
761: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
762: l_effective_date_warning boolean;
763: l_person_id number(10);

Line 760: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;

756: declare --declare 1
757: l_sii_already char(1):='0';
758: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
759: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
760: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
761: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
762: l_effective_date_warning boolean;
763: l_person_id number(10);
764: l_business_group_id number(10);

Line 761: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;

757: l_sii_already char(1):='0';
758: l_object_version_number pay_pl_sii_details_f.object_version_number%type;
759: l_sii_details_id pay_pl_sii_details_f.sii_details_id%type;
760: l_effective_start_date pay_pl_sii_details_f.effective_start_date%type;
761: l_effective_end_date pay_pl_sii_details_f.effective_end_date%type;
762: l_effective_date_warning boolean;
763: l_person_id number(10);
764: l_business_group_id number(10);
765:

Line 773: select '1' from pay_pl_sii_details_f

769: where assignment_id=p_assignment_id
770: and p_effective_date between effective_start_date and effective_end_date;
771:
772: cursor csr_sii_already_exists is
773: select '1' from pay_pl_sii_details_f
774: where contract_category='TERM_NORMAL'
775: and p_effective_date between effective_start_date and effective_end_date
776: and per_or_asg_id=p_assignment_id;
777:

Line 783: from pay_pl_sii_details_f

779: select emp_social_security_info,old_age_contribution,pension_contribution,sickness_contribution,
780: work_injury_contribution,labor_contribution,health_contribution,unemployment_contribution,
781: old_age_cont_end_reason,pension_cont_end_reason,sickness_cont_end_reason,
782: work_injury_cont_end_reason,labor_fund_cont_end_reason,health_cont_end_reason,unemployment_cont_end_reason
783: from pay_pl_sii_details_f
784: where per_or_asg_id=r_person_id
785: and contract_category='NORMAL'
786: and p_effective_date between effective_start_date and effective_end_date;
787: l_csr_sii_details csr_sii_details%rowtype;