APPS.PAY_MX_FF_UDFS dependencies on PAY_ALL_PAYROLLS_F

Line 1192: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1188: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1189: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1190: lb_gre_ambiguous BOOLEAN;
1191: lb_gre_missing BOOLEAN;
1192: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1193: lv_contract_name VARCHAR2(240);
1194: ld_idw_report_date DATE;
1195: ld_idw_start_date DATE;
1196:

Line 1713: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1709: ln_days_month NUMBER;
1710: ln_legal_emp_id hr_all_organization_units.organization_id%TYPE;
1711: ln_contract_days pay_user_column_instances_f.value%TYPE;
1712:
1713: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1714: rv_contract_name VARCHAR2(80);
1715:
1716: lb_contract_exists BOOLEAN;
1717: BEGIN

Line 1750: FROM pay_all_payrolls_f ppf,

1746: THEN
1747: --{
1748: SELECT period_type
1749: INTO lv_period_type
1750: FROM pay_all_payrolls_f ppf,
1751: fnd_sessions fs
1752: WHERE payroll_id = p_payroll_id
1753: AND fs.effective_date BETWEEN ppf.effective_start_date
1754: AND ppf.effective_end_date

Line 1900: lv_period_type pay_all_payrolls_f.period_type%TYPE;

1896:
1897: ln_base_pay NUMBER;
1898: ln_daily_base_pay NUMBER;
1899: ln_days_in_a_month NUMBER;
1900: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1901:
1902: BEGIN
1903: hr_utility.trace('Begin Get Base Pay for Tax Calculation');
1904:

Line 1929: FROM pay_all_payrolls_f ppf,

1925: ELSE
1926:
1927: SELECT period_type
1928: INTO lv_period_type
1929: FROM pay_all_payrolls_f ppf,
1930: fnd_sessions fs
1931: WHERE payroll_id = p_payroll_id
1932: AND fs.effective_date BETWEEN ppf.effective_start_date
1933: AND ppf.effective_end_date