APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_PAYROLLS_F

Line 342: select payroll_name from pay_payrolls_f

338:
339: /* Payroll Name */
340: CURSOR csr_payroll_name(id pay_all_payrolls_f.payroll_id%type)
341: IS
342: select payroll_name from pay_payrolls_f
343: where payroll_id=id;
344:
345: -- rg_csr_payroll_name csr_payroll_name%rowtype;
346: l_payroll_name VARCHAR2(100):=NULL;

Line 363: pay_payrolls_f ppf,

359: ,'Week' ,'3'
360: ,'Lunar Month' ,'4') PAYROLL_PERIOD,
361: ptp.TIME_PERIOD_ID
362: FROM
363: pay_payrolls_f ppf,
364: per_assignments_f paf,
365: hr_organization_units hou,
366: hr_organization_information hoi,
367: hr_soft_coding_keyflex scl,

Line 403: FROM pay_payrolls_f ppf

399: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
400:
401: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
402: SELECT PRL_INFORMATION1, Payroll_name
403: FROM pay_payrolls_f ppf
404: WHERE PAYROLL_ID = p_payroll_id
405: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
406:
407: l_use_holiday_card_1 VARCHAR2(10) := 'N';

Line 408: l_pyrl_name_1 pay_payrolls_f.Payroll_name%type;

404: WHERE PAYROLL_ID = p_payroll_id
405: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
406:
407: l_use_holiday_card_1 VARCHAR2(10) := 'N';
408: l_pyrl_name_1 pay_payrolls_f.Payroll_name%type;
409: l_uhc_payroll_1 VARCHAR2(10);
410:
411: BEGIN
412:

Line 1024: ,pay_payrolls_f ppf

1020: ,NVL(scl.SEGMENT23,'FH1') FH_CODE
1021: FROM
1022: per_all_people_f papf
1023: ,per_all_assignments_f paaf
1024: ,pay_payrolls_f ppf
1025: ,hr_soft_coding_keyflex scl
1026: WHERE paaf.person_id = p_person_id
1027: AND papf.PERSON_ID = paaf.PERSON_ID
1028: AND ppf.payroll_id = p_payroll_id

Line 1253: pay_payrolls_f ppf,

1249: --ppf.payroll_name,
1250: --ptp.period_name
1251:
1252: FROM
1253: pay_payrolls_f ppf,
1254: per_assignments_f paf,
1255: per_time_periods ptp
1256: WHERE paf.payroll_id = ppf.payroll_id
1257: AND paf.assignment_id=c_assignment_id

Line 1461: FROM pay_payrolls_f ppf

1457: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1458:
1459: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
1460: SELECT PRL_INFORMATION1, Payroll_name
1461: FROM pay_payrolls_f ppf
1462: WHERE PAYROLL_ID = p_payroll_id
1463: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1464:
1465: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS

Line 1662: l_pyrl_name pay_payrolls_f.Payroll_name%type;

1658: --l_hol_pay_0202_sp NUMBER(12,2);
1659:
1660: l_use_holiday_card VARCHAR2(10) := 'N';
1661: l_uhc_payroll VARCHAR2(10);
1662: l_pyrl_name pay_payrolls_f.Payroll_name%type;
1663:
1664: l_sal_hol_acr_amt NUMBER(12,2);
1665: l_sal_hol_acr_tax NUMBER(12,2);
1666: l_sal_hol_acr_amb NUMBER(12,2);

Line 1911: pay_payrolls_f ppf,

1907:
1908: /*
1909: l_select_qry := l_select_str
1910: ||' FROM
1911: pay_payrolls_f ppf,
1912: per_assignments_f paf,
1913: per_time_periods ptp
1914: WHERE paf.payroll_id = ppf.payroll_id
1915: AND paf.assignment_id= ' || l_ass_id