APPS.PAY_MX_FF_UDFS dependencies on PAY_ALL_PAYROLLS_F

Line 1040: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1036: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1037: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1038: lb_gre_ambiguous BOOLEAN;
1039: lb_gre_missing BOOLEAN;
1040: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1041: lv_contract_name VARCHAR2(240);
1042: ld_idw_report_date DATE;
1043: ld_idw_start_date DATE;
1044:

Line 1558: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1554: ln_days_month NUMBER;
1555: ln_legal_emp_id hr_all_organization_units.organization_id%TYPE;
1556: ln_contract_days pay_user_column_instances_f.value%TYPE;
1557:
1558: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1559: rv_contract_name VARCHAR2(80);
1560:
1561: lb_contract_exists BOOLEAN;
1562: BEGIN

Line 1595: FROM pay_all_payrolls_f ppf,

1591: THEN
1592: --{
1593: SELECT period_type
1594: INTO lv_period_type
1595: FROM pay_all_payrolls_f ppf,
1596: fnd_sessions fs
1597: WHERE payroll_id = p_payroll_id
1598: AND fs.effective_date BETWEEN ppf.effective_start_date
1599: AND ppf.effective_end_date

Line 1745: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1741:
1742: ln_base_pay NUMBER;
1743: ln_daily_base_pay NUMBER;
1744: ln_days_in_a_month NUMBER;
1745: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1746:
1747: BEGIN
1748: hr_utility.trace('Begin Get Base Pay for Tax Calculation');
1749:

Line 1774: FROM pay_all_payrolls_f ppf,

1770: ELSE
1771:
1772: SELECT period_type
1773: INTO lv_period_type
1774: FROM pay_all_payrolls_f ppf,
1775: fnd_sessions fs
1776: WHERE payroll_id = p_payroll_id
1777: AND fs.effective_date BETWEEN ppf.effective_start_date
1778: AND ppf.effective_end_date