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_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 65: FROM per_all_assignments_f paf,

61: ,'PIX'
62: ,per.per_information14
63: ,per.marital_status
64: ,paf.primary_flag
65: FROM per_all_assignments_f paf,
66: per_all_people_f per,
67: per_periods_of_service pps,
68: per_assignment_status_types ast
69: WHERE paf.assignment_id = c_assignment_id

Line 96: FROM per_all_assignments_f

92: -- Check whether assignment is primary or secondary
93: -- =============================================================================
94: CURSOR csr_chk_primary_asg(c_assignment_id NUMBER, c_effective_date DATE) IS
95: SELECT 'x'
96: FROM per_all_assignments_f
97: WHERE assignment_id = c_assignment_id
98: AND primary_flag= 'Y'
99: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
100:

Line 111: FROM per_all_assignments_f paf,

107: ,c_business_group_id IN Number
108: ,c_person_id IN Number) IS
109: SELECT paf.organization_id
110: ,paf.payroll_id
111: FROM per_all_assignments_f paf,
112: per_all_people_f per
113: WHERE paf.assignment_id <> c_assignment_id
114: AND paf.person_id = c_person_id
115: AND paf.person_id = per.person_id

Line 177: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE

173: -- =============================================================================
174: -- Cursor to chk for other primary assig. within the extract date range.
175: -- =============================================================================
176: CURSOR csr_sec_assg
177: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
178: ,c_person_id IN per_all_people_f.person_id%TYPE
179: ,c_effective_date IN Date
180: ,c_extract_start_date IN Date
181: ,c_extract_end_date IN Date ) IS

Line 189: FROM per_all_assignments_f asg

185: ,asg.effective_start_date
186: ,asg.effective_end_date
187: ,'NO'
188: ,asg.assignment_id
189: FROM per_all_assignments_f asg
190: WHERE asg.person_id = c_person_id
191: AND asg.assignment_id <> c_primary_assignment_id
192: AND asg.assignment_type ='E'
193: AND (( c_effective_date BETWEEN asg.effective_start_date

Line 199: FROM per_all_assignments_f asx

195: )
196: OR
197: ( asg.effective_end_date =
198: (SELECT Max(asx.effective_end_date)
199: FROM per_all_assignments_f asx
200: WHERE asx.assignment_id = asg.assignment_id
201: AND asx.person_id = c_person_id
202: AND asx.assignment_type = 'E'
203: AND ((asx.effective_end_date BETWEEN c_extract_start_date

Line 261: ,per_all_assignments_f PAA

257: ,c_date_earned IN DATE )
258: IS
259: SELECT NVL(min(PTP.start_date),to_date('0101'||c_year,'DDMMYYYY'))
260: FROM per_time_periods PTP
261: ,per_all_assignments_f PAA
262: WHERE PAA.assignment_id = c_assignment_id
263: AND PTP.payroll_id = PAA.payroll_id
264: AND (c_date_earned between PAA.effective_start_date and PAA.effective_end_date)
265: AND (substr(PTP.period_name,4,4)=c_year

Line 277: , per_all_assignments_f PAA

273: ,c_date_earned IN DATE )
274: IS
275: SELECT NVL(max(PTP.end_date),to_date('3112'||c_year,'DDMMYYYY'))
276: FROM per_time_periods PTP
277: , per_all_assignments_f PAA
278: WHERE PAA.assignment_id = c_assignment_id
279: AND PTP.payroll_id = PAA.payroll_id
280: AND (c_date_earned between PAA.effective_start_date and PAA.effective_end_date)
281: AND (substr(PTP.period_name,4,4)=c_year

Line 290: FROM per_all_assignments_f PAA

286: -- =============================================================================
287: CURSOR c_get_num_periods_per_year(c_assignment_id IN NUMBER
288: ,c_date_earned IN DATE) IS
289: SELECT NVL(TPTYPE.number_per_fiscal_year,12)
290: FROM per_all_assignments_f PAA
291: , per_time_periods TPERIOD
292: , per_time_period_types TPTYPE
293: WHERE PAA.assignment_id = c_assignment_id
294: AND TPERIOD.payroll_id = PAA.payroll_id

Line 413: FROM per_all_assignments_f

409: l_person_id Number;
410: BEGIN
411: SELECT person_id
412: INTO l_person_id
413: FROM per_all_assignments_f
414: WHERE assignment_id = p_assignment_id
415: AND ROWNUM < 2;
416: RETURN l_person_id;
417: EXCEPTION

Line 454: ,per_all_assignments_f PAA

450: 0,substr(PTP.period_name,3,4),
451: 1,substr(PTP.period_name,4,4)
452: )
453: FROM per_time_periods PTP
454: ,per_all_assignments_f PAA
455: WHERE PAA.assignment_id = c_assignment_id
456: AND PTP.payroll_id = PAA.payroll_id
457: AND ( c_effective_date between PTP.start_date and PTP.end_date );
458:

Line 1287: FROM per_all_assignments_f

1283: AND effective_end_date;
1284:
1285: CURSOR c_get_org_id IS
1286: SELECT organization_id,business_group_id
1287: FROM per_all_assignments_f
1288: WHERE assignment_id = p_assignment_id
1289: AND business_group_id = g_business_group_id
1290: AND p_effective_date BETWEEN effective_start_date
1291: AND effective_end_date;

Line 1300: l_org_id per_all_assignments_f.organization_id%TYPE;

1296: l_formula_type_id ff_formulas_f.formula_id%TYPE;
1297: l_outputs Ff_Exec.outputs_t;
1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1300: l_org_id per_all_assignments_f.organization_id%TYPE;
1301: l_bgid per_all_assignments_f.business_group_id%TYPE;
1302:
1303:
1304: BEGIN

Line 1301: l_bgid per_all_assignments_f.business_group_id%TYPE;

1297: l_outputs Ff_Exec.outputs_t;
1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1300: l_org_id per_all_assignments_f.organization_id%TYPE;
1301: l_bgid per_all_assignments_f.business_group_id%TYPE;
1302:
1303:
1304: BEGIN
1305: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1386: bg_id per_all_assignments_f.business_group_id%TYPE;

1382: ,p_error_message OUT NOCOPY Varchar2
1383: ) RETURN Varchar2 IS
1384:
1385: l_return_value Varchar2(50);
1386: bg_id per_all_assignments_f.business_group_id%TYPE;
1387: l_proc_name Varchar2(150) := g_proc_name ||'Check_Addl_Assigs';
1388: l_sec_assg_rec csr_sec_assg%ROWTYPE;
1389: l_effective_date Date;
1390: l_criteria_value Varchar2(2);

Line 1393: l_asg_type per_all_assignments_f.assignment_type%TYPE;

1389: l_effective_date Date;
1390: l_criteria_value Varchar2(2);
1391: l_warning_message Varchar2(2000);
1392: l_error_message Varchar2(2000);
1393: l_asg_type per_all_assignments_f.assignment_type%TYPE;
1394: l_person_id per_all_people_f.person_id%TYPE;
1395: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1396: BEGIN
1397: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1395: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1391: l_warning_message Varchar2(2000);
1392: l_error_message Varchar2(2000);
1393: l_asg_type per_all_assignments_f.assignment_type%TYPE;
1394: l_person_id per_all_people_f.person_id%TYPE;
1395: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1396: BEGIN
1397: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1398: bg_id := p_business_group_id;
1399:

Line 1464: bg_id per_all_assignments_f.business_group_id%TYPE;

1460:
1461: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1462: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1463: l_valid_action Varchar2(2);
1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';
1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1468: l_organization_id per_all_assignments_f.organization_id%TYPE;

Line 1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1463: l_valid_action Varchar2(2);
1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';
1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1468: l_organization_id per_all_assignments_f.organization_id%TYPE;
1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1470: l_main_rec csr_rslt_dtl%ROWTYPE;
1471: l_new_rec csr_rslt_dtl%ROWTYPE;

Line 1468: l_organization_id per_all_assignments_f.organization_id%TYPE;

1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';
1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1468: l_organization_id per_all_assignments_f.organization_id%TYPE;
1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1470: l_main_rec csr_rslt_dtl%ROWTYPE;
1471: l_new_rec csr_rslt_dtl%ROWTYPE;
1472: l_effective_date Date;

Line 1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';
1467: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1468: l_organization_id per_all_assignments_f.organization_id%TYPE;
1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1470: l_main_rec csr_rslt_dtl%ROWTYPE;
1471: l_new_rec csr_rslt_dtl%ROWTYPE;
1472: l_effective_date Date;
1473: l_ext_rcd_id ben_ext_rcd.ext_rcd_id %TYPE;

Line 1609: bg_id per_all_assignments_f.business_group_id%TYPE;

1605: ,p_error_message OUT NOCOPY Varchar2
1606: ) RETURN Number IS
1607:
1608: l_return_value Number;
1609: bg_id per_all_assignments_f.business_group_id%TYPE;
1610: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1611: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1612: l_valid_action Varchar2(2);
1613: l_no_asg_action Number(5) := 0;

Line 1620: l_asg_type per_all_assignments_f.assignment_type %TYPE;

1616: l_effective_date Date;
1617: l_criteria_value Varchar2(2);
1618: l_warning_message Varchar2(2000);
1619: l_error_message Varchar2(2000);
1620: l_asg_type per_all_assignments_f.assignment_type %TYPE;
1621: l_main_rec csr_rslt_dtl%ROWTYPE;
1622: l_person_id per_all_people_f.person_id%TYPE;
1623: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1624: l_mutli_assig Varchar2(150);

Line 1623: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1619: l_error_message Varchar2(2000);
1620: l_asg_type per_all_assignments_f.assignment_type %TYPE;
1621: l_main_rec csr_rslt_dtl%ROWTYPE;
1622: l_person_id per_all_people_f.person_id%TYPE;
1623: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1624: l_mutli_assig Varchar2(150);
1625: BEGIN
1626:
1627: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 1893: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1889: -- (only child organizations which are non-tax organizations are taken in account).
1890: -- =============================================================================
1891:
1892: FUNCTION Pension_Criteria_Full_Profile
1893: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1894: ,p_effective_date IN Date
1895: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
1896: ,p_warning_message OUT NOCOPY Varchar2
1897: ,p_error_message OUT NOCOPY Varchar2

Line 1895: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

1891:
1892: FUNCTION Pension_Criteria_Full_Profile
1893: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1894: ,p_effective_date IN Date
1895: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
1896: ,p_warning_message OUT NOCOPY Varchar2
1897: ,p_error_message OUT NOCOPY Varchar2
1898: ) RETURN Varchar2 IS
1899: -- =========================================

Line 2027: FROM per_all_assignments_f asg

2023:
2024: --Cursor to check the previous PTP in the Std Conditions tab
2025: CURSOR csr_get_prev_ptp_std_cond(c_asg_id NUMBER,c_date DATE) IS
2026: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc
2027: FROM per_all_assignments_f asg
2028: ,hr_soft_coding_keyflex scl
2029: WHERE asg.assignment_id = c_asg_id
2030: AND (c_date - 1 BETWEEN asg.effective_start_date
2031: AND asg.effective_end_date)

Line 2082: FROM per_all_assignments_f asg

2078:
2079: -------Cursor to check whether there is any change in incidental worker code
2080: CURSOR csr_chk_inci_code_ele(c_asg_id NUMBER,bg_id NUMBER) IS
2081: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1, asg.effective_start_date,asg.effective_end_date
2082: FROM per_all_assignments_f asg
2083: ,hr_soft_coding_keyflex scl
2084: WHERE asg.assignment_id = c_asg_id
2085: AND (asg.effective_start_date BETWEEN g_extract_params(bg_id).extract_start_date
2086: AND g_extract_params(p_business_group_id).extract_end_date)

Line 2207: FROM per_all_assignments_f asg

2203:
2204: -------Cursor to check whether there is any change in incidental worker code
2205: CURSOR csr_chk_inci_code_chg_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
2206: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1
2207: FROM per_all_assignments_f asg
2208: ,hr_soft_coding_keyflex scl
2209: WHERE asg.assignment_id = c_asg_id
2210: AND (c_date - 1 BETWEEN asg.effective_start_date
2211: AND asg.effective_end_date)

Line 2265: bg_id per_all_assignments_f.business_group_id%TYPE;

2261: -- =========================================
2262: l_ext_params csr_ext_params%ROWTYPE;
2263: l_conc_reqest_id ben_ext_rslt.request_id%TYPE;
2264: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
2265: bg_id per_all_assignments_f.business_group_id%TYPE;
2266: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2268: l_return_value Varchar2(2) :='N';
2269: l_valid_action Varchar2(2);

Line 2821: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

2817: -- =============================================================================
2818: -- Get_Street
2819: -- =============================================================================
2820: FUNCTION Get_Street
2821: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2822: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2823: ,p_effective_date IN Date
2824: ,p_error_message OUT NOCOPY Varchar2
2825: ,p_data_element_value OUT NOCOPY Varchar2

Line 2822: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

2818: -- Get_Street
2819: -- =============================================================================
2820: FUNCTION Get_Street
2821: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2822: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2823: ,p_effective_date IN Date
2824: ,p_error_message OUT NOCOPY Varchar2
2825: ,p_data_element_value OUT NOCOPY Varchar2
2826: ) RETURN Number IS

Line 2872: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

2868: -- =============================================================================
2869: -- Get_House_Num
2870: -- =============================================================================
2871: FUNCTION Get_House_Num
2872: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2873: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2874: ,p_effective_date IN Date
2875: ,p_error_message OUT NOCOPY Varchar2
2876: ,p_data_element_value OUT NOCOPY Varchar2

Line 2873: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

2869: -- Get_House_Num
2870: -- =============================================================================
2871: FUNCTION Get_House_Num
2872: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2873: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2874: ,p_effective_date IN Date
2875: ,p_error_message OUT NOCOPY Varchar2
2876: ,p_data_element_value OUT NOCOPY Varchar2
2877: ) RETURN Number IS

Line 2922: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

2918: -- =============================================================================
2919: -- Get_Addl_House_Num
2920: -- =============================================================================
2921: FUNCTION Get_Addl_House_Num
2922: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2923: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2924: ,p_effective_date IN Date
2925: ,p_error_message OUT NOCOPY Varchar2
2926: ,p_data_element_value OUT NOCOPY Varchar2

Line 2923: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

2919: -- Get_Addl_House_Num
2920: -- =============================================================================
2921: FUNCTION Get_Addl_House_Num
2922: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2923: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2924: ,p_effective_date IN Date
2925: ,p_error_message OUT NOCOPY Varchar2
2926: ,p_data_element_value OUT NOCOPY Varchar2
2927: ) RETURN Number IS

Line 2975: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

2971: -- =============================================================================
2972: -- Get_Postal_Code
2973: -- =============================================================================
2974: FUNCTION Get_Postal_Code
2975: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2976: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2977: ,p_effective_date IN Date
2978: ,p_error_message OUT NOCOPY Varchar2
2979: ,p_data_element_value OUT NOCOPY Varchar2

Line 2976: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

2972: -- Get_Postal_Code
2973: -- =============================================================================
2974: FUNCTION Get_Postal_Code
2975: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2976: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
2977: ,p_effective_date IN Date
2978: ,p_error_message OUT NOCOPY Varchar2
2979: ,p_data_element_value OUT NOCOPY Varchar2
2980: ) RETURN Number IS

Line 3032: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3028: -- =============================================================================
3029: -- Get_City
3030: -- =============================================================================
3031: FUNCTION Get_City
3032: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3033: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3034: ,p_effective_date IN Date
3035: ,p_error_message OUT NOCOPY Varchar2
3036: ,p_data_element_value OUT NOCOPY Varchar2

Line 3033: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3029: -- Get_City
3030: -- =============================================================================
3031: FUNCTION Get_City
3032: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3033: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3034: ,p_effective_date IN Date
3035: ,p_error_message OUT NOCOPY Varchar2
3036: ,p_data_element_value OUT NOCOPY Varchar2
3037: ) RETURN Number IS

Line 3160: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3156: -- =============================================================================
3157: -- Get_Gender:
3158: -- =============================================================================
3159: FUNCTION Get_Gender
3160: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3161: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3162: ,p_effective_date IN Date
3163: ,p_error_message OUT NOCOPY Varchar2
3164: ,p_data_element_value OUT NOCOPY Varchar2

Line 3161: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3157: -- Get_Gender:
3158: -- =============================================================================
3159: FUNCTION Get_Gender
3160: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3161: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3162: ,p_effective_date IN Date
3163: ,p_error_message OUT NOCOPY Varchar2
3164: ,p_data_element_value OUT NOCOPY Varchar2
3165: ) RETURN Number IS

Line 3216: FROM per_all_assignments_f asg

3212: --cursor to fetch the Occupation_Code
3213: --from the soft coding key flex
3214: CURSOR c_get_emp_code IS
3215: SELECT scl.SEGMENT2||scl.SEGMENT3
3216: FROM per_all_assignments_f asg
3217: ,hr_soft_coding_keyflex scl
3218: WHERE asg.assignment_id = p_assignment_id
3219: AND p_effective_date BETWEEN asg.effective_start_date
3220: AND asg.effective_end_date

Line 3321: FROM per_all_assignments_f sec,

3317: and peev.effective_end_date );
3318: --5869420
3319: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3320: SELECT pri.assignment_id
3321: FROM per_all_assignments_f sec,
3322: per_all_assignments_f pri
3323: WHERE sec.assignment_id = c_assgt_id
3324: AND sec.person_id = pri.person_id
3325: AND pri.primary_flag = 'Y'

Line 3322: per_all_assignments_f pri

3318: --5869420
3319: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3320: SELECT pri.assignment_id
3321: FROM per_all_assignments_f sec,
3322: per_all_assignments_f pri
3323: WHERE sec.assignment_id = c_assgt_id
3324: AND sec.person_id = pri.person_id
3325: AND pri.primary_flag = 'Y'
3326: AND c_date BETWEEN pri.effective_start_date AND pri.effective_end_date

Line 3390: FROM per_all_assignments_f paf,

3386: Return Number is
3387: -- Cursor to get Org id for the given asg id
3388: CURSOR csr_get_org_id IS
3389: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3390: FROM per_all_assignments_f paf,
3391: pay_all_payrolls_f ppf
3392: WHERE paf.assignment_id = p_assignment_id
3393: AND paf.business_group_id = p_business_group_id
3394: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN

Line 3469: FROM per_all_assignments_f paf,

3465:
3466: -- Cursor to get Org id for the given asg id
3467: CURSOR csr_get_org_id IS
3468: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3469: FROM per_all_assignments_f paf,
3470: pay_all_payrolls_f ppf
3471: WHERE paf.assignment_id = p_assignment_id
3472: AND paf.business_group_id = p_business_group_id
3473: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN

Line 3565: FROM per_all_assignments_f sec,

3561: and peev.effective_end_date);
3562:
3563: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3564: SELECT pri.assignment_id
3565: FROM per_all_assignments_f sec,
3566: per_all_assignments_f pri
3567: WHERE sec.assignment_id = c_assgt_id
3568: AND sec.person_id = pri.person_id
3569: AND pri.primary_flag = 'Y'

Line 3566: per_all_assignments_f pri

3562:
3563: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3564: SELECT pri.assignment_id
3565: FROM per_all_assignments_f sec,
3566: per_all_assignments_f pri
3567: WHERE sec.assignment_id = c_assgt_id
3568: AND sec.person_id = pri.person_id
3569: AND pri.primary_flag = 'Y'
3570: AND c_date BETWEEN pri.effective_start_date AND pri.effective_end_date

Line 3621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3617: -- =============================================================================
3618: -- Get_EE_Num:
3619: -- =============================================================================
3620: FUNCTION Get_EE_Num
3621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3623: ,p_effective_date IN Date
3624: ,p_error_message OUT NOCOPY Varchar2
3625: ,p_data_element_value OUT NOCOPY Varchar2

Line 3622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3618: -- Get_EE_Num:
3619: -- =============================================================================
3620: FUNCTION Get_EE_Num
3621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3623: ,p_effective_date IN Date
3624: ,p_error_message OUT NOCOPY Varchar2
3625: ,p_data_element_value OUT NOCOPY Varchar2
3626: ) RETURN Number IS

Line 3676: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3672: -- =============================================================================
3673: -- Get_Hire_Date
3674: -- =============================================================================
3675: FUNCTION Get_Hire_Date
3676: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3677: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3678: ,p_effective_date IN Date
3679: ,p_error_message OUT NOCOPY Varchar2
3680: ,p_data_element_value OUT NOCOPY Varchar2

Line 3677: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3673: -- Get_Hire_Date
3674: -- =============================================================================
3675: FUNCTION Get_Hire_Date
3676: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3677: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3678: ,p_effective_date IN Date
3679: ,p_error_message OUT NOCOPY Varchar2
3680: ,p_data_element_value OUT NOCOPY Varchar2
3681: ) RETURN Number IS

Line 3687: FROM per_all_assignments_f asg

3683:
3684: -- Cursor to get the hire date of the person
3685: /*Cursor csr_get_hire_date IS
3686: SELECT max(date_start)
3687: FROM per_all_assignments_f asg
3688: ,per_periods_of_service pps
3689: WHERE pps.person_id = asg.person_id
3690: AND asg.assignment_id = p_assignment_id
3691: AND pps.business_group_id = p_business_group_id

Line 3698: FROM per_all_assignments_f asg

3694:
3695: -- Cursor to get the hire date of the assignment
3696: CURSOR csr_get_hire_date IS
3697: SELECT min(effective_start_date)
3698: FROM per_all_assignments_f asg
3699: WHERE asg.assignment_id = p_assignment_id
3700: AND asg.business_group_id = p_business_group_id
3701: AND asg.assignment_type='E';
3702:

Line 3730: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3726: -- =============================================================================
3727: -- Get_Term_Reason
3728: -- =============================================================================
3729: FUNCTION Get_Term_Reason
3730: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3731: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3732: ,p_effective_date IN DATE
3733: ,p_error_message OUT NOCOPY VARCHAR2
3734: ,p_data_element_value OUT NOCOPY VARCHAR2

Line 3731: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

3727: -- Get_Term_Reason
3728: -- =============================================================================
3729: FUNCTION Get_Term_Reason
3730: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3731: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
3732: ,p_effective_date IN DATE
3733: ,p_error_message OUT NOCOPY VARCHAR2
3734: ,p_data_element_value OUT NOCOPY VARCHAR2
3735: ) RETURN NUMBER IS

Line 3744: per_all_assignments_f asg

3740: CURSOR c_get_end_reason_new IS
3741: SELECT SUBSTR(DECODE(NVL(leaving_reason,'OVE'),'D','OVL'
3742: ,NVL(leaving_reason,'OVE')),1,3)
3743: FROM per_periods_of_service pps,
3744: per_all_assignments_f asg
3745: WHERE asg.period_of_service_id = pps.period_of_service_id
3746: AND assignment_id = p_assignment_id
3747: AND p_effective_date BETWEEN effective_start_date AND
3748: effective_end_date ;

Line 3843: FROM per_all_assignments_f sec,

3839: and peev.effective_end_date );
3840:
3841: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3842: SELECT pri.assignment_id
3843: FROM per_all_assignments_f sec,
3844: per_all_assignments_f pri
3845: WHERE sec.assignment_id = c_assgt_id
3846: AND sec.person_id = pri.person_id
3847: AND pri.primary_flag = 'Y'

Line 3844: per_all_assignments_f pri

3840:
3841: CURSOR csr_get_primary_asg (c_assgt_id NUMBER, c_date DATE) IS
3842: SELECT pri.assignment_id
3843: FROM per_all_assignments_f sec,
3844: per_all_assignments_f pri
3845: WHERE sec.assignment_id = c_assgt_id
3846: AND sec.person_id = pri.person_id
3847: AND pri.primary_flag = 'Y'
3848: AND c_date BETWEEN pri.effective_start_date AND pri.effective_end_date

Line 3991: FROM per_all_assignments_f asg

3987: Return Number IS
3988:
3989: CURSOR csr_get_incidental_wkr_code(c_asg_id Number ,c_date_earned Date) IS
3990: SELECT Decode(scl.SEGMENT1,'Y','0','1')
3991: FROM per_all_assignments_f asg
3992: ,hr_soft_coding_keyflex scl
3993: WHERE asg.assignment_id = c_asg_id
3994: AND c_date_earned BETWEEN asg.effective_start_date
3995: AND asg.effective_end_date

Line 4047: FROM per_all_assignments_f asg

4043: )
4044: Return Number IS
4045: /*CURSOR csr_get_assgn_end_date(c_assignment_id NUMBER) IS
4046: SELECT max(actual_termination_date)
4047: FROM per_all_assignments_f asg
4048: ,per_periods_of_service pps
4049: WHERE pps.person_id = asg.person_id
4050: AND asg.assignment_id = c_assignment_id
4051: AND pps.business_group_id = p_business_group_id

Line 4056: FROM per_all_assignments_f paa,

4052: AND date_start <= p_effective_date;
4053:
4054: CURSOR csr_get_sec_assgn_end_date(c_assignment_id NUMBER,c_business_group_id NUMBER) IS
4055: SELECT paa.effective_start_date
4056: FROM per_all_assignments_f paa,
4057: per_assignment_status_types past
4058: WHERE paa.assignment_id = c_assignment_id
4059: AND paa.business_group_id = c_business_group_id
4060: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 4069: FROM per_all_assignments_f asg

4065:
4066: --
4067: CURSOR csr_get_term_date IS
4068: SELECT MIN(effective_start_date)-1 term_date
4069: FROM per_all_assignments_f asg
4070: WHERE assignment_id = p_assignment_id
4071: AND assignment_status_type_id IN (SELECT assignment_status_type_id
4072: FROM per_assignment_status_types
4073: WHERE per_system_status = 'TERM_ASSIGN'

Line 4081: FROM per_all_assignments_f asg

4077: -- Get the dates for any ended assignments. Note that this is for sec
4078: -- assignments only.
4079: --
4080: SELECT MAX(effective_end_date)
4081: FROM per_all_assignments_f asg
4082: WHERE assignment_id = p_assignment_id
4083: AND asg.primary_flag = 'N'
4084: AND NOT EXISTS( SELECT 1
4085: FROM per_all_assignments_f asg1

Line 4085: FROM per_all_assignments_f asg1

4081: FROM per_all_assignments_f asg
4082: WHERE assignment_id = p_assignment_id
4083: AND asg.primary_flag = 'N'
4084: AND NOT EXISTS( SELECT 1
4085: FROM per_all_assignments_f asg1
4086: WHERE asg1.assignment_id = p_assignment_id
4087: AND asg1.effective_start_date = asg.effective_end_date + 1
4088: AND asg.assignment_id = asg1.assignment_id )
4089: AND NOT EXISTS( SELECT 1

Line 4090: FROM per_all_assignments_f asg1

4086: WHERE asg1.assignment_id = p_assignment_id
4087: AND asg1.effective_start_date = asg.effective_end_date + 1
4088: AND asg.assignment_id = asg1.assignment_id )
4089: AND NOT EXISTS( SELECT 1
4090: FROM per_all_assignments_f asg1
4091: WHERE asg1.assignment_id = p_assignment_id
4092: AND asg1.effective_start_date < asg.effective_start_date
4093: AND asg.assignment_id = asg1.assignment_id
4094: AND asg1.assignment_status_type_id IN (SELECT assignment_status_type_id

Line 5057: FROM per_all_assignments_f asg

5053: )
5054: Return Number IS
5055: CURSOR csr_get_incidental_wkr_code(c_asg_id Number ,c_date_earned Date) IS
5056: SELECT Decode(scl.SEGMENT1,'Y','0','1')
5057: FROM per_all_assignments_f asg
5058: ,hr_soft_coding_keyflex scl
5059: WHERE asg.assignment_id = c_asg_id
5060: AND c_date_earned BETWEEN asg.effective_start_date
5061: AND asg.effective_end_date

Line 5201: FROM per_all_assignments_f

5197:
5198: -- Cursor to get Org id for the given asg id
5199: CURSOR csr_get_org_id(c_asg_id NUMBER,bg_id NUMBER) IS
5200: SELECT organization_id
5201: FROM per_all_assignments_f
5202: WHERE assignment_id = c_asg_id
5203: AND business_group_id = bg_id
5204: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
5205: effective_start_date AND effective_end_date;

Line 5209: Select max(effective_start_date) from per_all_assignments_f

5205: effective_start_date AND effective_end_date;
5206:
5207: --Cursor to get organization start date for that assignment
5208: CURSOR csr_get_org_asg_start_date(c_asg_id NUMBER,org_id NUMBER) IS
5209: Select max(effective_start_date) from per_all_assignments_f
5210: where assignment_id = c_asg_id
5211: and organization_id = org_id;
5212:
5213:

Line 5466: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

5462: -- the termination has happened before or on the effective date passed
5463: --============================================================================
5464: FUNCTION chk_term_asg_eff
5465: ( p_assignment_id IN Number
5466: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
5467: ,p_effective_date IN DATE
5468: ) RETURN Number IS
5469: CURSOR cur_chk_term IS
5470: SELECT 1 FROM per_periods_of_service

Line 5510: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

5506: -- Org_Id_Data Element:Returns Org Id to Fast formula
5507: -- =============================================================================
5508:
5509: FUNCTION Org_Id_DataElement
5510: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
5511: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
5512: ,p_effective_date IN Date
5513: ,p_error_message OUT NOCOPY Varchar2
5514: ,p_data_element_value OUT NOCOPY Varchar2

Line 5511: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

5507: -- =============================================================================
5508:
5509: FUNCTION Org_Id_DataElement
5510: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
5511: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
5512: ,p_effective_date IN Date
5513: ,p_error_message OUT NOCOPY Varchar2
5514: ,p_data_element_value OUT NOCOPY Varchar2
5515: ) RETURN Number IS

Line 5711: FROM per_all_assignments_f asg

5707:
5708: -------Cursor to check whether there is any change in incidental worker code
5709: CURSOR csr_chk_inci_code_chg_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
5710: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1
5711: FROM per_all_assignments_f asg
5712: ,hr_soft_coding_keyflex scl
5713: WHERE asg.assignment_id = c_asg_id
5714: AND (c_date - 1 BETWEEN asg.effective_start_date
5715: AND asg.effective_end_date)

Line 6553: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6549: --============================================================================
6550: --This is used to decide the Record010 hide or show
6551: --============================================================================
6552: FUNCTION Record010_Display_Criteria
6553: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6554: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6555: ,p_effective_date IN Date
6556: ,p_error_message OUT NOCOPY Varchar2
6557: ,p_data_element_value OUT NOCOPY Varchar2

Line 6554: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

6550: --This is used to decide the Record010 hide or show
6551: --============================================================================
6552: FUNCTION Record010_Display_Criteria
6553: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6554: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6555: ,p_effective_date IN Date
6556: ,p_error_message OUT NOCOPY Varchar2
6557: ,p_data_element_value OUT NOCOPY Varchar2
6558: ) RETURN Number IS

Line 6621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6617: --============================================================================
6618: --This is used to decide the Record_020 hide or show
6619: --============================================================================
6620: FUNCTION Record020_Display_Criteria
6621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6623: ,p_effective_date IN Date
6624: ,p_error_message OUT NOCOPY Varchar2
6625: ,p_data_element_value OUT NOCOPY Varchar2

Line 6622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

6618: --This is used to decide the Record_020 hide or show
6619: --============================================================================
6620: FUNCTION Record020_Display_Criteria
6621: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6622: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6623: ,p_effective_date IN Date
6624: ,p_error_message OUT NOCOPY Varchar2
6625: ,p_data_element_value OUT NOCOPY Varchar2
6626: ) RETURN Number IS

Line 6633: FROM per_all_assignments_f paa,

6629: CURSOR csr_chk_terminate_sec_asg ( c_assignment_id IN Number
6630: ,c_business_group_id IN Number
6631: ) IS
6632: SELECT min(paa.effective_start_date)
6633: FROM per_all_assignments_f paa,
6634: per_assignment_status_types past
6635: WHERE paa.assignment_id = c_assignment_id
6636: AND paa.business_group_id = c_business_group_id
6637: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 6645: FROM per_all_assignments_f paa

6641: CURSOR csr_chk_terminate_pri_asg ( c_assignment_id IN Number
6642: ,c_business_group_id IN Number
6643: ) IS
6644: SELECT max(paa.effective_end_date)
6645: FROM per_all_assignments_f paa
6646: WHERE paa.assignment_id = c_assignment_id
6647: AND paa.business_group_id = c_business_group_id;
6648:
6649: l_person_id per_all_people_f.person_id%TYPE;

Line 6716: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6712: --============================================================================
6713: --This is used to decide the Record_030 hide or show
6714: --============================================================================
6715: FUNCTION Record030_Display_Criteria
6716: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6717: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6718: ,p_effective_date IN Date
6719: ,p_error_message OUT NOCOPY Varchar2
6720: ,p_data_element_value OUT NOCOPY Varchar2

Line 6717: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

6713: --This is used to decide the Record_030 hide or show
6714: --============================================================================
6715: FUNCTION Record030_Display_Criteria
6716: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6717: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6718: ,p_effective_date IN Date
6719: ,p_error_message OUT NOCOPY Varchar2
6720: ,p_data_element_value OUT NOCOPY Varchar2
6721: ) RETURN Number IS

Line 6741: FROM per_all_assignments_f paa,

6737: CURSOR csr_chk_terminate_sec_asg (c_assignment_id IN Number
6738: ,c_business_group_id IN Number
6739: ) IS
6740: SELECT 'x'
6741: FROM per_all_assignments_f paa,
6742: per_assignment_status_types past
6743: WHERE paa.assignment_id = c_assignment_id
6744: AND paa.business_group_id = c_business_group_id
6745: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 6756: FROM per_all_assignments_f paa,

6752: CURSOR csr_get_asg_end_date (c_assignment_id IN Number
6753: ,c_business_group_id IN Number
6754: ) IS
6755: SELECT paa.effective_end_date
6756: FROM per_all_assignments_f paa,
6757: per_assignment_status_types past
6758: WHERE paa.assignment_id = c_assignment_id
6759: AND paa.business_group_id = c_business_group_id
6760: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 6896: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6892: --============================================================================
6893: --This is used to decide the Record_040 hide or show
6894: --============================================================================
6895: FUNCTION Record040_Display_Criteria
6896: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6897: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6898: ,p_effective_date IN Date
6899: ,p_error_message OUT NOCOPY Varchar2
6900: ,p_data_element_value OUT NOCOPY Varchar2

Line 6897: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

6893: --This is used to decide the Record_040 hide or show
6894: --============================================================================
6895: FUNCTION Record040_Display_Criteria
6896: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6897: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
6898: ,p_effective_date IN Date
6899: ,p_error_message OUT NOCOPY Varchar2
6900: ,p_data_element_value OUT NOCOPY Varchar2
6901: ) RETURN Number IS

Line 7083: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7079: --============================================================================
7080: --This is used to decide the Record_060 hide or show
7081: --============================================================================
7082: FUNCTION Record060_Display_Criteria
7083: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7084: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7085: ,p_effective_date IN Date
7086: ,p_error_message OUT NOCOPY Varchar2
7087: ,p_data_element_value OUT NOCOPY Varchar2

Line 7084: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

7080: --This is used to decide the Record_060 hide or show
7081: --============================================================================
7082: FUNCTION Record060_Display_Criteria
7083: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7084: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7085: ,p_effective_date IN Date
7086: ,p_error_message OUT NOCOPY Varchar2
7087: ,p_data_element_value OUT NOCOPY Varchar2
7088: )

Line 7114: FROM per_all_assignments_f paa,

7110:
7111:
7112: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7113: SELECT 'x'
7114: FROM per_all_assignments_f paa,
7115: per_assignment_status_types past
7116: WHERE paa.assignment_id = c_asg_id
7117: AND paa.business_group_id = bg_id
7118: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 7127: FROM per_all_assignments_f PAA

7123: ,c_assignment_id IN NUMBER
7124: ,c_date_earned IN DATE
7125: ) IS
7126: SELECT NVL(period_num,0)
7127: FROM per_all_assignments_f PAA
7128: ,per_time_periods TPERIOD
7129: WHERE
7130: PAA.assignment_id = c_assignment_id
7131: AND TPERIOD.payroll_id = PAA.payroll_id

Line 7213: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7209: --============================================================================
7210: --This is used to decide the Record_070 hide or show
7211: --============================================================================
7212: FUNCTION Record070_Display_Criteria
7213: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7214: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7215: ,p_effective_date IN DATE
7216: ,p_error_message OUT NOCOPY Varchar2
7217: ,p_data_element_value OUT NOCOPY Varchar2

Line 7214: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

7210: --This is used to decide the Record_070 hide or show
7211: --============================================================================
7212: FUNCTION Record070_Display_Criteria
7213: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7214: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7215: ,p_effective_date IN DATE
7216: ,p_error_message OUT NOCOPY Varchar2
7217: ,p_data_element_value OUT NOCOPY Varchar2
7218: ) RETURN Number IS

Line 7222: FROM per_all_assignments_f paa,

7218: ) RETURN Number IS
7219:
7220: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7221: SELECT 'x'
7222: FROM per_all_assignments_f paa,
7223: per_assignment_status_types past
7224: WHERE paa.assignment_id = c_asg_id
7225: AND paa.business_group_id = bg_id
7226: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 7232: FROM per_all_assignments_f paa,

7228: AND (eff_date between paa.effective_start_date and paa.effective_end_date);
7229:
7230: CURSOR csr_chk_active_asg_period(c_asg_id NUMBER,bg_id NUMBER) IS
7231: SELECT 'x'
7232: FROM per_all_assignments_f paa,
7233: per_assignment_status_types past
7234: WHERE paa.assignment_id = c_asg_id
7235: AND paa.business_group_id = bg_id
7236: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 7329: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7325: --============================================================================
7326: --This is used to decide the Record_080 hide or show
7327: --============================================================================
7328: FUNCTION Record080_Display_Criteria
7329: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7330: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7331: ,p_effective_date IN DATE
7332: ,p_error_message OUT NOCOPY Varchar2
7333: ,p_data_element_value OUT NOCOPY Varchar2

Line 7330: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

7326: --This is used to decide the Record_080 hide or show
7327: --============================================================================
7328: FUNCTION Record080_Display_Criteria
7329: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7330: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7331: ,p_effective_date IN DATE
7332: ,p_error_message OUT NOCOPY Varchar2
7333: ,p_data_element_value OUT NOCOPY Varchar2
7334: ) RETURN Number IS

Line 7379: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

7375: --============================================================================
7376: --This is used to decide the Record_081 hide or show
7377: --============================================================================
7378: FUNCTION Record081_Display_Criteria
7379: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7380: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7381: ,p_effective_date IN DATE
7382: ,p_error_message OUT NOCOPY Varchar2
7383: ,p_data_element_value OUT NOCOPY Varchar2

Line 7380: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

7376: --This is used to decide the Record_081 hide or show
7377: --============================================================================
7378: FUNCTION Record081_Display_Criteria
7379: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
7380: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
7381: ,p_effective_date IN DATE
7382: ,p_error_message OUT NOCOPY Varchar2
7383: ,p_data_element_value OUT NOCOPY Varchar2
7384: ) RETURN Number IS

Line 7388: FROM per_all_assignments_f paa,

7384: ) RETURN Number IS
7385:
7386: CURSOR csr_chk_active_asg(c_asg_id NUMBER,bg_id NUMBER,eff_date DATE) IS
7387: SELECT 'x'
7388: FROM per_all_assignments_f paa,
7389: per_assignment_status_types past
7390: WHERE paa.assignment_id = c_asg_id
7391: AND paa.business_group_id = bg_id
7392: AND paa.assignment_status_type_id=past.assignment_status_type_id

Line 7398: FROM per_all_assignments_f paa,

7394: AND (eff_date between paa.effective_start_date and paa.effective_end_date);
7395:
7396: CURSOR csr_chk_active_asg_period(c_asg_id NUMBER,bg_id NUMBER) IS
7397: SELECT 'x'
7398: FROM per_all_assignments_f paa,
7399: per_assignment_status_types past
7400: WHERE paa.assignment_id = c_asg_id
7401: AND paa.business_group_id = bg_id
7402: AND paa.assignment_status_type_id=past.assignment_status_type_id